![](https://chris.koester.io/index.php/2018/03/25/retrieve-json-data-from-sql-server-using-a-stored-procedure-and-csharp/img/Retrieve_JSON_Data_from_SQL_Server_using_a_Stored_Procedure_and_Csharp.png)
Retrieve JSON Data from SQL Server using a Stored Procedure and C#
The previous post demonstrated how to load JSON into SQL Server using a stored procedure and C#. This post will examine the opposite - how to retrieve JSON data from SQL Server using a stored procedure and C#. Just like with the JSON loading technique, the new JSON functions in SQL Server 2016 allow for this retrieval technique. Here’s how it works in short: Data stored in a database table will be converted to JSON text in the stored procedure and returned to the C# client via an output parameter....