I used Face & Body foundation for my wedding and I've worn it both before and since. Every time, it's stayed on until I take it off. The only problem is that I need to do multiple coats because it's so sheer. It looks like my skin only better and it photographs beautifully.
Pros:Stays on all day *and* night, doesn't sweat off, doesn't run with tears, basically it doesn't budge, looks like my natural skin, feels so lightweight sometimes I forget I'm wearing it. Cons:Need multiple applications for good coverage, have to wait between each "coat" for the foundation to dry, which takes a little while. Also, it has a strong fragrance which could be a problem for some people and the glass bottle, while durable, is a little heavy.