Difference between ADO.Net and Entity Framework in ASP.Net

Last Reply 21 days ago By dharmendr

Posted 21 days ago

Which method is best method for crud operation in MVC5?

As there are MVC5 using Ado.net and entity framework with models, which method is faster?

You are viewing reply posted by: dharmendr 21 days ago.
Posted 21 days ago

Hi SUJAYS,

Entity framework is ORM Model, which used LINQ to access database and code is auto generated whereas ADO.Net code is larger than Entity Framework.

The main and the only benefit of Entity framework is it auto-generates code for the Model (middle layer), Data Access Layer and mapping code, thus reducing a lot of development time.

Entity Framework is a wrapper for ADO.NET. There is nearly no difference between those two in performance (maybe Entity framework is bit slower).

But ADO.Net is faster than Entity framework as Entity framework uses ADO.Net in background.

What you use depends totally on your preference.

For more details refer below links.

ADO.NET Vs Entity Framework

ADO.NET vs entity framework performance

Entity Framework VS ADO.NET