Data Access

Add guardrails around EF Core tenant query filters

Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.

ADO.NET connection pooling and pool exhaustion

Explains physical connection reuse, pool partitioning, short ownership, exhaustion causes, diagnostics, and why increasing the pool is not the first fix.

Apply a partitioned write rate limit

Partitions limits by authenticated user or trusted client address and returns useful 429 retry metadata.

Authorize a loaded resource by ownership

Loads a resource once, evaluates owner-or-capability authorization, and avoids trusting route ownership claims.

Avoid double-counting payments and refunds

Pre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.

Build a filtered and paginated list page

Explains URL-backed filters, API query parameters, pagination, sorting, empty states, and shareable list views.

.NET Full Stack

Full-cycle .NET full-stack interview preparation.

A role-based preparation path covering C#, ASP.NET Core APIs, data access, frontend integration, testing, deployment, system design, real-life scenarios, and behavioral interview topics.

.NET Backend