Click here to Skip to main content
15,889,281 members
Please Sign up or sign in to vote.
1.15/5 (5 votes)
See more:
Hello everybody, I am new into Entity Framework. Can anybody explain me the advantages of using EF over ADO.Net and the disadvantages of EF too, with the help of example?
Posted
Updated 29-Apr-20 1:40am
Comments
[no name] 27-Jul-15 13:56pm    
http://www.bing.com/search?q=Advantages+and+disadvantages+of+using+Entity+Framework

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!

So start with google, and then start reading...
 
Share this answer
 
Advantages of Entity Framework
The advantages of EF are given bellow:

It provides auto generated code
It reduce development time
It reduce development cost
It enables developers to visually design models and mapping of database
It provides capability of programming a conceptual model.
It provides unique syntax (LINQ / Yoda) for all object queries whether it is database or not
It allow multiple conceptual models to mapped to a single storage schema
It’s easy to map business objects (with drag & drop tables).
Disadvantages of Entity Framework
The disadvantages of EF are given bellow:

Lazy loading is the main drawbacks of EF
Its syntax is complicated
Its logical schema is not able to understand business entities and relation among each other
Logical schema of database is not capable of using certain parts of application
It is not available for every RDMS
Need to handle data in nontraditional way
It does not work if we change any schema of the database. We need to update the schema on the solution.
It is not good for huge domain model.
 
Share this answer
 
Comments
Patrice T 1-Jan-18 22:25pm    
Too late, homework was due 2 years and a half ago.
DL001 6-Nov-18 12:27pm    
You can create pure ado.net data layer using T4 which also generates auto generated code and reduces development time, reduces cost but out performs Entity Framework in every way possible, so not really a benefit.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900