Tag
ef-core
5 articles tagged with “ef-core”
LINQ in .NET 9: Deferred Execution, IQueryable, and the New Operators
Practical LINQ for backend engineers — IEnumerable vs IQueryable, the .NET 9 CountBy/AggregateBy/Index additions, and EF Core translation pitfalls.
EF Core 9 in Production: Tracking, Projections, and the Performance Levers That Matter
Bulk updates with ExecuteUpdateAsync, projection over Include, AsSplitQuery for cartesian explosion, auto-compiled models, and IDbContextFactory for parallel work.
The Repository Pattern in .NET: When It Helps, When It Hurts, and What to Use Instead
Why generic IRepository<T> over EF Core is usually an anti-pattern, when domain repositories earn their keep, and the specification pattern as a cleaner alternative.
PostgreSQL 17/18 in 2026: MVCC, Indexes, and EF Core 9
PG 17 (Sept 2024) async I/O, PG 18 (Sept 2025) features, MVCC + xmin/xmax, btree/GIN/GiST/BRIN, JSONB jsonb_path_ops, partial/functional indexes, EF Core 9 + Npgsql 9, EXPLAIN (ANALYZE, BUFFERS), VACUUM and PgBouncer pitfalls.
Transactions and Isolation: ANSI Levels, MVCC, and SERIALIZABLE
Four ANSI levels, MVCC vs 2PL, EF Core 9 BeginTransactionAsync, [Timestamp] rowversion optimistic concurrency, FOR UPDATE SKIP LOCKED, write-skew, retry on 40001/40P01 with exponential backoff, transactional outbox over 2PC.

