Querying Well

1. What does `IQueryable` represent in Entity Framework?

A materialized result set An expression tree for querying A specific SQL statement A cached query result

2. What is the primary purpose of using the `Select` method before materializing a query?

To load all columns of a database table To simplify navigation properties To project only the required columns into a view model To automatically enable lazy loading

3. What is the consequence of lazy loading in a loop over multiple entities?

It enhances performance by executing fewer queries It may lead to the N+1 problem with excessive queries It prevents any modifications to entities It requires an explicit SQL join

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

Allows modification of entities Prevents tracking of changes for loaded entities Enables lazy loading by default Materializes queries faster by including all related data

Continue: Saving, Transactions, and Concurrency → Review this lesson Retake quiz