Entity Framework Core Best Practices

When to Use

• Designing or restructuring a DbContext, entities, or relationships
• Writing LINQ queries against EF Core, or troubleshooting N+1 / performance issues
• Creating, naming, or reviewing EF Core migrations
• Implementing concurrency control, repository patterns, or change tracking strategies
• Setting up EF Core tests with SQLite in-memory or Testcontainers

Data Context Design

• Keep DbContext classes focused and cohesive
• Use constructor injection for configuration options
• Override OnModelCreating for fluent API configuration
• Separate entity configurations using IEntityTypeConfiguration
• Consider using DbContextFactory pattern for console apps or tests

Entity Design