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...
Backend
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...