Jaliya Udagedara • 10/29/2025

EF Core 10.0: Support for Partially Updating JSON Columns with ExecuteUpdate/ExecuteUpdateAsync

This technical article details a new feature in Entity Framework Core 10.0: the ability to perform partial updates on JSON columns using the ExecuteUpdate and ExecuteUpdateAsync methods. It provides code examples showing how to update a nested property like a postal code within a JSON document, explains the generated SQL for both SQL Server 2025 (using the `modify` method) and older versions (using `JSON_MODIFY`), and clarifies usage with ComplexProperty mappings.

0 comments

#json #database #SQL Server