CA.Blocks.SqliteDataAccess
3.3.136
There is a newer prerelease version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package CA.Blocks.SqliteDataAccess --version 3.3.136
NuGet\Install-Package CA.Blocks.SqliteDataAccess -Version 3.3.136
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="CA.Blocks.SqliteDataAccess" Version="3.3.136" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CA.Blocks.SqliteDataAccess --version 3.3.136
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CA.Blocks.SqliteDataAccess, 3.3.136"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install CA.Blocks.SqliteDataAccess as a Cake Addin
#addin nuget:?package=CA.Blocks.SqliteDataAccess&version=3.3.136
// Install CA.Blocks.SqliteDataAccess as a Cake Tool
#tool nuget:?package=CA.Blocks.SqliteDataAccess&version=3.3.136
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
This Package is a extention to the DataAccess Blocks, it will pull in the System.Text.Json to allow reading of Json Data Directory from a Column
To use: Direct Usage .NET standard a null value will be returned as Default(YourObject)
var target = new JsonDbColToTypeConverter<YourObject>();
var r = target.GetDataValue(dataRow, "col");
// r will be a type of YourObject
//or if you have we what to use the custom JsonSerializerOptions example PropertyNameCaseInsensitive
var target = new JsonDbColToTypeConverter<YourObject>(new JsonSerializerOptions{ PropertyNameCaseInsensitive = true});
var r = target.GetDataValue(dataRow, "col");
Direct Usage .NET 6 + can be as above by also detail with null values and interfaces
var target = new NullJsonDbColToTypeConverter<IYourObject>(new JsonSerializerOptions{ PropertyNameCaseInsensitive = true});
var r = target.GetDataValue(dataRow, "col");
// r will be a type of IYourObject? and will can be null is null in the DB
Register as a Translator
DefaultDbColToTypeProvider.DefaultInstance.Add(new NullJsonDbColToTypeConverter<IList<ColourValueDataType>>(new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase
}));
In .NET standard you have to use concente types, with .net core 6+ you can use Interface Types
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. 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 is compatible. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- CA.Blocks.DataAccess (>= 3.3.136)
- CA.Blocks.DataAccess.Model (>= 3.3.136)
- Microsoft.Data.Sqlite (>= 8.0.0)
-
net6.0
- CA.Blocks.DataAccess (>= 3.3.136)
- CA.Blocks.DataAccess.Model (>= 3.3.136)
- Microsoft.Data.Sqlite (>= 8.0.0)
-
net8.0
- CA.Blocks.DataAccess (>= 3.3.136)
- CA.Blocks.DataAccess.Model (>= 3.3.136)
- Microsoft.Data.Sqlite (>= 8.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
3.3.138-prerelease | 66 | 3/16/2024 |
3.3.136 | 93 | 2/24/2024 |
3.3.135-prerelease | 67 | 2/24/2024 |
3.3.133-prerelease | 68 | 2/24/2024 |
3.2.129 | 126 | 1/13/2024 |
3.2.128-prerelease | 60 | 1/13/2024 |
3.2.127-prerelease | 164 | 11/26/2023 |
3.2.126-prerelease | 109 | 11/18/2023 |
3.2.125-prerelease | 97 | 11/18/2023 |
3.1.124 | 189 | 11/17/2023 |
3.1.123-prerelease | 83 | 11/17/2023 |
3.1.122 | 164 | 8/29/2023 |
3.1.121-prerelease | 117 | 8/29/2023 |
3.1.120 | 159 | 8/14/2023 |
3.1.119-prerelease | 112 | 8/14/2023 |
3.1.118 | 151 | 7/30/2023 |
3.1.117-prerelease | 154 | 7/24/2023 |
3.1.116-prerelease | 144 | 7/24/2023 |
3.1.115 | 149 | 6/26/2023 |
3.1.114-prerelease | 112 | 6/11/2023 |
3.1.110 | 199 | 3/31/2023 |
3.1.109-prerelease | 147 | 3/31/2023 |
3.1.108-prerelease | 138 | 3/31/2023 |
3.1.107 | 201 | 3/28/2023 |
3.1.106-prerelease | 138 | 3/28/2023 |
3.1.104 | 300 | 1/4/2023 |
3.1.103-prerelease | 166 | 1/4/2023 |
3.1.102-prerelease | 155 | 12/10/2022 |
3.1.101 | 325 | 11/21/2022 |
3.1.100-prerelease | 146 | 11/13/2022 |
3.1.99-prerelease | 152 | 11/5/2022 |
3.1.98-prerelease | 141 | 11/2/2022 |
3.1.97-prerelease | 132 | 11/2/2022 |
3.1.95-prerelease | 157 | 11/1/2022 |
3.1.83 | 386 | 10/22/2022 |