Ef Core

Migrations

• Create small, focused migrations
• Name migrations descriptively
• Verify migration SQL scripts before applying to production
• Consider using migration bundles for deployment
• Add data seeding through migrations when appropriate

Querying

• Use IQueryable judiciously and understand when queries execute
• Prefer strongly-typed LINQ queries over raw SQL
• Use appropriate query operators (Where, OrderBy, GroupBy)
• Consider database functions for complex operations
• Implement specifications pattern for reusable queries

Change Tracking & Saving

• Use appropriate change tracking strategies
• Batch your SaveChanges() calls
• Implement concurrency control for multi-user scenarios
• Consider using transactions for multiple operations
• Use appropriate DbContext lifetimes (scoped for web apps)

Security

• Avoid SQL injection by using parameterized queries
• Implement appropriate data access permissions
• Be careful with raw SQL queries
• Consider data encryption for sensitive information
• Use migrations to manage database user permissions

Testing

• Use in-memory database provider for unit tests
• Create separate testing contexts with SQLite for integration tests
• Mock DbContext and DbSet for pure unit tests
• Test migrations in isolated environments
• Consider snapshot testing for model changes

When reviewing my EF Core code, identify issues and suggest improvements that follow these best practices.