EF Core Practical Data Access Labs

Compose optional product filters without early materialization

Builds optional EF Core predicates while preserving server translation, stable ordering, and a bounded result.

Expire sessions with ExecuteUpdateAsync

Performs a set-based bulk update without loading session entities into the change tracker.

Handle a rowversion conflict in an update endpoint

Uses the client's original rowversion to detect a lost update and return a deliberate conflict response.

Implement a stable EF Core keyset page

Implements descending keyset pagination in LINQ using a compound timestamp-and-id cursor.

Import records in bounded EF Core batches

Processes a large import in chunks with fresh DbContexts, idempotent keys, cancellation, and bounded tracker growth.

Load a tracked aggregate with a split query

Uses `AsSplitQuery` deliberately for a tracked aggregate with multiple collections and explains its consistency boundary.

.NET Full Stack

Full-cycle .NET full-stack interview preparation.

A role-based preparation path covering C#, ASP.NET Core APIs, data access, frontend integration, testing, deployment, system design, real-life scenarios, and behavioral interview topics.

.NET Backend