Oğuzhan KARAGÜZEL

OĞUZHAN KARAGÜZEL

Software Developer

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.

Hizmetlerimizi anlatan temsili görsel
EF Core Compiled Queries: Do They Really Make It Faster?
November 3, 2026

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
November 3, 2026

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
November 3, 2026

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
October 24, 2026

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
October 24, 2026

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?
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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