Configure EF Core DbContext and migrations for SQL Server data access.
npx skills add https://github.com/s205109/AHKFlowApp --skill cck-ef-core
Please help me install this Agent Skill. Skill: cck-ef-core Source: https://github.com/s205109/AHKFlowApp/tree/main/.claude/skills/cck-ef-core Command: npx skills add https://github.com/s205109/AHKFlowApp --skill cck-ef-core
Patterns and practices for using EF Core (.NET 10) with SQL Server to implement data access in AHKFlowApp, including DbContext registration, configurations, migrations, and optimization strategies.
Set up EF Core with AppDbContext for SQL Server, enable retry on failure, apply migrations, and inject DbContext directly into MediatR handlers.
High-intent search queries and answers about installing and using this skill.
To use EF Core DbContext directly in handlers, register AppDbContext with dependency injection and inject it into MediatR handlers. This approach removes the repository abstraction layer, enabling direct data access while maintaining testability.
The best way to enable retry on failure for SQL Server in EF Core is to call EnableRetryOnFailure when configuring the DbContext options. This ensures transient error resilience during database connections and command execution.
Optimize EF Core query performance by using projections to select only required columns and compiling queries to cache translation. This reduces data transfer and eliminates repeated SQL generation overhead for frequent operations.
Yes, EF Core code-first migrations fully support interceptor-based auditing. You configure interceptors during DbContext setup to automatically track entity changes, enabling audit logging alongside safe schema migrations.
Use EF Core value converters to map complex property types to SQL Server-compatible formats. You need them when your entity properties require custom serialization logic that does not directly match database column types.
jim60105Initialize C# ASP.NET Core Web API projects with Entity Framework Core and configuration files.
PlazaCCGenerate and apply Drizzle ORM migration scripts for Supabase Postgres.
FortiumPartnersDevelop .NET 9 applications with Clean Architecture, MediatR, Entity Framework Core, and Minimal APIs.
diegoknskStandardize database persistence in .NET 8/10 applications using Dapper.
