May 7 · 12 min read · EF Core connection pool exhaustion is one of the most disruptive production failures a .NET team can face — the kind that hits under load, triggers cascading timeouts, and sends developers hunting thr
Join discussion
Mar 10 · 8 min read · Modern cloud databases fail differently than on-prem systems. Network blips, throttling, failovers, and short-lived transport interruptions are all normal operating conditions now, not rare edge cases
Join discussionFeb 18 · 3 min read · Data consistency is not optional in production systems. Every insert, update, or delete must either complete successfully as a whole or leave the database unchanged. Entity Framework Core (EF Core) enforces this principle through transactions, which ...
Join discussion
Feb 9 · 3 min read · C# & AI Masterclass: Volume 6 Transform Your Data Layer into the Brain of Your AI Application The era of "dumb" databases is over. In the age of Generative AI, your application's data access layer must do more than just CRUD operations—it must unders...
Join discussionFeb 3 · 13 min read · Use EF Core when you want a full ORM that boosts productivity and long-term maintainability (LINQ, change tracking, migrations, cross-database providers). Use Dapper when you want maximum SQL control and minimal overhead, especially for read-heavy or...
Join discussion
Jan 24 · 3 min read · Row Level Security (RLS) is PostgreSQL's built-in feature for controlling which rows users can access in database tables. Instead of granting access to entire tables, RLS applies automatic filters at the row level, creating invisible WHERE clauses th...
Join discussion
Jan 2 · 3 min read · In Part 2, we built the BaseEntity<TKey>. We decided that our entities would not just hold data; they would record events (Side Effects). Now, we need to save these entities. A Junior Developer writes DbContext code directly inside the API Controller...
Join discussionDec 30, 2025 · 5 min read · 1. Overview The Idempotent SQL Script strategy involves generating a plain text SQL file that contains all database migration logic. Unlike standard SQL scripts, an idempotent script wraps every migration step in conditional logic (e.g., IF NOT EXIST...
Join discussionDec 28, 2025 · 5 min read · 1. Overview A Migration Bundle is a single-file executable introduced in Entity Framework Core 6. It encapsulates all database migrations and the logic required to apply them, allowing for database schema updates without requiring the .NET SDK or sou...
Join discussionDec 27, 2025 · 3 min read · When working with Entity Framework Core, deploying database changes is a critical step in the CI/CD pipeline. The strategy depends heavily on whether we are using a Code-First (C# defines the DB) or Database-First (DB defines the C#) approach. Here i...
Join discussion
