Loading
Pick a focused question that fits your time, stack, and interview goal.
123 results across 1 active filter
Page 3 of 6
Uses the gaps-and-islands pattern to find consecutive login-day streaks after deduplicating same-day activity.
Solves a many-to-many all-match filter with grouping and a deliberate empty-selection rule.
Uses NOT EXISTS to express an anti-join without null traps or duplicate parent rows.
Uses a recursive CTE to return hierarchy depth and a readable root-to-node path.
Explains global query filters in EF Core with practical .NET data-access examples and production trade-offs.
Uses a test-only DbCommandInterceptor to fail a regression when database command count grows with page size.
Uses the client's original rowversion to detect a lost update and return a deliberate conflict response.
Makes EF Core transient retries safe across transactions, uncertain commits, generated keys, and external side effects.
Explains optimistic concurrency with EF Core rowversion tokens, API conflict responses, and safe retry boundaries.
Explains why application-level duplicate checks are not enough and how EF Core APIs map database constraints to friendly errors.
Connects API query shape to index order, selectivity, execution plans, write cost, and safe production rollout.
Explains SQL joins for API response shapes with practical .NET data-access examples and production trade-offs.
Draws a short atomic database boundary around one invariant while moving network side effects into explicit, recoverable workflow states.
Explains EF Core query performance diagnostics with practical .NET data-access examples and production trade-offs.
Explains safe EF Core migrations with practical .NET data-access examples and production trade-offs.
Explains DbContext lifetime and unit-of-work boundaries with practical .NET data-access examples and production trade-offs.
Validates a bounded command set completely before applying all updates in one SaveChanges transaction.
Stores an idempotency key, request hash, and response in the same transaction as the created resource.
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 `Include` versus `Select` in EF Core with practical .NET data-access examples and production trade-offs.
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.