ADO.NET vs EntityFramework , What to choose ?

@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  

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