May i know the different between this three type of database connection component ?

Anyone can gv me the comparison, advantages , pros and cons :-)

What certain condition to use it ?