Blog

Mert Özen's blog posts on software development, backend, frontend, and DevOps.

Series

What's New in EF Core 10: Named Query Filters, LeftJoin and Complex Types in JSON

Named query filters and IgnoreQueryFilters(["..."]), LeftJoin/RightJoin, ExecuteUpdateAsync with a regular lambda, complex types and ComplexCollection mapped to JSON, padded parameterized collections, vector search with SqlVector and the SQLite DateTimeOffset breaking change in EF Core 10 LTS.

5 Nov 2026 9 min 20

Database PART 26

What's New in EF Core 8: Complex Types, Primitive Collections and SqlQuery<T>

Primitive collections and json_each, ComplexProperty for value objects, SqlQuery<T> for non-entity types, no-tracking lazy loading, JSON on SQLite and HierarchyId in EF Core 8 LTS, plus Contains moving to OPENJSON and UseCompatibilityLevel(120).

5 Nov 2026 10 min 24