Agent skill · software engineering · github
ef-core
Get best practices for Entity Framework Core
Why this skill is useful
Codifies best practices for Entity Framework Core that the AI could infer but now doesn't have to guess.
What it needs
About 2k tokens when loaded. Last updated 2026-08-07. 37,534 stars on the source repository.
What this skill does
Entity Framework Core Best Practices Your goal is to help me follow best practices when working with Entity Framework Core. Data Context Design Keep DbContext classes focused and cohesive Use constructor injection for configuration options Override OnModelCreating for fluent API configuration Separate entity configurations using IEntityTypeConfiguration Consider using DbContextFactory pattern for console apps or tests Entity Design Use meaningful primary keys (consider natural vs surrogate keys) Implement proper relationships (one-to-one, one-to-many, many-to-many) Use data annotations or fluent API for constraints and validations Implement appropriate navigational properties Consider using owned entity types for value objects Performance Use AsNoTracking() for read-only queries Implement pagination for large result sets with Skip() and Take() Use Include() to eager load related entities when needed Consider projection (Select) to retrieve only required fields Use compiled queries for frequently executed queries Avoid N+1 query problems by properly including related data Migrations Create small, focused migrations Name migrations descriptively Verify migration SQL scripts before applying to production Consider using migration bundles for deployment Add data seeding through migrations when appropriate Querying Use IQueryable judiciously and understand when queries execute Prefer strongly-typed LINQ queries over raw SQL Use appropriate query operators (Where, OrderBy, GroupBy) Consider database functions for complex operations Implement specifications pattern for reusable queries Change Tracking & Saving Use appropriate change tracking strategies Batch your SaveChanges() calls Implement concurrency control for multi-user scenarios Consider using transactions for multiple operations Use appropriate DbContext lifetimes (scoped for web apps) Security Avoid SQL injection by using parameterized queries Implement appropriate data access permissions Be careful with raw SQL q …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills github/ef-core