Skip to content

Tracks Drills Topics Technologies Tech stacks Skill areas

Tracks Drills Topics

Loading

Aporeon

Technical interview practice, from one developer to another.

About Privacy Terms

.NET Full Stack

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 2Tracking 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 CorePractice 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

Practice order

14 drillsOne at a time

1DbContext LifetimeUp next / Easy / ~5 min
2Tracking vs No TrackingMedium / ~7 min
3Deferred ExecutionEasy / ~5 min
4IQueryable vs IEnumerableMedium / ~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