Drills

Add guardrails around EF Core tenant query filters

Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.

Design a large EF Core import with change tracker control

Explains batching, tracking control, idempotency, validation, and operational safety for large EF Core imports.

.NETASP.NET CoreAzure Service BusEF CoreSQL

Design an EF Core transaction boundary with an outbox

Explains how EF Core SaveChanges, transactions, and an outbox keep database changes and messages consistent.

.NETASP.NET CoreC#EF CoreSQL Server

Enforce If-Match with rowversion

Maps an HTTP ETag precondition to EF Core rowversion and returns 412 when the representation is stale.

Coding problemEasy~15 min

Expire sessions with ExecuteUpdateAsync

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

.NETASP.NET CoreC#EF CoreSQL+1

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.

Concept questionHard~9 min

Handle EF Core execution strategy retries safely

Makes EF Core transient retries safe across transactions, uncertain commits, generated keys, and external side effects.

.NETASP.NET CoreAzureEF CoreSQL

Handle EF Core rowversion concurrency conflicts in an API

Explains optimistic concurrency with EF Core rowversion tokens, API conflict responses, and safe retry boundaries.

Concept questionMedium~7 min

Handle unique constraint races in EF Core APIs

Explains why application-level duplicate checks are not enough and how EF Core APIs map database constraints to friendly errors.

Implement an atomic bulk status update

Validates a bounded command set completely before applying all updates in one SaveChanges transaction.

Implement a persisted idempotent POST

Stores an idempotency key, request hash, and response in the same transaction as the created resource.

Import records in bounded EF Core batches

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

Map a unique email race to a conflict response

Relies on a database unique constraint and translates only the expected provider error into a domain conflict.

Retry an explicit EF Core transaction safely

Wraps a complete explicit transaction in the provider execution strategy and creates fresh context state for each retry attempt.

Debugging scenarioHard~12 min

Review a destructive EF Core migration before production

Reviews and stages destructive EF Core schema changes around live data, locks, mixed application versions, recovery, and rollback.

Save an order and outbox message together

Persists domain state and its outbox message in one SaveChanges transaction without publishing inside the request transaction.

Scope tenant state around a pooled DbContext

Wraps a pooled DbContext factory so every request assigns tenant state before a global query filter can run.

Update one property without loading the entity

Attaches a key-only stub and marks one property modified for a narrow update while naming the rules this pattern bypasses.

Concept questionMedium~7 min

Use ExecuteUpdate instead of loading entities for bulk changes

Explains when set-based EF Core updates are better than loading entities and where lifecycle behavior can differ.

.NETASP.NET CoreEF CoreSQL