How does the skill manage database migrations?

It enforces a strict CLI-only workflow to prevent schema drift and provides a dedicated worker service pattern for running migrations safely during deployment.

How does it handle database connection failures?

It utilizes the EF Core ExecutionStrategy to automatically retry operations that fail due to transient network or database issues, increasing application reliability.

Why does this skill recommend NoTracking by default?

Using NoTracking by default significantly improves performance and reduces memory overhead for read-only queries, which constitute the majority of web API traffic.

Is this skill compatible with .NET Aspire?

Yes, it includes specific implementation patterns for orchestrating migration services and database dependencies within the .NET Aspire AppHost.

Does it support high-performance bulk updates?

Yes, it promotes the use of ExecuteUpdate and ExecuteDelete (introduced in EF Core 7) for executing batch changes directly in the database without loading entities into memory.

EF Core Best Practices & Patterns

Name: EF Core Best Practices & Patterns
Author: Aaronontheweb

byAaronontheweb

•

423

•

Database Management

Implements high-performance Entity Framework Core patterns, migration workflows, and database resiliency strategies for .NET applications.

This skill provides a comprehensive architectural framework for .NET developers using Entity Framework Core, focusing on performance optimization through NoTracking defaults and efficient query splitting. It establishes robust standards for database lifecycle management by enforcing CLI-only migration workflows and providing a dedicated Migration Service pattern ideal for .NET Aspire environments. By integrating execution strategies for transient failures and promoting modern bulk operations, it helps teams build scalable, resilient, and maintainable data access layers while avoiding common EF Core pitfalls.

Key Features

01Configures NoTracking by default for optimized read-heavy performance

02Provides dedicated Migration Service patterns for .NET Aspire orchestration

03Optimizes batch operations using ExecuteUpdate and ExecuteDelete commands

04Establishes standardized CLI-driven database migration workflows

05Implements ExecutionStrategy patterns for handling transient database failures

06423 GitHub stars

Use Cases

01Optimizing query performance in high-traffic APIs by reducing tracking overhead

02Bootstrapping new .NET projects with production-ready EF Core configurations

03Scaling .NET Aspire applications with automated, reliable database migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aaronontheweb/dotnet-skills efcore-patterns

For use in Claude.ai and ChatGPT

Download Skill