What are the advantages of using ADO.NET Entity Framework?

.net entity-framework orm

Question

I thought this essay on Entity Framework for ADO.NET to be quite intriguing even if I had a hard time understanding most of it at first. I'm rereading the article to try to understand the true reasoning behind this.

a) The subject of why we need an ORM framework (generally) has come to mind.

b) Why would we choose ADO.NET Entity Framework over alternative ORM frameworks for.NET like Spring.NET, Linq to SQL, NHibernate, etc.?

1
6
2/20/2010 11:00:20 AM

Accepted Answer

b. Personal. Given that I haven't tried EF, I may not be able to provide a reliable evaluation.

10
5/23/2017 12:00:17 PM

Popular Answer

There are several benefits. Important ones include:

  1. Dedicated CRUD operation capability is offered (Create, Read, Update, Delete). Implementing CRUD operations is simple.

  2. Since all data access logic is provided at a higher level, replacing the data store is quite simple and doesn't need changing the data access logic.

  3. Relationships between tables that are one to one, one to many, and many to many are simple to handle.

  4. Better ways may be found to express conceptual models.

  5. Classes and subclasses allow developers to condense their data access code.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow