MCSD Entity Framework and Data Access 2

Question 1

Which Entity Framework method is used to eagerly load a related entity in a query?

Accepted Answer

.Include()

Answer

The `.Include()` method tells Entity Framework to fetch related entities in the same SQL query using a JOIN.

Question 2

What is the Repository pattern used for in .NET data access?

Accepted Answer

Abstracting data access logic behind an interface to decouple it from business logic

Answer

The Repository pattern encapsulates data access logic behind an abstraction, making business logic independent of the data source.

Question 3

In Entity Framework, what does `SaveChanges()` do?

Accepted Answer

Persists all tracked entity changes to the database in a single transaction

Answer

`SaveChanges()` commits all pending Add, Modify, and Delete operations tracked by the DbContext to the database.

Question 4

What does the `AsNoTracking()` method do in Entity Framework?

Accepted Answer

Returns entities without change tracking, improving performance for read-only queries

Answer

`AsNoTracking()` returns entities that the DbContext does not track, reducing memory overhead for read-only scenarios.

Question 5

Which approach in Entity Framework generates database tables from existing C# classes?

Accepted Answer

Code-First

Answer

Code-First allows developers to define the database schema using C# classes, and EF generates or migrates the database tables.

MCSD Exam Practice Test