which one used for connect to the data base in asp.net

Question

Hi..friends..

 

i have one doubted in real project connect to the Database(sql Server) mostly  following  which one technique used  in asp.net project and MVC real time project  .

please give  me your valueable comment ,suggest.

 

1) ADO.NET(with Query and Store procedure)

 

2)Linq To SQL 

 

3) Enity framework(Code first Approach,Data first Approach and Model first Approach)