NOTES & ARTICLES
My personal notes on the challenges encountered while building a system from scratch, the solutions I found, and a bit of the philosophy behind it all. A mix of the technical and the theoretical.


EF Core Compiled Queries: Do They Really Make It Faster?
How much faster does EF.CompileAsyncQuery make queries? I measured it with BenchmarkDotNet on PostgreSQL and SQLite: 3% to 26%, depending on the database.
.NET, EF Core
The EF Core N+1 Problem: How to Spot It and Fix It
What is the N+1 problem in EF Core and how do you catch it in the logs? I measured lazy loading, Include, AsSplitQuery and Select: 147 queries became 1.
.NET, EF Core
Safely Applying EF Core Migrations in Production
How should EF Core migrations reach production? I compared Migrate(), idempotent SQL scripts and migration bundles, plus data loss and rollback pitfalls.
.NET, EF Core
EF Core Query Performance: Projection, AsNoTracking and AsSplitQuery
Speed up EF Core queries: Select projection instead of Include, AsNoTracking and AsSplitQuery. Read the generated SQL and learn which one to use when.
EF Core, SQL Server
SQL Server Indexes: Clustered, Non-Clustered and B-Tree
What is an index in SQL Server? Clustered vs non-clustered indexes, how a B-Tree lookup works, covering indexes and choosing the right index, with examples.
EF Core, SQL Server
EF Core Relationships and the Mixed Approach: Code First or DB First?
Code First or DB First in EF Core? Read relationships with Include, learn the Mixed approach and compare all three to pick the right one for your project.
EF Core
EF Core Code First: Adding and Rolling Back Migrations
Learn EF Core Code First: write entities and a DbContext, run Add-Migration, apply and roll back changes with Update-Database, and ship safely to production.
EF Core
What Is EF Core? Setup and the Database First Approach
What is EF Core and how does Database First work? Set up SQL Server with Docker, generate C# classes with Scaffold-DbContext and weigh the pros and cons.
EF Core