/data
EF Core, SQL Server, migrations, and the long slow realization that the database was never the slow part.
Everything filed under data
ArticleEF 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 likes0 comments ArticleEF 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 likes0 comments ArticleRepository 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 like0 comments ArticleCleaner 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 likes0 comments VideoWhy 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,701 views345 likes ShortMake 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,887 views55 likes ShortYou 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,570 views45 likes ShortEF Core Queries Go BOOM!
Using an appropriate `StringComparison` avoids extra allocations and produces safer case-insensitive string comparisons.
0:593,465 views111 likes VideoSoft Deletes: The Upgrade Your EF Core Needs
The Bongo Cat VS Code extension adds an animated coding companion to the status bar.
10:055,804 views291 likes ShortSlow 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,819 views137 likes VideoDon'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:4821,628 views918 likes