Database access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper. Use when designing data access layers, optimizing slow database queries, choosing between EF Core and Dapper, or avoiding common performance pitfalls.
$npx -y skills add wshaddix/dotnet-skills --skill database-performanceInstalls into the current project.
Run `npx skills use "https://github.com/wshaddix/dotnet-skills" --skill "wshaddix/dotnet-skills/database-performance"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/wshaddix/dotnet-skills" that are relevant to the current task. Run `npx skills add "https://github.com/wshaddix/dotnet-skills"` and select the relevant skills, then follow their instructions.