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
Explains composing dynamic LINQ filters while keeping query execution in SQL and index-friendly.
Builds optional EF Core predicates while preserving server translation, stable ordering, and a bounded result.
Diagnoses hidden per-row EF Core queries and replaces them with a bounded query shape without creating an oversized join.
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.
Explains EF Core projections for API read models that need related names, counts, and summaries without loading full graphs.
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.
Adds a stable query tag and inspects generated SQL without embedding user data or enabling unsafe global logging.