Q#1. What is Entity Framework?
Ans. Entity Framework is an ORM from Microsoft that will enable the developers to work with domain specific objects, which eliminates the extra code being written in the data access layer.
Q#2. Mention what is the key advantage of using Entity Framework or EF?
Ans. The main advantage of using Entity Framework or EF is that it generates code automatically for the Model (Middle Layer), Mapping code and Data Access Layer. It reduces a lot of time during the development process.
Q#3. Why to use Entity Framework?
Ans. Writing ADO.NET code and managing it is a tedious job. To avoid this, Microsoft has provided a solution - Entity Framework. Entity Framework reduces a great deal of code by enabling to work with relational data as domain specific objects.
Q#4. Mention in what all scenarios Entity Framework can be applicable?
Ans. Entity Framework can be applicable in three scenarios
If you have existing database already or you want to build your database first than other parts of the application
If your prime focus is your domain classes and then create the database from your domain classes
If you want to design your database schema on the visual designer and create the classes and database
Q#5. What are the components of Entity Framework Architecture?
Ans. Below are the components of Entity Framework –
Entity Data Model (EDM)
LINQ to Entities
Entity SQL
Object Service
Entity Client Data Provider
ADO.Net Data Provider
Q#6. Explain what does .edmx file contains?
Ans. .edmx file is an XML file, which declares a conceptual model, a storage model and the mapping between these models. This file also consists the information that is used by ADO.NET entity data model designer to render a model graphically. It consists of all the mapping details of how object maps with SQL tables. It is divided into three categories SSDL, CSDL, and MSL.
Q#7. What are the parts of Entity Data Model (EDM)?
Ans. Below are the parts of Entity Data Model –
Conceptual Model
Mapping
Storage Model
Q#8. Explain why T4 entity is important in Entity Framework?
Ans. T4 entity is important in Entity framework as it is the heart of entity framework code generation. It reads the EDMX XML file and generate C# behind code.
Q#9. How to create Entity Data Model (EDM)?
Ans. Add New Item -> ADO.NET Entity Data Model, which generates file with .edmx extension.
Q#10. Explain how you can load related entities in EF (Entity Framework)?
Ans. You can load related entities or data in EF in three ways
Eager Loading
Lazy Loading
Explicit Loading