dotnet-data

What problem does it solve?

This Skill addresses common pitfalls and best practices in .NET data access using Entity Framework Core and Dapper, ensuring efficient, maintainable, and performant data operations.

Core Features & Use Cases

• EF Core Best Practices: Covers DbContext lifetime, AsNoTracking, N+1 problem solutions, and projections.
• Dapper Integration: Explains when and how to use Dapper for performance-critical read operations.
• Migrations & Raw SQL: Guides on managing database schema evolution and using raw SQL safely.
• Use Case: Optimize a high-traffic e-commerce backend by ensuring all read-only product catalog queries use AsNoTracking and projections, while complex order reporting leverages Dapper for speed.

Quick Start

Use the dotnet-data skill to review the best practices for DbContext lifetime management in a .NET application.