Entity Framework вопросы и ответы для интервью

Вопрос 6. What is Eager Loading in Entity Framework?

Eager Loading is the opposite of Lazy Loading. It loads the related entities along with the main entity in a single database query.

Вопрос 7. How can you disable Lazy Loading in Entity Framework?

You can disable Lazy Loading by setting the LazyLoadingEnabled property of the DbContext to false.

Вопрос 8. Explain the Code First Conventions in Entity Framework.

Code First Conventions are a set of rules that automatically configure the database schema based on the shape of your entity classes and their relationships.

Вопрос 9. What is the Database First approach in Entity Framework?

Database First is an approach where the data model is generated from an existing database, and the corresponding classes are created in the application.

Вопрос 10. How can you execute raw SQL queries in Entity Framework?

You can use the SqlQuery method of the Database property in DbContext to execute raw SQL queries.

Example:

var result = context.Database.SqlQuery("SELECT * FROM MyTable");