Start Debugging

Tag: ef-core

79 posts · Page 6 of 8

2026-06-10 errors csharp dotnet

Fix: The configured execution strategy 'SqlServerRetryingExecutionStrategy' does not support user-initiated transactions

EnableRetryOnFailure conflicts with BeginTransaction. Wrap the whole transaction in db.Database.CreateExecutionStrategy().ExecuteAsync(...) so it retries as one unit.

2026-06-04 comparison ef-core ef-core-11

EF Core ExecuteUpdate vs loading entities and SaveChanges: which should you use?

A decision guide and real benchmark for EF Core 11: use ExecuteUpdate for set-based writes by a predicate, and the load-then-SaveChanges path only when you need the change tracker, interceptors, or a complex object graph.

2026-06-04 migration ef-core ef-core-6

Migrate EF Core 6 to EF Core 11: breaking changes that actually bite

A version-pinned migration guide from EF Core 6.0 to EF Core 11.0, walking the breaking changes across EF7, 8, 9, 10, and 11 that break real apps: Encrypt=True, OPENJSON Contains, PendingModelChangesWarning, the native json column, and the SqlClient 7.0 split.

2026-06-02 errors csharp dotnet

Fix: ObjectDisposedException: Cannot access a disposed context instance

Your fire-and-forget task captured a request-scoped DbContext that the DI scope already disposed. Resolve a fresh context inside the task with IServiceScopeFactory or IDbContextFactory.

2026-06-01 ef-core dotnet-11 dotnet-cli

EF Core 11 Preview 4: Stop Retyping --project and --startup-project with .config/dotnet-ef.json

EF Core 11 Preview 4 lets the dotnet ef tool read default option values from a .config/dotnet-ef.json file, so split solutions no longer force you to pass --project and --startup-project on every command.

2026-06-01 ef-core ef-core-11 csharp

How to use query splitting to avoid a cartesian explosion in EF Core 11

When you Include two sibling collections, EF Core 11 returns the cross product and your row count explodes. Here is how AsSplitQuery fixes it, how to turn it on globally, and the consistency and ordering gotchas to watch for.

2026-05-31 ef-core ef-core-11 csharp

How to use ExecuteUpdate and ExecuteDelete for bulk writes in EF Core 11

A complete guide to ExecuteUpdate and ExecuteDelete in EF Core 11: the SQL they emit, the change-tracker gotcha that silently overwrites your bulk write, transactions, concurrency control with the affected-row count, and the EF Core 10 delegate setters that let you build conditional updates with plain if statements.

2026-05-26 ef-core dotnet-11 sql-server

EF Core 11 Preview 4: Temporal Table Period Columns Can Finally Be Real Properties

EF Core 11 Preview 4 drops the long-standing shadow-property restriction on SQL Server temporal tables. PeriodStart and PeriodEnd can now be regular CLR properties, configured with strongly-typed HasPeriodStart and HasPeriodEnd lambdas.

2026-05-23 comparison ef-core dapper

EF Core compiled queries vs raw SQL vs Dapper: which read path wins?

For read-heavy paths in .NET 11, plain EF Core with AsNoTracking is within ~5% of Dapper. Reach for compiled queries on a profiled single-row hot path, and Dapper only for the lowest latency or SQL LINQ can't express.

2026-05-21 comparison csharp linq

IEnumerable vs IAsyncEnumerable vs IQueryable in C#: which one should the method return?

Three sequence interfaces, three execution models. Use IQueryable when a database can translate the query, IAsyncEnumerable when the producer is async and you want to stream, IEnumerable for everything else in memory.