SQLJSONReader 6.1.0

.NET 6.0
Install-Package SQLJSONReader -Version 6.1.0
dotnet add package SQLJSONReader --version 6.1.0
<PackageReference Include="SQLJSONReader" Version="6.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SQLJSONReader --version 6.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SQLJSONReader, 6.1.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install SQLJSONReader as a Cake Addin
#addin nuget:?package=SQLJSONReader&version=6.1.0

// Install SQLJSONReader as a Cake Tool
#tool nuget:?package=SQLJSONReader&version=6.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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();
    }
}
Product Versions
.NET net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on SQLJSONReader:

Package Downloads
JSON-ORM

An ORM based on Models created from JSON returned from SQL Server Sprocs.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
6.1.0 73 3/21/2022
6.0.0 111 2/6/2022
5.0.0 315 2/3/2021
1.4.1 302 6/18/2020
1.4.0 255 6/18/2020
1.3.1.1 371 3/7/2020
1.3.1 293 3/7/2020
1.1.0 588 2/17/2019

Removal of Newtonsoft.