To improve performance, LINQ to Entities utilizes ________ to avoid retrieving all columns of a table.
- Deferred Execution
- Eager Loading
- Lazy Loading
- Projection
Projection - LINQ to Entities allows for projecting only the necessary columns from a table, which can significantly enhance performance by avoiding the retrieval of unnecessary data. Lazy Loading, Eager Loading, and Deferred Execution are related concepts but do not directly address the optimization of column retrieval in LINQ to Entities.
Loading...
Related Quiz
- In a customer database, how would you use aggregate functions to determine the average age of all customers?
- How does Entity Framework handle circular references when navigating relationships in queries?
- How does DbContext handle concurrent database transactions?
- What is the benefit of using Data Annotations over Fluent API in a simple Entity Framework model?
- The ________ Fluent API method is utilized to configure a composite primary key in an Entity Type.