ef-core

Entity Framework Core best practices guide covering design, performance, security, and testing patterns. Your goal is to help me follow best practices when working with Entity Framework Core. When reviewing my EF Core code, identify issues and suggest improvements that follow these best practices. - Covers eight core areas: DbContext design, entity modeling, performance optimization, migrations, querying strategies, change tracking, security, and testing approaches - Emphasizes practical patterns like DbContextFactory, IEntityTypeConfiguration separation, AsNoTracking() for read-only queries, and compiled queries for frequently executed operations - Includes migration best practices such as descriptive naming, SQL verification before production, and data seeding through migrations - Addresses common pitfalls: N+1 query problems, SQL injection prevention, appropriate DbContext lifetimes, and concurrency control for multi-user scenarios - Recommends testing strategies using in-memory providers for unit tests and SQLite for integration tests - 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 - Use meaningful primary keys (consider natural vs...