Optimizing EF Core Includes with Split Queries: Lessons from Raw SQL Analysis
In EF Core, Include executes JOIN queries to load the main entity and its related data. Excessive or multi-level Include usage can easily lead to performance...
Entity Framework
Rethinking SaveChanges: Transactional Boundaries and Best Practices in Entity Framework
In Entity Framework, SaveChanges and SaveChangesAsync are methods provided by DbContext to persist data. They are so commonly used that we rarely question th...
From Confusion to Clarity: Resolving Scoped and Singleton Injection Conflicts
I resolved a subtle issue months ago in a long-running company project that caused business data inconsistency due to confusing code changes. The project use...