How does it help with database performance?

The skill enforces the use of projections (Select) to avoid loading unnecessary columns and promotes compiled queries for frequently executed code paths to minimize overhead.

Does this skill support older versions of .NET?

While specifically optimized for .NET 10 features like improved bulk updates, many of the architectural patterns and LINQ optimizations are applicable to EF Core 6, 7, and 8.

Does it support complex features like multi-tenancy?

Absolutely. It includes patterns for implementing Global Query Filters and Interceptors to handle multi-tenant data isolation and automatic auditing.

Can it help automate database migrations?

Yes, it provides standardized workflows for the dotnet-ef CLI, including best practices for reviewing generated code and generating idempotent SQL scripts for production.

EF Core .NET 10 Expert

Name: EF Core .NET 10 Expert
Author: codewithmukesh

bycodewithmukesh

•

189

•

数据库管理

Implements high-performance Entity Framework Core patterns and database management workflows for .NET 10 applications.

This skill transforms Claude into a specialized .NET 10 database architect, focusing on modern Entity Framework Core implementation and best practices. It provides expert guidance on configuring DbContext using modular configurations, optimizing data retrieval through projections and compiled queries, and executing high-efficiency bulk operations with ExecuteUpdateAsync and ExecuteDeleteAsync. By enforcing clean architecture principles—such as avoiding unnecessary repository abstractions and preventing N+1 issues—it ensures your data access layer is scalable, maintainable, and optimized for production environments.

主要功能

01189 GitHub stars

02Efficient bulk data operations using ExecuteUpdate and ExecuteDelete APIs.

03Advanced DbContext configuration and entity mapping using IEntityTypeConfiguration.

04Standardized migration workflows including CLI commands and idempotent SQL generation.

05Performance-focused query optimization via DTO projections and compiled queries.

06Automated audit trails and soft deletes implemented through SaveChangesInterceptors.

使用场景

01Implementing complex cross-cutting concerns like multi-tenancy and global query filters.

02Building scalable, high-performance data access layers for .NET 10 microservices.

03Refactoring existing LINQ queries to eliminate N+1 issues and over-fetching.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add codewithmukesh/dotnet-claude-kit ef-core

For use in Claude.ai and ChatGPT

Download Skill