optimizing-ef-core-queries
OfficialBoost EF Core query performance
Authordotnet
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses slow or inefficient Entity Framework Core (EF Core) queries that lead to high database load and poor application performance.
Core Features & Use Cases
- N+1 Problem Resolution: Identifies and fixes the common N+1 query pattern.
- Query Tracking Optimization: Guides the use of
AsNoTracking()for read-only scenarios. - Compiled Queries: Demonstrates how to use compiled queries for performance-critical paths.
- Use Case: When your application experiences slow data retrieval and logs show excessive SQL statements, this Skill provides actionable steps to optimize EF Core queries for better performance.
Quick Start
Use the optimizing-ef-core-queries skill to optimize the provided slow EF Core query.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: optimizing-ef-core-queries Download link: https://github.com/dotnet/skills/archive/main.zip#optimizing-ef-core-queries Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.