• As a Tech Lead/Architect, you are setting standards for data access in an ASP.NET Core application using EF Core . What guidelines would you provide to your team regarding the default use of Lazy Loading versus Eager Loading to minimize performance issues?

  • Scenario: An ASP.NET Core page displays a list of 100 Products. When a user clicks on a specific product, you need to display its detailed Supplier information. Would you use Eager or Lazy/Explicit loading for the Supplier data in the initial list query? Justify your choice.

  • Scenario: You have an ASP.NET Core API endpoint that returns a list of Orders along with their associated Customer and OrderItems . Write the EF Core query using Eager Loading to fetch this data efficiently in a single database roundtrip .

  • How does the DbContext lifetime (e.g., scoped in ASP.NET Core) interact with Lazy Loading? What potential issues can arise if the DbContext is disposed before lazy loading is triggered?

  • Discuss the performance trade-offs between Eager Loading (potentially large initial query) and Lazy Loading (potential N+1 queries) when returning data from an ASP.NET Core API endpoint.

  • How would you detect and diagnose N+1 query problems caused by Lazy Loading in an ASP.NET Core application?

  • What impact does usingAsNoTracking()on anEF Corequery have onEager LoadingandLazy Loading?

  • How can using projections with Select in LINQ queries help optimize data retrieval and avoid issues related to both eager and lazy loading in EF Core ?

  • How does Explicit Loading work in EF Core using the Load method?Provide a use case where it might be beneficial over Eager or Lazy Loading.

  • Describe a scenario within an ASP.NET Core application where Lazy Loading might be considered despite the risk of N+1 problems .

  • Describe a scenario within an ASP.NET Core application where Eager Loading would be preferable to Lazy Loading , and explain why.

  • How do you enable Lazy Loading in EF Core using proxies ? What prerequisites must your entity classes meet?

  • What is the N+1 query problem , and how is it commonly associated with Lazy Loading in EF Core ?

  • How do you implement Eager Loading in EF Core using Include and ThenInclude ?Expertise Level of Developer Required to Answer this Question: Mid Level

  • Explain the difference between Eager Loading , Lazy Loading , and Explicit Loading in Entity Framework Core .