data-efcore-patterns

What problem does it solve?

EF Core can be complex to configure for performance and migrations. This skill presents practical patterns to ensure efficient data access, reliable migrations, and safer update semantics in real-world apps.

Core Features & Use Cases

• NoTracking by default to boost read performance, with explicit tracking when needed.
• Never edit migrations manually to maintain a clean history and reliable deployments.
• Dedicated Migration Service pattern (Aspire) to run migrations before app startup and isolate seeding in tests.
• Use execution strategies to gracefully retry transient failures and preserve data integrity.
• Safe bulk operations with ExecuteUpdate/ExecuteDelete to run single SQL statements instead of loading entities.
• Proper DbContext lifetime management in DI for ASP.NET Core, background tasks, and long-lived components.

Quick Start

Configure your DbContext to disable tracking by default, wire up the CLI migration tooling, and implement a dedicated migration runner for automated migrations.