Database Performance

Solid fundamentals for keeping database queries fast in .NET applications. The read/write model separation is the big idea here: different DTOs for queries versus commands, AsNoTracking on reads, always paginate with limits. Shows you how to avoid N+1 queries with EF Core's Include or Dapper's multi-query, and hammers home the rule about doing joins in SQL instead of stitching data together in C#. Works with both EF Core and Dapper. This is the stuff that saves you when a feature works fine in dev with 100 rows but crawls in production with 100,000.

Install to Claude Code

npx -y skills add aaronontheweb/dotnet-skills --skill database-performance --agent claude-code