Database Transactions & Concurrency: EF Core Production Patterns
Transaction isolation levels, optimistic locking with RowVersion, DbUpdateConcurrencyException handling, and deadlock prevention in EF Core.
Insights tagged with EF Core
Transaction isolation levels, optimistic locking with RowVersion, DbUpdateConcurrencyException handling, and deadlock prevention in EF Core.
The N+1 queries, missing projections, and tracking overhead that pass code review and slow down production systems.
EF Core 10 adds native vector search with SqlVector and VECTOR_DISTANCE. Store embeddings alongside relational data and query by semantic similarity.
The boring baseline that makes content sites fast: OutputCache policies, EF Core query shaping, compression, and stable indexing.