Working with the Entity Framework

The Entity Framework (EF) is an Object Relational Mapper (ORM) framework developed by Microsoft. It was developed for .NET developers to work with databases easily using entity objects. It sits in the middle of your backend code or business logic and the database. It allows the developer to write code in the application language, C#, to talk with the database. This means that there is no need to use and write the ADO.NET code manually, which we did in the preceding sections. EF has different kinds of commands to the normal SQL commands. EF commands, which look very similar to C# code, will communicate with the database using SQL in the background. It can communicate with any type of data source, so you don't have to worry about setting up or writing different code for each DBMS.

...