Blog
Mert Özen's blog posts on software development, backend, frontend, and DevOps.
LINQ with Real Data: Scenarios on Orders Read from a JSON File
LINQ over orders read from a file with System.Text.Json: the casing trap and JsonSerializerDefaults.Web, validating the data (duplicates, unknown customers, bad quantities), monthly revenue, best sellers, a customer report with GroupJoin, writing JSON back and streaming with DeserializeAsyncEnumerable.
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.
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).
What's New in EF Core 7: ExecuteUpdate, ExecuteDelete, JSON Columns and TPC
ExecuteUpdate/ExecuteDelete, ToJson for owned types in JSON columns, TPC inheritance, IMaterializationInterceptor, FromSql and SqlQuery<int> in EF Core 7, plus moving from EF Core 6 with breaking changes like Encrypt=True and HasTrigger.
JavaScript JSON: JSON.stringify, JSON.parse, try/catch and Deep Copies
We learn JSON's syntax rules, indentation and replacers with JSON.stringify, which values get lost, JSON.parse and revivers, catching broken JSON with try/catch, and why structuredClone wins for deep copies.