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.?
There are several benefits. Important ones include:
Dedicated CRUD operation capability is offered (Create, Read, Update, Delete). Implementing CRUD operations is simple.
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.
Relationships between tables that are one to one, one to many, and many to many are simple to handle.
Better ways may be found to express conceptual models.
Classes and subclasses allow developers to condense their data access code.