Page Splits or Hotspots? Choosing the Right Primary Key in SQL Server
All data tables in the project use Guid as the primary key. Most of them are randomly generated Guids, but quite a few tables use Sequential Guid. For exampl...
Recent posts
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...
Thinking in DDD: Applying Ubiquitous Language to Real-World Financial Workflows
Software engineers need domain knowledge to build business systems. I’ve found that domain experts often explain processes but rarely define key entities cle...
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...