Loading
Pick a focused question that fits your time, stack, and interview goal.
119 results across 1 active filter
Page 4 of 5
Carries the ASP.NET Core request token into a bounded EF Core query while keeping cancellation separate from business rollback guarantees.
Maps a named capability to an ASP.NET Core policy and enforces it at the endpoint boundary.
Converts local-day boundaries to UTC once, preserving correct daylight-saving behavior and index use on stored UTC timestamps.
Uses an actual execution plan, row-flow evidence, runtime measurements, and representative parameters to diagnose a slow query without guessing.
Implements safe redaction of known sensitive keys in a dictionary before logging.
Uses profiler evidence to isolate expensive derived data and row rendering, then applies memoization without hiding correctness bugs.
Replaces a parent query plus one status query per row with one server-side projection.
Ranks duplicate import rows, previews the deletion set, and removes older copies with deterministic retention.
Uses server-resolved capabilities for presentation while keeping the mutation endpoint authoritative.
Uses an explicit state model for initial loading, success, empty, recoverable error, and refetching.
Uses two isolated EF Core contexts to reproduce a real optimistic-concurrency conflict through the API boundary.
Uses a conditional update and transaction to prevent overselling while recording the reservation consistently.
Implements a bounded async retry helper that respects cancellation and does not retry every exception blindly.
Wraps a complete explicit transaction in the provider execution strategy and creates fresh context state for each retry attempt.
Persists a job and outbox command before returning a status URL for long-running work.
Produces field-keyed validation errors through one reusable endpoint boundary.
Writes a left-join aggregate that keeps active customers with no paid orders and applies date filters without changing join semantics.
Uses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.
Implements top-K frequency selection with deterministic tie-breaking.
Aggregates product sales and ranks independently inside each category with a deterministic top-N rule.
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.
Keeps data and secrets on the server while sending a small serializable model to an interactive client component.
Authorizes metadata before opening storage and streams the file with safe headers and range support.