Learning ASP.NET Core MVC Programming

The Entity Framework

The Entity Framework is the Object Relational Mapping (ORM) framework that enables developers to work on domain-specific objects directly for data access instead of working on database queries. This reduces a lot of the code complexity in the data access layer in the application.

Before discussing the Entity Framework and its features, let us pause for a moment and think about the steps that we follow when we try to save some information to the database when using ADO.NET:

1. Construct the business domain object.
2. Create a connection to your database.
3. Open the connection.
4. Create a command object along with the command type.
5. Add the properties of your business domain object to the parameters of the command object.
6. Execute the command ...