Ado.net and entity framework which one is better for a mid size level

Question

Ado.net and entity framework which one is better for a mid size level application..??

Rajanikant Hawaldar · Answer

Entity Framework is is not faster than ado.net, Mostly only crud then you can go for ado, to me better would not be faster but more flexible

Sachin Singh · Answer

I will prefer EntityFramework. But if you have DB centric application meaning the application heavily depends on views and stored procedures then better go with ADO.NET or Dapper.

Vishal Yelve · Answer

Entity Framework consists of wrapper classes for ADO dot NET and so you can do the database coding much more faster with it. While using EF you gain the following things: Less code lines. Development of the project increases. Maintainability increases. Entity Framework example to read the records: using (var context = new CompanyContext()) { var emp = context.Employee; } ADO dot NET example to read the records: SqlCommand command = new SqlCommand("SELECT * FROM Employee;", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { // do some coding } else { // do some coding } reader.Close(); }

Nitin Sontakke · Answer

Personally, I prefer Dapper, which I believe is best of both the worlds.

Sam Hobbs · Answer

Vishal Yelve is correct that Entity Framework can use ADO.Net. Entity Framework can also work with other objects (databases and other things). Entity Framework does more than what ADO.Net does. Entity Framework can make things easier but it takes more time to learn. Time invested in learning Entity Framework is well spent. The real benefits of EF are that it can automatically create classes for database items. In EF, database items are called entities. EF can do most all the common work of working with databases; you just need to write the code specific to your requirements.