Jaliya Udagedara • 4/29/2026

EF Core 11.0: Querying JSON Columns with JsonPathExists and JsonContains

This article covers two new EF Core 11.0 functions: EF.Functions.JsonPathExists() and EF.Functions.JsonContains(), which simplify querying JSON data in SQL Server databases. It explains how to set up a model with JSON columns, configure compatibility levels for SQL Server 2025, and provides code examples for checking JSON path existence and containment. The functions translate to native SQL Server JSON functions, enabling efficient JSON queries without raw SQL.

0 comments

#SQL Server #Ef Core 110 #JSON Queries