Skip to content

Tracks Drills Topics Technologies Tech stacks Skill areas

Tracks Drills Guides

Loading

Aporeon

Technical interview practice, from one developer to another.

Guides About Editorial standards Support Privacy Terms Refund policy

EF Core Foundations - .NET Backend | Aporeon

EF Core Foundations

DbContext lifetime, tracking, LINQ execution, raw SQL boundaries, model mapping, query filters, pooling, and memory behavior.

14 drillsPractice one at a timeOrdered pathConcept questionComparison questionDebugging scenario

Recommended start

DbContext Lifetime

Explains DbContext lifetime and unit-of-work boundaries with practical .NET data-access examples and production trade-offs.

Easy~5 minStep 1 of 14

Practice this drill Choose another

Search

14 of 14 shown

1DbContext LifetimeRecommended startExplains DbContext lifetime and unit-of-work boundaries with practical .NET data-access examples and production trade-offs.Concept questionEasy~5 min.NETC#EF CorePractice

Practice order

14 drillsOne at a time

1DbContext LifetimeUp next / Easy / ~5 min
2Tracking vs No TrackingMedium / ~7 min
3Deferred ExecutionEasy / ~5 min

2

Tracking vs No TrackingExplains EF Core tracking versus no-tracking queries with practical .NET data-access examples and production trade-offs.Comparison questionMedium~7 min.NETC#EF Core

Practice

3Deferred ExecutionExplains LINQ deferred execution with EF Core with practical .NET data-access examples and production trade-offs.Concept questionEasy~5 min.NETC#EF CorePractice

4IQueryable vs IEnumerableExplains `IQueryable` versus `IEnumerable` in EF Core with practical .NET data-access examples and production trade-offs.Comparison questionMedium~7 min.NETC#EF CorePractice

5LINQ TranslationExplains LINQ translation boundaries with practical .NET data-access examples and production trade-offs.Debugging scenarioHard~12 min.NETC#EF CorePractice

6Avoid EF EntitiesExplains returning EF entities from APIs with practical .NET data-access examples and production trade-offs.Concept questionEasy~5 min.NETC#EF CorePractice

7Raw SQL RiskExplains raw SQL in EF Core with practical .NET data-access examples and production trade-offs.Concept questionMedium~7 min.NETC#EF CorePractice

8Filter InjectionExplains dynamic filters and SQL injection risk with practical .NET data-access examples and production trade-offs.Debugging scenarioHard~12 min.NETC#EF CorePractice

9Raw SQL BoundaryExplains when LINQ is enough, when raw SQL is clearer, and how to keep raw SQL safe and maintainable.Concept questionMedium~7 min.NETASP.NET CoreEF CorePractice

10Global Query FiltersExplains global query filters in EF Core with practical .NET data-access examples and production trade-offs.Concept questionMedium~7 min.NETC#EF CorePractice

11Owned entities and complex typesChooses between EF Core complex types, owned entities, and regular entities from value semantics, identity, ownership, querying, and storage needs.Concept questionMedium~7 min.NETC#EF CorePractice

12Shadow PropertiesExplains EF Core shadow properties for audit or infrastructure columns with practical .NET data-access examples and production trade-offs.Concept questionMedium~7 min.NETC#EF CorePractice

13DbContext PoolingUses EF Core context pooling only when reusable context state, tenant isolation, and underlying connection state are controlled and tested.Concept questionMedium~7 min.NETASP.NET CoreEF CorePractice

14EF Tracking MemoryConnects EF Core change tracking to object retention, query shape, projections, and read-only API performance.Concept questionMedium~7 min.NETASP.NET CoreC#Practice

4

IQueryable vs IEnumerable

Medium / ~7 min

5LINQ TranslationHard / ~12 min

6Avoid EF EntitiesEasy / ~5 min

7Raw SQL RiskMedium / ~7 min

8Filter InjectionHard / ~12 min

+6 more drills in this section