ef-core

Overview

This skill guides Entity Framework Core development with comprehensive best practices covering DbContext design, entity modeling, fluent API configuration, LINQ queries, migrations, and performance optimization. It ensures developers follow established patterns for change tracking, concurrency control, and relationship mapping throughout their EF Core applications.

Key Features

• DbContext Design - Promotes focused, cohesive DbContext classes with constructor injection, IEntityTypeConfiguration separation, and DbContextFactory patterns for non-web scenarios
• Performance Optimization - Guides use of AsNoTracking() for read-only queries, projection with Select, compiled queries, eager loading with Include(), and pagination to prevent N+1 query problems
• Migration Best Practices - Enforces small, focused, descriptively named migrations with SQL verification before production deployment, migration bundles, and proper data seeding
• LINQ Query Patterns - Teaches proper IQueryable usage, strongly-typed LINQ over raw SQL, specifications pattern for reusable queries, and understanding when queries execute
• Concurrency & Change Tracking - Covers appropriate change tracking strategies, batched SaveChanges calls, optimistic concurrency control, and transaction management for multi-operation workflows

Who is this for?

.NET developers working with Entity Framework Core who want to follow established best practices for data access. Ideal for teams building applications with complex data models who need guidance on performance, migrations, and proper EF Core patterns to avoid common pitfalls like N+1 queries and inefficient change tracking.