Which is best to use in ASP.Net MVC ADO.Net or Entity Framework

on Aug 17, 2018 09:13 AM


i want fatch data from ERP database ,its having all lots stored procedure ,i want fatch data in MVC Application which database connectitvity  is best ADO.NET OR Entity framework ???.


Please provide your commands...


Thanks & Regards,




Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Aug 20, 2018 12:36 AM

Hi venkatg,

They are both pretty good and both perfectly usable in ASP.NET MVC. You'll tend to see more examples using EF than raw ADO.Net, but EF has some drawbacks and limitations. ADO.Net has been pretty stable.

So its better if you use ADO.Net.

EF can't be faster. But it makes development much faster and improves maintainability of your code. I mean using Linq queries with EF requires you to write less code.