Optimize EF Core queries, migrations, and bulk operations in .NET applications.
npx skills add https://github.com/Trossitec/dotnet-claude-kit --skill ef-core-trossitec
Please help me install this Agent Skill. Skill: ef-core Source: https://github.com/Trossitec/dotnet-claude-kit/tree/main/skills/ef-core Command: npx skills add https://github.com/Trossitec/dotnet-claude-kit --skill ef-core-trossitec
This Skill helps you implement Entity Framework Core in a way that avoids common performance traps and correctness issues, so your .NET app queries, migrations, and bulk operations stay efficient as your schema and codebase grow.
IEntityTypeConfiguration<T> and ApplyConfigurationsFromAssembly to keep model configuration maintainable..Select() and avoid loading unnecessary data.ExecuteUpdateAsync/ExecuteDeleteAsync for bulk operations, SaveChangesInterceptor for audit/soft-delete cross-cutting concerns, and compiled queries for frequently repeated query shapes.When you are working on an EF Core task, ask the assistant to generate or refactor your DbContext configuration and the specific query (including projections, pagination, and any needed interceptors or bulk operations) to match modern .NET 10 practices.
High-intent search queries and answers about installing and using this skill.
To fix N+1 query problems in EF Core, use projections with `.Select()` to fetch only the required fields instead of loading entire entities and related collections. This prevents over-fetching and optimizes hot-path read scenarios.
The best way to perform bulk updates and deletes in EF Core is using `ExecuteUpdateAsync` and `ExecuteDeleteAsync`. These execute directly against the database, bypassing the DbContext change tracker for efficient bulk workflows.
Configure DbContext for maintainable entity mappings by implementing `IEntityTypeConfiguration<T>` and calling `ApplyConfigurationsFromAssembly`. This keeps model configuration isolated and discoverable as your schema grows.
Use compiled queries in EF Core for frequently repeated query shapes on hot paths. `EF.CompileAsyncQuery` pre-compiles the LINQ query, reducing query translation overhead and improving read performance.
Safely apply EF Core migrations to production by treating them as code, reviewing them explicitly, and generating idempotent SQL scripts for deployment. Avoid direct context migration in production environments.
Yes, you can use `SaveChangesInterceptor` in EF Core to handle soft deletes and audit logging. It intercepts save operations to apply cross-cutting concerns like global query filters for multi-tenancy automatically.
microsoftMigrate LINQ to SQL data access layers to Entity Framework Core.
jshsakuraDesign, review, and optimize SQL queries for correctness and performance.
microsoftMigrate Entity Framework DbContext registrations to ASP.NET Core dependency injection.
wshaddixOptimize .NET database access with CQRS, AsNoTracking, and SQL joins.