dotnet-entity-framework-core

What problem does it solve?

This Skill helps .NET developers design, tune, and review Entity Framework Core data access, ensuring efficient modeling, migrations, query performance, and proper lifetime management for modern applications.

Core Features & Use Cases

• Data Modeling: Guidance on configuring entities, relationships, and constraints using Fluent API or Data Annotations.
• Query Optimization: Techniques to write efficient LINQ queries, avoid N+1 problems, and leverage AsNoTracking, projections, and compiled queries.
• Migrations Management: Best practices for creating, reviewing, and applying database migrations, including data migrations.
• Performance Tuning: Strategies for indexing, batch operations, and concurrency control.
• Use Case: Optimize a slow-loading e-commerce product page by analyzing EF Core queries, ensuring proper indexing, and implementing efficient data loading strategies to reduce database load and improve response times.

Quick Start

Review the provided EF Core query for potential N+1 issues and suggest optimizations.