2025

51 posts

September

30 posts
Sep 30 Unit Testing with EF Core: How to Avoid the In-Memory Provider Trap 9 min
Sep 29 Inheritance Mapping in EF Core: TPH vs TPT vs TPC in SQL Server 11 min
Sep 28 Table Splitting in EF Core: When to Use It (and Why It Hurts Sometimes) 9 min
Sep 27 Stored Procedures vs EF Core LINQ: When to Drop Down to SQL 8 min
Sep 26 SQL Server Execution Plans: What EF Core Developers Should Actually Look At 7 min
Sep 25 EF Core Compiled Queries: When They’re Worth It in High-Throughput Apps 8 min
Sep 24 Zero-Downtime Migrations in EF Core: Blue-Green and Rolling Deployment Strategies 8 min
Sep 23 Managing EF Core Migrations in Large Teams: Best Practices for SQL Server 6 min
Sep 22 RowVersion and Timestamps in EF Core: Practical Guide for SQL Server 7 min
Sep 21 EF Core Concurrency Tokens: Preventing Lost Updates in SQL Server 7 min
Sep 20 Handling Transactions in EF Core: SaveChanges vs Explicit Transactions 6 min
Sep 19 Connection Per Tenant in EF Core: Design & Pitfalls for SQL Server 7 min
Sep 18 EF Core Tenant Isolation: Global Query Filters for Secure Multi-Tenant SaaS 6 min
Sep 17 TL;DR: My EF Core Entity Modeling Checklist 7 min
Sep 16 EF Core Owned Types: When to Use Them in SQL Server 7 min
Sep 15 Stop Leaking Data: Soft Deletes with EF Core Global Filters 8 min
Sep 14 EF Core: One-to-One vs. One-to-Many (A Painful Lesson) 7 min
Sep 13 5 EF Core Patterns for Faster ASP.NET Core APIs 8 min
Sep 12 Stop Using Skip/Take for EF Core Pagination 8 min
Sep 11 EF Core: LINQ vs. Raw SQL - A Surprising Benchmark 6 min
Sep 10 Fix Slow EF Core Queries with Projections 6 min
Sep 9 How to Find and Fix N+1 Queries in EF Core 7 min
Sep 8 5 EF Core Defaults to Change Before Production 6 min
Sep 7 Fix Slow EF Core Queries with Database Indexing 9 min
Sep 6 Safely Log EF Core SQL Queries in Production 8 min
Sep 5 Why EF Core AutoInclude is a Performance Trap 6 min
Sep 4 Code-First vs. Database-First—Which to Choose? 7 min
Sep 3 Why Lazy Loading is a Performance Trap in ASP.NET Core 6 min
Sep 2 DbContext Pooling in ASP.NET Core: Boost Performance Safely 7 min
Sep 1 EF Core vs. Dapper: A Pragmatic Guide for Production Systems 8 min