Data and EF Core
EF Core, SQL Server, migrations, and the long slow realization that the database was never the slow part.
Everything about Data and EF Core.
Newest first. No clever sorting hiding the good stuff.
Unit of Work with Entity Framework Core Done Right
Learn what the Unit of Work pattern is, why EF Core's DbContext already behaves like one, and when a thin abstraction helps. We walk through small, runnable C# examples that show single commit flows, explicit transactions, and resilient retries. You will see how to avoid partial saves, how to wire dependencies with clean lifetimes, and which pitfalls to skip when layering repositories and services.
4 min0 likes→Article / dataEF Core Query Performance Tips for Everyone
EF Core does not make queries fast by default. You do. This guide shows how to cut query time by fetching less with projection, turning on AsNoTracking for reads, avoiding N+1, choosing AsSplitQuery for big includes, paginating, indexing and compiling hot queries. Each concept comes with small runnable C# snippets and clear explanations so you can apply them today without rewriting your app.
4 min0 likes→Article / dataEF Core Audit Logging with Interceptors that do not Clutter Your DbContext
Learn how to build a clean, production ready audit trail in EF Core that records who changed what and when without stuffing logic into your DbContext. We walk through a practical SaveChanges interceptor, compare it to overriding SaveChanges, and review trusted NuGet options. The post closes with performance and security practices that keep your database fast and your compliance officer calm.
6 min0 likes→Article / dataRepository Pattern vs DbContext in Entity Framework Core
Tired of arguing about repositories in EF Core? This practical guide compares direct DbContext, thin repositories, and specification style queries with small, runnable C# examples. Learn when each option shines, what to avoid, and how to keep your code clean without hiding EF Core features.
4 min1 like→Article / dataCleaner Joins in EF Core 10 with LeftJoin and RightJoin
EF Core 10 introduces LeftJoin and RightJoin to make outer joins readable and intuitive. This article shows how these methods translate to SQL, how to migrate from GroupJoin and DefaultIfEmpty, and how to handle nulls and filters without breaking semantics.
5 min0 likes→
Video / dataWhy Your OnModelCreating Is a Hot Mess (And How to Fix It)
Entity Framework Core configurations become cleaner and testable when persistence rules move into `IEntityTypeConfiguration` classes loaded through assembly scanning.
16:066,870 views349 likes→
Short / dataMake Entity Framework Faster with Parameterized Queries
Culture-sensitive lowercasing can break string comparisons, as demonstrated by the Turkish dotless i, while `OrdinalIgnoreCase` remains culture agnostic.
1:051,902 views55 likes→
Short / dataYou Won't Believe The Hidden Dangers Of Lazy Loading
The REST Client VS Code extension sends REST and GraphQL requests from `.http` or `.rest` files with support for headers, bodies, variables, authentication, and request conversion.
1:012,596 views45 likes→
Short / dataEF Core Queries Go BOOM!
Using an appropriate `StringComparison` avoids extra allocations and produces safer case-insensitive string comparisons.
0:593,502 views111 likes→
Video / dataSoft Deletes: The Upgrade Your EF Core Needs
The Bongo Cat VS Code extension adds an animated coding companion to the status bar.
10:055,858 views291 likes→
Short / dataSlow Entity Framework Core queries? Let’s speed them up!
C# value types are passed by value, so assigning one variable to another creates a copy that can change independently.
1:004,873 views139 likes→
Video / dataDon't Make These Entity Framework Core Mistakes
Five Entity Framework Core performance pitfalls cover unnecessary tracking, lazy loading, Cartesian explosion, buffering, and ineffective query caching.
8:4823,208 views938 likes→