Self-hosted alternatives to ef-core

E

ef-core

Entity Framework Core best practices guide covering design, performance

ef-core is an agent skill from the github/awesome-copilot collection that gives best practices for Entity Framework Core, the .NET data access library. It covers eight areas: DbContext design, entity modeling, performance optimization, migrations, querying strategies, change tracking, security and testing. On the context, it recommends keeping each DbContext focused and cohesive, injecting configuration options through the constructor, configuring the model in OnModelCreating with the fluent API, and separating entity configurations into their own IEntityTypeConfiguration classes. It suggests a DbContextFactory for console apps and tests. For entities it advises meaningful primary keys, a clear choice between natural and surrogate keys, proper relationships, constraints and validations set through annotations or the fluent API, and owned entity types for value objects. The rest of the skill covers avoiding slow queries, managing migrations safely, and keeping the change tracker lean. It is useful for developers writing or reviewing data access code in .NET, and for teams who want a shared standard. The guidance is general, so the advice on performance and migrations should be checked against the database and the data volumes of the actual application. The skill is installed with the skills CLI from the github/awesome-copilot repository. Its skills.sh page showed about 9.6K installs and passing results from three security audits at the time of the scan.