Loading
Pick a focused question that fits your time, stack, and interview goal.
140 results across 1 active filter
Page 4 of 6
Groups normalized email values to identify duplicates before adding or repairing a uniqueness rule.
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.
Uses the client's original rowversion to detect a lost update and return a deliberate conflict response.
Separates caller cancellation from a dependency timeout and maps expected downstream outcomes safely.
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 stale edit detection, row versioning, conflict UI, refresh behavior, and safe update contracts.
Explains why application-level duplicate checks are not enough and how EF Core APIs map database constraints to friendly errors.
Connects EF Core change tracking to object retention, query shape, projections, and read-only API performance.
Explains transient database errors, retry strategy, EF Core execution strategy, idempotency, timeouts, and avoiding retry storms.
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 size and signature, writes under a generated storage key, and keeps untrusted files outside the public web root.
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 debounce, cancellation, stale-response protection, loading indicators, and backend query safety for search UI.
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.
Verifies the exact request bytes, rejects stale signatures, deduplicates event ids, and queues processing durably.
Explains how to inspect EF Core generated SQL and connect LINQ shape to database execution behavior.