Start Debugging

Tag: efcore

10 posts

2026-07-08 migration efcore dotnet

Migrate from HasData seeding to UseAsyncSeeding in EF Core 11

A step-by-step guide to moving seed data off HasData and onto UseSeeding and UseAsyncSeeding in EF Core 11, including the DeleteData migration trap that wipes your existing rows if you skip it.

2026-07-07 comparison efcore dotnet

Named query filters vs a single global query filter in EF Core 11: which should you use?

Both produce the same SQL. Reach for named filters only when you need to disable one predicate independently; a single combined filter is simpler for one concern in EF Core 11.

2026-07-04 errors efcore dotnet

Fix: "The LINQ expression could not be translated" in EF Core 11

EF Core 11 throws this when a Where or OrderBy calls a method it cannot turn into SQL. Rewrite the predicate into translatable operators, or pull the data client-side with AsEnumerable first.

2026-07-04 errors efcore dotnet

Fix: "The required column 'X' was not present in the results of a 'FromSql' operation" in EF Core 11

EF Core throws this when your raw SQL does not return every column the entity maps to, or the column names do not match. Return all mapped columns with matching names, or query a scalar/keyless type instead.

2026-07-03 dotnet efcore csharp

How to use named query filters for soft delete and multi-tenancy in EF Core 11

Apply two independent global query filters to the same entity in EF Core 11: a soft-delete filter and a tenant filter, each named so you can disable one without the other via IgnoreQueryFilters.

2026-06-30 comparison efcore dotnet

HasData vs UseSeeding for seeding data in EF Core 11: which should you use?

Use HasData only for fixed, model-owned reference data. Use UseSeeding and UseAsyncSeeding for everything else in EF Core 11. A side-by-side comparison with the rules that force the decision.

2026-06-21 dotnet efcore csharp

How to seed a many-to-many relationship in EF Core 11

Seed the join table of a many-to-many relationship in EF Core 11: the implicit shadow keys you must name yourself, the UsingEntity HasData pattern, and the runtime UseSeeding alternative that works with skip navigations.

2026-06-21 dotnet efcore csharp

How to seed data with UseSeeding and UseAsyncSeeding in EF Core 11

Seed reference data the right way in EF Core 11 with UseSeeding and UseAsyncSeeding: where to configure them, when they run, the idempotency check you cannot skip, and why you must implement both.

2026-06-08 dotnet efcore csharp

How to use EF Core 11 interceptors for auditing

Stamp CreatedBy/ModifiedOn columns and write a full change-trail with an ISaveChangesInterceptor in EF Core 11, including the DI lifetime, current-user, and ExecuteUpdate gotchas.

2026-04-14 efcore efcore-11 cosmos-db

EF Core 11 turns on Cosmos DB transactional batches by default

EF Core 11 groups Cosmos DB writes into transactional batches per container and partition on every SaveChanges, giving best-effort atomicity and fewer roundtrips without any code changes.