ef-core

To optimize EF Core queries, use projection-first queries to select only necessary DTO fields and avoid ToListAsync-before-filter anti-patterns. Apply compiled queries for hot paths to reduce query compilation overhead and improve data access performance.

Safe EF Core migrations require production-ready scripts and careful workflow management. You should generate idempotent scripts and review migration steps to prevent data loss, ensuring schema changes are applied safely without downtime or unsafe operations.

Configuring DbContext for multi-tenancy and soft deletes involves applying global query filters to isolate tenant data and using interceptors for auditing. This cross-cutting approach ensures deleted records are hidden and tenant boundaries are enforced automatically.

Use ExecuteUpdateAsync and ExecuteDeleteAsync for bulk operations when you need to modify or delete large datasets without loading entities into memory. These commands run directly against the database, bypassing the change tracker for high-throughput updates.

Yes, EF Core supports value converters to map strongly-typed IDs to primitive database columns. You configure converters in your entity configurations to translate custom ID structures during database reads and writes, maintaining domain model type safety.

Lazy loading causes performance pitfalls by triggering unexpected database queries during entity traversal. Direct DbContext usage is often preferred over the repository pattern for data access, reducing abstraction overhead while maintaining testable query logic.