ADO.NET vs EntityFramework , What to choose ?

Question

Hello From last few days , one question raised in my mind That What to Choose between ADO.NET vs EntityFramework I am working as a .NET Developer(Joined Few Days Ago) So our trainer told us to follow ADO.NET rather than EntityFramework Because they give priority to ADO.NET But as per i have studied about EF , i think there is lot more advantage of EF rather than ADO.NET So i want some depth reply of your's , that what kind of data access mechanism you are using for big projects/Enterprise projects Thanks ....

Bikesh Srivastava · Answer

Entity framework is better than other.

Chetan Ranpariya · Answer

Hi Manav, None of them are better than each other. They have their pros and cons. Using EF is relatively easy. It's just about the creating classes and mapping them to SQL tables and use built in classes to query and store data in the database. Connection Opening, Closing etc all are taken care by EF. Database operations are very simple. As simple as adding object to collection and calling Save method. Easy to manage the changes when database changes. But EF comes with bit of a perfomance cost and offers very little customization. When you select entity using EF all the columns selected from the table which some time is not necessary. In ADO.NET you can have flexibility of creating your own SQL query and running it using SQL Command. You can store the query output in whichever data structure you like such as datatable, dataview, entities etc. With efficiently written queries you can have performance advantage also. ADO.NET makes you write lot of code for the basic operations such as connection open and close, connection pooling, creating command and parameters etc. Changes in the database can cause a very big issue such a change in table structure,table added or removed from db etc. While ADO.NET is a proven technology for database operations from application, EF is widely accepted and providing in-built support by various latest MS app development frameworks such as ASP.NET MVC and MS Web API. I personally prefer to use EF as it eases the development efforts and I like to do customization on top of the features offered by it. Thanks and regards, Chetan Ranpariya

Manav Pandya · Answer

@Chetan Thanks for replying Chetan Rupareliya Sir Our thought's are mutual :) But i dont like ADO.NET bcoz it takes time to do operation