1,105,242 Community Members

Entity Framework VS Pure ADO.net

Member Avatar
elpitiya
Newbie Poster
1 post since Dec 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Member Avatar
__avd
Posting Genius (adatapost)
6,703 posts since Oct 2008
Reputation Points: 1,811 [?]
Q&As Helped to Solve: 1,272 [?]
Skill Endorsements: 61 [?]
Moderator
 
0
 

ADO.NET or EF? It is all depends upon you and your skill. Go with what you are comfortable.

Member Avatar
JorgeM
IT Addict
6,400 posts since Dec 2011
Reputation Points: 581 [?]
Q&As Helped to Solve: 958 [?]
Skill Endorsements: 172 [?]
Moderator
Featured
Sponsor
 
0
 

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

Member Avatar
Ramesh S
Posting Pro
584 posts since Jun 2009
Reputation Points: 129 [?]
Q&As Helped to Solve: 113 [?]
Skill Endorsements: 8 [?]
 
1
 

Hi,
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.
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article