I'm not sure what your price range is, but I have a couple suggestions:
I agree with Sassy Auburn, you really do need a good primer if you want it to stick. I use Smashbox, Laura Mercier's is good, and I've heard some good dupes are ELF and Palladio.
As for foundations that are really resistant, MAC's Studio Fix fluid stays on really well and provides great coverage, plus there are like a billion shades of it. The foundation I use which seems to hold up in any kind of weather, is Laura Mercier's silk creme foundation. I love it, but it's kinda pricey, at $42 a bottle. MAC Studio Fix is $26.50, so I'd say go with Studio Fix and try everything cheaper before you go for Laura Mercier if you can.