The main requirement is a microphone input connection in your camera!
Simple camera models often offer a mini-jack socket, named "Mic" or "Mic in", professional units have 3 pin XLR connectors, one each for left and right.
In most cases, XLR connectors deliver the so called phantom power, therefore, any professional microphone, be it a dynamic or a condenser model can be connected according to the application. As this is a balanced connection, the cable length has no influence on the sound quality!
A mini-jack input works best with battery powered condenser microphones (like MCE 72/-82/-86 S/-85 BA) and sometimes with dynamic mics. The connection cable should be as short as possible to minimize the risk of stray pick-up.