Configure Entity Framework Core DbContext with NoTracking by default.
npx skills add https://github.com/seiggy/lucia-dotnet --skill efcore-patterns-seiggy
Please help me install this Agent Skill. Skill: efcore-patterns Source: https://github.com/seiggy/lucia-dotnet/tree/main/.github/skills/efcore-patterns Command: npx skills add https://github.com/seiggy/lucia-dotnet --skill efcore-patterns-seiggy
This Skill provides essential patterns and best practices for using Entity Framework Core effectively, ensuring performance, maintainability, and robustness in your .NET applications.
NoTracking and ExecuteUpdate/ExecuteDelete for faster queries.ExecutionStrategy to handle transient database failures.DbContext with NoTracking by default and implement a dedicated migration service for safe deployments.Use the efcore-patterns skill to configure your DbContext with NoTracking by default.
High-intent search queries and answers about installing and using this skill.
Optimize EF Core query performance by using NoTracking by default for read-only operations, applying query splitting, and leveraging ExecuteUpdate or ExecuteDelete for targeted bulk modifications to reduce tracking overhead and database roundtrips.
Manage EF Core migrations safely by implementing a dedicated migration service for deployments, ensuring reliable database schema evolution without manual script execution errors during production releases.
Handle transient database failures in Entity Framework Core by implementing an ExecutionStrategy, which automatically retries operations that fail due to temporary connection issues, ensuring robust data access layers.
Yes, you can configure your EF Core DbContext to use NoTracking by default, which significantly improves query performance by skipping change tracking when retrieving entities that are not meant to be updated.
Use ExecuteUpdate and ExecuteDelete in EF Core when you need to perform bulk updates or deletions directly against the database, bypassing change tracking to achieve faster performance for large-scale data modifications.
FortiumPartnersDevelop .NET 9 applications with Clean Architecture, MediatR, Entity Framework Core, and Minimal APIs.
filiptrivanExecute EF Core migrations for Spiderly's database schema using dotnet ef tooling.
microsoftMigrate Entity Framework DbContext registrations to ASP.NET Core dependency injection.
nicolashuberOptimize database access with CQRS, batch queries, and EF Core patterns.