SQL

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.

Audit fields and data change tracking

Explains audit fields and data change tracking with practical .NET data-access examples and production trade-offs.

Avoid double-counting payments and refunds

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

Avoid SQL injection in dynamic API filters

Explains dynamic filters and SQL injection risk with practical .NET data-access examples and production trade-offs.

Build a safe filtered list endpoint

Implements bounded filtering and deterministic keyset pagination without accepting arbitrary query expressions.

Build daily order KPIs with conditional aggregation

Builds several daily business metrics in one grouped query while keeping each metric definition explicit.

.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