ef-core

EF Core DbContext configuration using IEntityTypeConfiguration keeps entity mappings organized into separate classes. This pattern maintains clean code structure and scalable data access setup across enterprise .NET 10 applications.

EF Core projection-based queries load only needed data by selecting specific columns upfront, avoiding N+1 query execution. This technique optimizes data access performance by reducing transferred data and eliminating related entity loading bottlenecks.

EF Core interceptors handle soft deletes and auditing by capturing SaveChanges events to apply global query filters and track modifications automatically. This cross-cutting approach enforces data consistency without modifying core business logic.

EF Core supports bulk operations using ExecuteUpdateAsync and ExecuteDeleteAsync to modify or remove database records directly. These methods execute immediate SQL statements, bypassing entity tracking and ChangeTracker overhead for high-performance batch processing.

EF Core compiled queries cache translation overhead by pre-compiling LINQ expressions, while value converters handle custom type mapping between CLR properties and database columns. Both features enhance query execution speed and type safety in high-throughput applications.

EF Core global query filters enable multi-tenancy and soft-delete patterns by automatically applying LINQ predicates to entity queries. Configured in OnModelCreating, these filters enforce tenant isolation and data visibility rules consistently across the application.