Effectively, those methods can become just thin wrappers around SQL queries. If you want to play with SQL Server’s JSON support (or the other big new feature in SQL Server 2016, temporal tables), you ...

If you have an array of a nested object that you want to extract, then you must resort to the ... However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a ...

This SQL feature allows you to query within a result set, ... Rather than returning two queries and using code to compare arrays, you can get the exact results with a single statement.