JSON-ORM
6.3.2
dotnet add package JSON-ORM --version 6.3.2
NuGet\Install-Package JSON-ORM -Version 6.3.2
<PackageReference Include="JSON-ORM" Version="6.3.2" />
paket add JSON-ORM --version 6.3.2
#r "nuget: JSON-ORM, 6.3.2"
// Install JSON-ORM as a Cake Addin
#addin nuget:?package=JSON-ORM&version=6.3.2
// Install JSON-ORM as a Cake Tool
#tool nuget:?package=JSON-ORM&version=6.3.2
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();
}
}
See also Json-Orm Nuget Package which uses this package to process its SQL Server derived json into models.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net6.0
- SQLJSONReader (>= 6.1.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
6.3 - Fluent Operations on JsonOrmDatabase : Create SetStoredProcedure GetJsonAsync.