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...
Automate Your ASP.NET Core HTTPS IIS Setup with PowerShell
In solutions that comprise multiple ASP.NET Core projects, each project is typically deployed as an independent IIS site in the production environment. Conse...
Decoupling by Design: Implementing an Assessment Mechanism with Events
This was my latest practical experience in a real-world project, where I addressed several key challenges in implementing the payee compliance assessment flow.
Thinking in DDD: Understanding Entities, Value Objects, and Aggregates through a Crowdfunding Page
Domain-Driven Design introduces several important modeling objects in the domain model, as follows:
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...
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...
下棋的日子 - 启蒙
月初陪女儿到商场选生日礼物时在国际象棋的货架旁驻留了很久,棋类玩具是个不错的选择，物美价廉，也是女儿喜欢的智力型玩具。买的时候我们却“举棋不定”了，女儿其实饶有兴趣，只是担心没人陪她玩。她弟弟的兴趣似乎还停留在飞机火车之类的只需动手的玩具上，而她妈妈更是一点兴趣没有，我就成了陪她玩棋的唯一人选。就这么犹豫着，最后...
Thinking in DDD: A Case of Moving from Code-First to Domain-Driven
The domain of a software program is the subject area of the user’s activity or interest that it supports. Every day, we solve problems within the domain, eve...
Improving SQL Performance by Choosing the Right Driving Table
Recently, I solved several slow query issues at work, all of which were related to choosing the correct driving table for the query. The following example is...
Thinking in DDD: Starting with Lessons from Projects That Missed the Drive
In this article, I’ll list a few of the headaches I’ve encountered in recent projects — some of which may have something to do with DDD. There were certainly...
Pitfalls of Using ref Variables in LINQ Select with Multiple Enumerations
I work with LINQ almost every day and frequently deal with various operations based on IEnumerable. Since I’ve always found it convenient to use, I never rea...
Streaming Progress Updates in Long-Running ASP.NET Core Requests
This is a feature recently implemented in our project to enhance the user experience. Some time-consuming requests, such as when the backend receives a file ...