efcore-patterns

SKILL.md

Configure your DbContext to disable change tracking by default. This improves performance for read-heavy workloads.

| Display data in UI | No | Read-only, no updates | | API GET endpoints | No | Returning data, no mutations | | Update single entity | Yes or explicit Update() | Need to save changes | | Complex update with navigation | Yes | Tracking handles relationships | | Batch operations | No + ExecuteUpdate | More efficient |

CRITICAL: Always use EF Core CLI commands to manage migrations. Never:

Entity Framework Core best practices including NoTracking by default, query splitting for navigation collections, migration management, dedicated migration services, and common pitfalls to avoid. Source: aaronontheweb/dotnet-skills.

View raw