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.
167 results across 1 active filter
Page 4 of 7
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.
Propagates request cancellation through async dependencies while keeping committed side effects and timeout policy explicit.
Explains DbContext lifetime and unit-of-work boundaries with practical .NET data-access examples and production trade-offs.
Uses file upload processing to practice bounded memory, stream ownership, temporary files, and retained buffers.
Turns LOH theory into an API investigation around large payloads, buffers, serialization, and concurrency.
Frames allocation reduction as measurement-driven API work rather than premature micro-optimization.
Keeps HttpContext inside the active request, avoids concurrent access, and copies only immutable data needed by later work.
Explains how IHttpClientFactory separates short-lived clients from pooled handlers and how concurrency, DNS, resilience, and DI lifetimes still require judgment.
Validates size and signature, writes under a generated storage key, and keeps untrusted files outside the public web root.
Explains upload UX, API boundaries, validation, progress, storage, scanning, failure handling, and safe download behavior.
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.
Explains debounce, cancellation, stale-response protection, loading indicators, and backend query safety for search UI.
Explains `Include` versus `Select` in EF Core with practical .NET data-access examples and production trade-offs.
Verifies the exact request bytes, rejects stale signatures, deduplicates event ids, and queues processing durably.
Uses WebApplicationFactory with test-only authentication and isolated dependencies to exercise the real ASP.NET Core pipeline.
Designs consumer-focused contracts that reduce accidental authority and coupling without producing meaningless one-method wrappers.
Explains refetching, targeted invalidation, stale data, optimistic updates, server truth, and user feedback after mutations.
Chooses the correct typed-options lifetime, validates required configuration early, and handles runtime changes deliberately.
Explains `IQueryable` versus `IEnumerable` in EF Core with practical .NET data-access examples and production trade-offs.