Can this skill help with large dataset pagination?

Absolutely. It enforces the use of mandatory row limits and provides patterns for both offset and cursor-based pagination to prevent unbounded result sets that crash applications.

Does this skill support both EF Core and Dapper?

Yes, it provides specific patterns and implementation examples for both Entity Framework Core and Dapper, allowing you to choose the best tool for your specific workload.

Why does it recommend separating read and write models?

Separating models (CQRS) allows you to optimize read queries for speed and denormalization while keeping write commands focused on business logic and data integrity.

How does this skill help with N+1 query problems?

It provides patterns for eager loading using .Include() in EF Core and batch query techniques in Dapper to ensure data is fetched in the fewest round-trips possible.

Database Performance Patterns

Name: Database Performance Patterns
Author: Aaronontheweb

byAaronontheweb

•

423

•

Database Management

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

This skill provides Claude with expert-level guidance on architecting high-performance database interactions within .NET applications. It focuses on eliminating common bottlenecks by enforcing best practices such as separating read and write models, implementing mandatory row limits, and utilizing advanced EF Core features like AsNoTracking and split queries. Whether you are using Entity Framework Core or Dapper, this skill helps you avoid N+1 queries, prevents memory-intensive application-side joins, and ensures your data layer is built for scale.

Key Features

01Automated detection and resolution of N+1 query patterns using batching

02Expert guidance on SQL-side joins and avoiding Cartesian explosions

03Implementation of Read/Write model separation (CQRS) for optimized data flow

04Enforcement of mandatory row limits and cursor-based pagination patterns

05423 GitHub stars

06Performance-first EF Core configurations including AsNoTracking and Split Queries

Use Cases

01Refactoring slow EF Core data access layers to improve system response times

02Designing scalable architectures for high-traffic .NET services using CQRS

03Optimizing complex data retrieval by integrating Dapper for read-heavy workloads

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aaronontheweb/dotnet-skills database-performance

For use in Claude.ai and ChatGPT

Download Skill