Implement Entity Framework Core patterns for .NET database queries and migrations.
npx skills add https://github.com/Maj3D10/Training-Platform --skill ef-core-maj3d10
Please help me install this Agent Skill. Skill: ef-core Source: https://github.com/Maj3D10/Training-Platform/tree/main/.agent/skills/ef-core Command: npx skills add https://github.com/Maj3D10/Training-Platform --skill ef-core-maj3d10
This Skill helps you implement reliable, high-performance Entity Framework Core data access patterns so your queries, migrations, and bulk operations stay maintainable and efficient.
Use the ef-core skill to design a DbContext and write projection-based LINQ queries with EF Core and an explicit migrations workflow for a .NET 10 application.
High-intent search queries and answers about installing and using this skill.
To avoid N+1 problems in Entity Framework Core, use projection-based querying with Select to fetch only needed DTO fields, preventing over-fetching and reducing unnecessary database round trips.
The best way to perform bulk updates in EF Core is using ExecuteUpdateAsync and ExecuteDeleteAsync, which execute operations directly against the database for high performance without loading entities into memory.
Configure a DbContext with clean entity mapping by implementing IEntityTypeConfiguration and using ApplyConfigurationsFromAssembly, organizing entity mapping into discoverable, maintainable configuration classes.
Compiled queries improve EF Core performance by pre-compiling LINQ query translation, reducing overhead for frequently executed queries and optimizing database access patterns.
Common EF Core anti-patterns to avoid include lazy loading pitfalls, in-memory filtering mistakes, and fire-and-forget async bugs, ensuring correct query execution and data consistency.
Add cross-cutting concerns like auditing to EF Core SaveChanges by implementing SaveChangesInterceptor, which intercepts persistence operations to inject global filters and auditing logic in a production-safe manner.
jim60105Scaffold EF Core DbContext and entity models from existing databases.
Brendon3578Synchronize Entity classes and DbContext files with docker/setup.sql schema changes.
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.
