Data Access in .NET — EF Core, LINQ, and Dapper (Why, When, and How to Make It Fast)
Deep .NET data access guide: EF Core tracking, projection, AsSplitQuery, ExecuteUpdateAsync, compiled queries, and the EF + Dapper hybrid pattern.
Posts and interview questions tagged Dapper.
Deep .NET data access guide: EF Core tracking, projection, AsSplitQuery, ExecuteUpdateAsync, compiled queries, and the EF + Dapper hybrid pattern.
SOLID principles built around a real C# order-processing service. Refactor each principle with honest pros, cons, and a code-review checklist.
React 19 vs Angular 19 in 2026 — Server Components vs Signals, bundle sizes, INP benchmarks, real code, and an honest 13-row decision matrix.
A complete foundational guide to LLMs: what they are, the problems they solve, how transformers + attention + tokenization + sampling actually work internally, why Python dominates the AI ecosystem, real production code for every use case (chat, streaming, embeddings, tool-calling, local inference, RAG), and the pitfalls that ruin LLM applications.
Deep-dive into Retrieval-Augmented Generation: the dual problem (LLMs do not know your enterprise data + you cannot send confidential data to public APIs), full architecture, ingestion + retrieval + generation pipelines in C# with Azure OpenAI and the new Azure SQL VECTOR type, real code, security, costs, hallucination prevention, and the pitfalls that ruin production RAG systems.
Deep-dive into Clean Architecture for .NET: the Dependency Rule, the four layers, full project structure with EF Core + ASP.NET Core + MediatR, real C# code, advantages, trade-offs, and the pragmatic version that actually ships.
Deep-dive into CQRS in .NET: the problem it solves, architecture diagram, full C# implementation with MediatR, EF Core, separate read/write models, when CQRS pays off vs when it's over-engineering. With real code.
Deep-dive into Azure Functions: when to choose them over Web API, hosting plans, triggers and bindings, real .NET code (HTTP, Queue, Timer, Durable Functions), cold starts, cost model, advantages and disadvantages.
Deep-dive into the SAGA pattern: why distributed transactions need it, Choreography vs Orchestration, an order processing walkthrough with code, compensating transactions, real .NET examples, advantages, disadvantages, and production pitfalls.
Deep-dive into the Outbox pattern: the dual-write problem it solves, architecture diagram, real .NET code with EF Core, the relay/dispatcher implementation, CDC vs polling variants, advantages, disadvantages, and production pitfalls.
Deep-dive into microservices: what they are, when to choose them, the trade-offs, architecture diagram, real .NET code, communication patterns, observability, and where they fail. Basic to advanced.
Deep-dive into ASP.NET MVC: what it is, why it exists, architecture diagram, real code, advantages, disadvantages, and where it fits in 2026. Basic to advanced.