Best Foundation?

Okay so I am an exotic dancer which means I need to look good but I also sweat at work. The foundation I use now is urban decay and it cakes and separates. By the end of the night it's all blotchy and caked . Not a good look ! I need a foundation and powder that would be best for my line of work! Also I need something g that makes my skin look flawless that is heavy coverage ! Pls help ! Thank you all !