i

ASP.Net A Complete Guide

Entity Data Model

The EDM is an extended version of the Entity-Relationship model. It specifies the conceptual model of the data by using the various modeling technique. It describes data structure, regardless of its stored form.

Below are the three main parts of EDM:

  • The Storage Schema Model

  • The Conceptual Model

  • The Mapping Model

The Storage Schema Model

It represents the schematic representation of the backend storage of data. Entity framework builds this model for the database schema.

The Mapping Model

This mapping model has the information between the Conceptual model & the Storage model.

The Conceptual Model

It is the real entity model, against which we write our queries.

Entity Framework performs CRUD operations using the EDM.

 EF can do below operation:

  • The SQL queries from LINQ queries

  • Building INSERT, UPDATE, and DELETE commands.

  • Transform database result into entity objects.