Pick a focused question that fits your time, stack, and interview goal.
How much time do you have?
Show one-drill sessions you can finish now.
15 results across 1 active filter
Page 1 of 1
Builds optional EF Core predicates while preserving server translation, stable ordering, and a bounded result.
Performs a set-based bulk update without loading session entities into the change tracker.
Uses the client's original rowversion to detect a lost update and return a deliberate conflict response.
Implements descending keyset pagination in LINQ using a compound timestamp-and-id cursor.
Processes a large import in chunks with fresh DbContexts, idempotent keys, cancellation, and bounded tracker growth.
Uses `AsSplitQuery` deliberately for a tracked aggregate with multiple collections and explains its consistency boundary.
Relies on a database unique constraint and translates only the expected provider error into a domain conflict.
Builds a read-only EF Core projection with aggregates, stable ordering, and bounded results instead of loading an entity graph.
Carries the ASP.NET Core request token into a bounded EF Core query while keeping cancellation separate from business rollback guarantees.
Replaces a parent query plus one status query per row with one server-side projection.
Wraps a complete explicit transaction in the provider execution strategy and creates fresh context state for each retry attempt.
Persists domain state and its outbox message in one SaveChanges transaction without publishing inside the request transaction.
Wraps a pooled DbContext factory so every request assigns tenant state before a global query filter can run.
Adds a stable query tag and inspects generated SQL without embedding user data or enabling unsafe global logging.
Attaches a key-only stub and marks one property modified for a narrow update while naming the rules this pattern bypasses.