How does this help with N+1 query problems?

It provides structural patterns like eager loading with Include in EF Core and batching with Dapper's QueryMultiple to ensure data is fetched in a single trip.

Why does the skill recommend separating read and write models?

Separating models (CQRS) allows you to create lightweight, denormalized DTOs for fast reads while keeping write models focused on strict business logic and validation.

Does this skill work with both EF Core and Dapper?

Yes, it provides specific implementation patterns and best practices for both Entity Framework Core and Dapper, helping you choose the right tool for the job.

Does this skill help with SQL-specific optimizations?

Yes, it emphasizes doing joins in SQL rather than application code and provides guidance on avoiding Cartesian explosions during complex data retrieval.

Database Performance Patterns

Name: Database Performance Patterns
Author: Aaronontheweb

byAaronontheweb

•

203

•

Database Management

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient querying with EF Core and Dapper.

This skill provides comprehensive architectural guidance for .NET developers to build scalable, high-performance database interactions. It enforces best practices such as separating read and write models, preventing N+1 query problems, and ensuring result sets are always bounded. By providing specific implementation patterns for both Entity Framework Core and Dapper, it helps developers avoid common pitfalls like application-side joins and Cartesian explosions, leading to more maintainable and efficient backend services.

Key Features

01Mandatory pagination and row-limiting patterns

02203 GitHub stars

03Guidance on SQL-side joins vs. application-side processing

04EF Core optimization using AsNoTracking and SplitQuery

05N+1 query prevention and batch processing strategies

06CQRS-based separation of read and write data models

Use Cases

01Designing high-throughput data access layers for new microservices

02Refactoring slow Entity Framework Core queries in existing .NET apps

03Implementing clean architecture with specialized read/write DTOs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aaronontheweb/dotnet-skills data

For use in Claude.ai and ChatGPT

Download Skill