Q14 — EF Core Performance — Compiled Queries, Split Queries, Raw SQL Level: Senior | Topic: Entity Framework Core Performance Bottlenecks in EF Core Every LINQ query goes through an expression tree compiler that translat...
A pragmatic performance playbook for EF Core: find bottlenecks, fix N+1s with projection/eager loading, and when to cache or use AsNoTracking.
Caching can cut repeated work and protect dependencies, but only when keys, freshness rules, and failure behavior are designed as carefully as the hit path.
Q20 — Span<T>, Memory<T>, and ArrayPool<T> — Zero-Allocation Patterns Level: Senior | Topic: Performance Optimization The Problem: Allocation Pressure In high-throughput .NET code, excessive heap alloca...
Q19 — Caching Layers — IMemoryCache, IDistributedCache, HybridCache, Output Cache Level: Senior | Topic: Performance Optimization Choosing the Right Cache IMemoryCache: In-process, zero serialisation, microsecond latency...
Q21 — Rate Limiting in .NET 7+ — Fixed Window, Sliding Window, Token Bucket Level: Senior | Topic: Performance Optimization Why Rate Limiting? Rate limiting protects your API from overload — whether from abusive clients,...
Build a cost-efficient, scalable personal finance tracker using Next.js Server Actions paired with PostgreSQL, all on a single VPS, focusing on simplicity, performance, and developer productivity.
Q18 — Query Optimisation Workflow — Execution Plans, Statistics, Query Store Level: Senior | Topic: SQL Server The Optimisation Workflow Effective query optimisation follows a structured workflow: identify slow queries, ...
Q11 — Eager, Lazy, and Explicit Loading — Differences and the N+1 Problem Level: Mid-Level | Topic: Entity Framework Core The Three Loading Strategies Eager Loading ( Include() ): Related data is loaded in the same query...
Q1 — What is the difference between value types and reference types in C#? Level: Junior | Topic: C# Fundamentals The Short Answer Value types store data directly on the stack (or inline within an object). Reference type...
Q17 — Window Functions — ROW_NUMBER, LAG, SUM OVER, Running Totals Level: Mid-Level | Topic: SQL Server What Are Window Functions? Window functions operate across a set of rows without collapsing them into a single outpu...
Q3 — Explain the C# Type System: Records, Nullable Reference Types, and Pattern Matching Level: Mid-Level | Topic: C# Fundamentals Records (C# 9+) Records are compiler-synthesised types that provide value equality , immu...
Q13 — EF Core Migrations — Production Deployment Strategy Level: Senior | Topic: Entity Framework Core The Problem with Naive Migration Deployment Running MigrateAsync() at app startup in a multi-instance deployment is d...
A practical, example-driven guide to applying CQRS in real systems: when to use it, how to handle eventual consistency, the Outbox pattern, and operational considerations.
Q5 — async/await Internals — State Machines, Pitfalls, ValueTask Level: Senior | Topic: C# Fundamentals How async/await Works Under the Hood The C# compiler transforms every async method into a state machine struct . Eac...
Q15 — Clustered vs Non-Clustered Indexes — Covering Indexes, Filtered Indexes Level: Mid-Level | Topic: SQL Server Clustered Index A clustered index physically sorts and stores the actual data rows in the table based on ...
Q6 — Explain the ASP.NET Core Middleware Pipeline and Write Custom Middleware Level: Mid-Level | Topic: ASP.NET Core How the Pipeline Works ASP.NET Core processes every HTTP request through a linear chain of middleware c...
Q12 — AsNoTracking vs Tracked Queries — Change Tracker Internals Level: Mid-Level | Topic: Entity Framework Core How the Change Tracker Works When you load an entity with a tracked query, EF Core stores a snapshot of the...
Q25 — Integration Testing with WebApplicationFactory and Testcontainers Level: Senior | Topic: Testing Why Integration Tests? Unit tests verify logic in isolation. Integration tests verify the full ASP.NET Core pipeline ...
Q22 — OWASP Top 10 — How Each Applies to .NET APIs with Mitigations Level: Senior | Topic: Security The Most Critical Risks A01 — Broken Access Control: Never trust client-sent IDs. Always load the resource then verify o...
Q27 — CQRS with MediatR — Commands, Queries, Pipeline Behaviours Level: Senior | Topic: Architecture CQRS in a Nutshell Command Query Responsibility Segregation separates operations that change state (Commands) from oper...
Choose consistency per operation, preserve the guarantees users rely on, and use replication lag and latency measurements to tune the rest.
Event sourcing records every change as an immutable event. This article explains modeling choices, snapshots, upcasters, and safe external integrations.
Q2 — Abstract Classes vs Interfaces — Differences and When to Use Each Level: Mid-Level | Topic: C# Fundamentals The Core Distinction Abstract classes express an IS-A relationship — they share state, constructors, and a ...
Q4 — Memory Management — Stack, Heap, GC Generations, IDisposable Level: Senior | Topic: C# Fundamentals Stack vs Heap The stack stores value types and method frames — allocation and deallocation are O(1) pointer moves. ...
Q10 — Global Exception Handling with IExceptionHandler (.NET 8) Level: Senior | Topic: Web API The Problem Without centralised exception handling, every controller action needs its own try/catch, error responses are inco...
Q24 — Unit Testing with xUnit, NSubstitute, FluentAssertions — Full Examples Level: Mid-Level | Topic: Testing The Testing Pyramid A healthy test suite follows the pyramid: ~70% unit tests (milliseconds, no I/O, xUnit + ...
Q7 — DI Service Lifetimes — Singleton, Scoped, Transient and the Captive Dependency Trap Level: Mid-Level | Topic: ASP.NET Core The Three Lifetimes Singleton: One instance per application. Created once, reused forever. U...
Q26 — Clean Architecture — Solution Structure, Dependency Rule, Layer Responsibilities Level: Senior | Topic: Architecture The Core Principle — Dependency Rule In Clean Architecture, dependencies point inward only . The ...
1. Monolithic Architecture Extracted description: A single codebase and single deployable unit where all components are tightly coupled. Structure: UI / Web API → Business Logic + Data Access + Shared Components → Databa...