Explore topic-wise InterviewSolutions in .

Architecture of ENTITY Framework with its components
Below is the Architecture or Entity Framework details components



EDM (Entity Data Model):- EDM MAINLY consists of three mainparts
(1)Conceptual Model
(2)Storage Model
(3)Mapping
(1)Conceptual Model:- This model contains the model classes and their relationships. This will be independent from database table DESIGN.
(2)Storage Model:-This model is databas design model which have tables, viws, stored procedures and their relationships and keys.
(3)Mapping:-This contains infromation about how the concptual model is mapped to storage model.
Now we will cover different other topics of Entity framework model
(1)LINQ to Entities
(2)Entity SQL
(3)Object Service
(4)Entity Client Data Provider
(5)ADO.NET Data Provider
(1)LINQ to Entities(L2E):- It is a query language which is used to write query against the object model. This return entities which defined in the conceptual model.
(2)Entity SQL:-It is also a query language which is only used for EF 6. But is is little more difficult then L2E. And devloper need to learn it SEPARATELY.
(3)Object Service:-It is main point for accessing data and return of data back to database. It alos included in PROCESS of converting data returned from an entity client data provider to and entity object structure which is also called materialization.
(4)Entity Client Data Provider:- Its communicate with ADO.NET data provider whihc helps in sending and returning data from database. ANd other main work of this is to convert L2E or Entity SQL queries into SQl query so that is understand by the database.
(5)ADO.NET Data Provider:-This layer communicates with database using Standard ADO.NET.

What is Entity Framework
Before .NET 3.5 version we used ADO.NET Code or Enterprise data Access Block to retrieve and save data from the database. Here we will create a data connection and create DataSet to fetch or submit data to the database. And convert data from the dataset to.net Objects to apply business RULES. This was a cumbersome and ERROR prone process. Then Micorsoft has provided a framework "Entity Framework" called to automate all these database

Entity Framework(EF) is and open source ORM Framework for .NET applications which is suppoeted by MIROSOFT. It helps devloper to work with data by using objects of domain specific classes without knowing about the underlying database tables where data is stored. With the help of Entity Frameowrk devlopers can work at higher LEVEL of abstraction when we work with data, and we can create and maintain data-oriented applications with less code then previous code.

Below is the figure which will let you know the Entity Framework

Different EF and EF Core Version History
Below are the different EF and EF Core Version
(1)EF Version
EF Version Release YEAR .NET Framework
(i)EF 6 2013 .NET 4.0 & .NET 4.5, VS 2012
(ii)EF 5 2012 .NET 4.0, VS 2012
(iii)EF 4.3 2011 .NET 4.0, VS 2012
(iv)EF 4.0 2010 .NET 4.0, VS 2010
(v)EF 1.0(3.5) 2008 .NET 3.5 SP1,VS 2008

(2)EF Core Version History
EF Core Version Release Year .NET Framework
(i)EF Core 2.0 August 2017 .NET Core 2.0, VS 2017
(ii)EF Core 1.1 November 2016 .NET Core 1.1
(iii)EF Core 1.0 JUNE 2016 .NET Core 1.0