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.
25 results across 1 active filter
Page 1 of 2
Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.
Explains physical connection reuse, pool partitioning, short ownership, exhaustion causes, diagnostics, and why increasing the pool is not the first fix.
Explains composing dynamic LINQ filters while keeping query execution in SQL and index-friendly.
Explains batching, tracking control, idempotency, validation, and operational safety for large EF Core imports.
Explains how EF Core SaveChanges, transactions, and an outbox keep database changes and messages consistent.
Diagnoses hidden per-row EF Core queries and replaces them with a bounded query shape without creating an oversized join.
Performs a set-based bulk update without loading session entities into the change tracker.
Makes EF Core transient retries safe across transactions, uncertain commits, generated keys, and external side effects.
Implements descending keyset pagination in LINQ using a compound timestamp-and-id cursor.
Explains stable EF Core pagination using cursor predicates, deterministic ordering, and index-aligned queries.
Processes a large import in chunks with fresh DbContexts, idempotent keys, cancellation, and bounded tracker growth.
Explains how to inspect EF Core generated SQL and connect LINQ shape to database execution behavior.
Investigates a growing-data EF Core slowdown through one correlated request, generated SQL, representative parameters, execution plan, waits, query shape, measured repair, and guarded rollout.
Explains when LINQ is enough, when raw SQL is clearer, and how to keep raw SQL safe and maintainable.
Uses `AsSplitQuery` deliberately for a tracked aggregate with multiple collections and explains its consistency boundary.
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.
Uses EF Core context pooling only when reusable context state, tenant isolation, and underlying connection state are controlled and tested.
Explains when EF Core compiled queries help, what they do not fix, and how to measure their value.
Explains how query tags, request correlation, and telemetry help connect slow SQL back to code paths.