when developing a web application both above mentioned technologies can be used. LINQ to Entity Framework is good for Quick development while Pure ADO.net needs lots of Codes. but want to know for Small/Mediam web application which approach is best. I'm considering only performace and adding new component so frequently.

Edited by __avd: Removed html tags

4 Years
Discussion Span
Last Post by Ramesh S

I would agree. There is not enough information for anyone to really tell you which way to go. Go with what you know.

Edited by JorgeM


I Would suggest to use Entity Framework as it has many new features over ADO.NET.

  1. In EF, objects are mapped with database tables. So you don't need to write stored procedures, queries in SQL to fetch data. You can use Linq queies against objects in C# which will retrieve data using EF.
  2. Code First feature allows you to create the domain model in the C# code and write business logic on them without creating the db design first. You can create the database based on your domain model.
  3. Since all the db related code is written in your VS projects, the same can be managed in the version control from the IDE. Whereas the stored procedure to be used in ADO.NET stored in the database.
  4. You can still use stored procedures, Views and Functions in EF if needed.
  5. EF is recommended technology used to retrived data in ASP.NET MVC Framework.
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.