Support for SQL Server 2025 native JSON Data Type in LINQ to SQL Driver
I would like to request support for the latest JSON data type enhancements introduced in SQL Server 2025 within the LINQ to SQL driver for LINQPad.
Currently, when using LINQPad with a SQL Server 2025 database that contains tables with columns of type json (not nvarchar(max)), the LINQ to SQL driver does not properly recognize or display these columns. The JSON data is lost or not visible in the results when querying the table, which significantly hinders the ability to work with modern JSON data in SQL Server 2025.
For example, in the StudentsJson table:
- StudentId (int, PK)
- JsonData (json, not null)
- CreatedDate (datetime, null)
When querying this table via LINQ to SQL, the JsonData column is not displayed or its content is not accessible, whereas it works correctly when using raw SQL queries.
Expected Behavior:
1. The LINQ to SQL driver should correctly detect and map SQL Server 2025 json columns.
2. The JSON data should be displayed in the LINQPad results view, ideally with proper formatting and syntax highlighting.
3. LINQ queries should be able to access and manipulate the JSON data, similar to how it works with raw SQL.
This feature is crucial for developers adopting the latest SQL Server capabilities and relying on LINQPad as their primary tool for data exploration and prototyping.
Ref links about json data type:
https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=sql-server-ver17https://learn.microsoft.com/en-us/sql/t-sql/statements/create-json-index-transact-sql?view=sql-server-ver17