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.
94 results across 1 active filter
Page 2 of 4
Explains N plus one query behavior, symptoms in APIs, fixes with set-based reads, batching, projections, and monitoring.
Explains EF Core projections into DTOs with practical .NET data-access examples and production trade-offs.
Explains raw SQL in EF Core with practical .NET data-access examples and production trade-offs.
Explains split queries versus single joined queries with practical .NET data-access examples and production trade-offs.
Explains EF Core tracking versus no-tracking queries with practical .NET data-access examples and production trade-offs.
Maps an HTTP ETag precondition to EF Core rowversion and returns 412 when the representation is stale.
Performs a set-based bulk update without loading session entities into the change tracker.
Explains filtered Include in EF Core with practical .NET data-access examples and production trade-offs.
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 transient database errors, retry strategy, EF Core execution strategy, idempotency, timeouts, and avoiding retry storms.
Explains DbContext lifetime and unit-of-work boundaries with practical .NET data-access examples and production trade-offs.
Covers using managed identity and Microsoft Entra authentication for Azure SQL access from a .NET API.
Explains safe migration strategy for Azure-hosted .NET APIs, including expand-contract changes, locking risk, rollback, and deployment order.
Validates a bounded command set completely before applying all updates in one SaveChanges transaction.