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

データベース管理

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.

主な機能

Mandatory pagination and row-limiting patterns
203 GitHub stars
Guidance on SQL-side joins vs. application-side processing
EF Core optimization using AsNoTracking and SplitQuery
N+1 query prevention and batch processing strategies
CQRS-based separation of read and write data models

ユースケース

Designing high-throughput data access layers for new microservices
Refactoring slow Entity Framework Core queries in existing .NET apps
Implementing clean architecture with specialized read/write DTOs

概要

主な機能

Mandatory pagination and row-limiting patterns
203 GitHub stars
Guidance on SQL-side joins vs. application-side processing
EF Core optimization using AsNoTracking and SplitQuery
N+1 query prevention and batch processing strategies
CQRS-based separation of read and write data models

ユースケース

Designing high-throughput data access layers for new microservices
Refactoring slow Entity Framework Core queries in existing .NET apps
Implementing clean architecture with specialized read/write DTOs