Get yourself a Glock 27 either in a 9mm or a .40 and be done with it.

And you can't carry one in church unless you have permission to.