SQLJSONReader 6.1.0

SQLJSONReader

An extension to read JSON from SQL server off of a SQLCommand to get data. This package is in Nuget as SQLJsonReader

Usage, include using SQLJSON.Extensions; for the use and addition of ExecuteJsonReaderAsync and ExecuteJsonReader to read JSON from SQL Server after a stored procedure call returns JSON using the for JSON.

string result;

using (SqlConnection conn = new SqlConnection(connection))
{
    conn.Open();

    using (var cmd = new SqlCommand(sproc, conn) { CommandType = CommandType.StoredProcedure, CommandTimeout = 600 })
    {
        if (parameters != null)
            cmd.Parameters.AddRange(parameters);

        var reader = await cmd.ExecuteJsonReaderAsync();

        result = await reader.ReadAllAsync();
    }
}