Guide Entity Framework Core best practices for .NET data access.
npx skills add https://github.com/Buggz/Thuddle --skill efcore-patterns-buggz
Please help me install this Agent Skill. Skill: efcore-patterns Source: https://github.com/Buggz/Thuddle/tree/main/.claude/skills/efcore-patterns Command: npx skills add https://github.com/Buggz/Thuddle --skill efcore-patterns-buggz
This Skill addresses common challenges and best practices in using Entity Framework Core, ensuring efficient, maintainable, and robust data access in .NET applications.
ExecuteUpdate and ExecuteDelete for efficient large-scale data modifications.Configure your DbContext to use NoTracking by default for improved read performance.
High-intent search queries and answers about installing and using this skill.
To fix N+1 query problems in EF Core, you should utilize query splitting and eager loading to optimize data retrieval. This prevents separate database roundtrips for each related entity, significantly improving application performance.
The best way to manage EF Core migrations is using CLI commands alongside a dedicated migration service. This approach safely handles database schema changes and ensures maintainable data access layers across your .NET application.
Yes, you should configure NoTracking by default for EF Core read queries to enhance performance. Disabling change tracking for read-only operations reduces memory overhead and speeds up data access significantly.
Handle transient database failures in Entity Framework Core by employing execution strategies. These resilience patterns automatically retry failed operations, ensuring your data access layer remains robust during temporary database connectivity issues.
Yes, you can perform efficient bulk updates and deletes in EF Core by leveraging ExecuteUpdate and ExecuteDelete. These methods execute bulk data modifications directly against the database, bypassing the change tracker for optimal performance.
kevintsengtwProvision and tear down containerized SQL Server and PostgreSQL instances for .NET integration tests.
dimsourIdentify and resolve performance bottlenecks in .NET applications.
microsoftMigrate Entity Framework DbContext registrations to ASP.NET Core dependency injection.
AGIBuildOptimize EF Core and Dapper data access with read/write separation and query strategies.