Optimize Entity Framework Core LINQ queries and DbContext migration practices.
npx skills add https://github.com/Resgrid/Core --skill ef-core-resgrid
Please help me install this Agent Skill. Skill: ef-core Source: https://github.com/Resgrid/Core/tree/main/.opencode/skills/ef-core Command: npx skills add https://github.com/Resgrid/Core --skill ef-core-resgrid
This skill helps you build efficient, reliable data access layers with Entity Framework Core by reducing over-fetching, avoiding common performance traps, and making schema changes and bulk operations safer to manage.
IEntityTypeConfiguration<T>.ExecuteUpdateAsync and ExecuteDeleteAsync, supported by interceptors for cross-cutting concerns like auditing and soft deletes.Load the ef-core skill and ask for an EF Core query or DbContext/migration pattern recommendation tailored to your scenario, such as “Optimize this LINQ query to avoid N+1 and ensure it projects into DTOs.”
High-intent search queries and answers about installing and using this skill.
To optimize EF Core LINQ queries and avoid N+1, use projection-first patterns to select only required columns into DTOs, preventing unnecessary entity loading. This approach eliminates over-fetching and ensures efficient query execution.
The best way to configure DbContext and migrations is using IEntityTypeConfiguration for schema separation and treating migrations as reviewed code. This ensures production-ready change management with correct precision, indexes, and maintainable configuration.
Perform efficient bulk updates and deletes in EF Core using ExecuteUpdateAsync and ExecuteDeleteAsync. These methods apply high-performance data modifications directly without loading entities into memory, and you can use interceptors for auditing or soft deletes.
You need compiled queries in EF Core when optimizing high-frequency read paths where query translation overhead impacts performance. This Skill provides guidance on implementing compiled queries alongside value converters and query filters for hot-path scenarios.
Yes, EF Core interceptors can handle auditing and soft deletes automatically by capturing cross-cutting concerns during data modifications. This Skill supports using interceptors alongside ExecuteUpdateAsync and ExecuteDeleteAsync for consistent enforcement.
You should use IEntityTypeConfiguration instead of fluent API in OnModelCreating to separate schema configuration into maintainable, testable classes. This prevents bloated DbContext definitions and enforces production-ready configuration practices for migrations.
jim60105Scaffold EF Core DbContext and entity models from existing databases.
sigmadigitalzaReview database schemas, migration files, and query performance.
microsoftMigrate Entity Framework DbContext registrations to ASP.NET Core dependency injection.
FaysilAlshareefWrite read-optimized SQL queries with Dapper and EF Core.