CA.Blocks.MySQLDataAccess
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.MySQLDataAccess --version 3.3.136
NuGet\Install-Package CA.Blocks.MySQLDataAccess -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.MySQLDataAccess" 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.MySQLDataAccess --version 3.3.136
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CA.Blocks.MySQLDataAccess, 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.MySQLDataAccess as a Cake Addin
#addin nuget:?package=CA.Blocks.MySQLDataAccess&version=3.3.136
// Install CA.Blocks.MySQLDataAccess as a Cake Tool
#tool nuget:?package=CA.Blocks.MySQLDataAccess&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)
- MySqlConnector (>= 2.3.1)
-
net6.0
- CA.Blocks.DataAccess (>= 3.3.136)
- CA.Blocks.DataAccess.Model (>= 3.3.136)
- MySqlConnector (>= 2.3.1)
-
net8.0
- CA.Blocks.DataAccess (>= 3.3.136)
- CA.Blocks.DataAccess.Model (>= 3.3.136)
- MySqlConnector (>= 2.3.1)
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 | 72 | 3/16/2024 |
3.3.136 | 87 | 2/24/2024 |
3.3.135-prerelease | 70 | 2/24/2024 |
3.3.133-prerelease | 77 | 2/24/2024 |
3.2.129 | 130 | 1/13/2024 |
3.2.128-prerelease | 65 | 1/13/2024 |
3.2.127-prerelease | 153 | 11/26/2023 |
3.2.126-prerelease | 76 | 11/18/2023 |
3.2.125-prerelease | 80 | 11/18/2023 |
3.1.124 | 188 | 11/17/2023 |
3.1.123-prerelease | 66 | 11/17/2023 |
3.1.122 | 132 | 8/29/2023 |
3.1.121-prerelease | 87 | 8/29/2023 |
3.1.120 | 119 | 8/14/2023 |
3.1.119-prerelease | 107 | 8/14/2023 |
3.1.118 | 132 | 7/30/2023 |
3.1.117-prerelease | 119 | 7/24/2023 |
3.1.116-prerelease | 121 | 7/24/2023 |
3.1.115 | 139 | 6/26/2023 |
3.1.114-prerelease | 111 | 6/11/2023 |
3.1.110 | 167 | 3/31/2023 |
3.1.109-prerelease | 114 | 3/31/2023 |
3.1.108-prerelease | 128 | 3/31/2023 |
3.1.107 | 191 | 3/28/2023 |
3.1.106-prerelease | 134 | 3/28/2023 |
3.1.104 | 293 | 1/4/2023 |
3.1.103-prerelease | 107 | 1/4/2023 |
3.1.102-prerelease | 126 | 12/10/2022 |
3.1.101 | 304 | 11/21/2022 |
3.1.100-prerelease | 122 | 11/13/2022 |
3.1.99-prerelease | 113 | 11/5/2022 |
3.1.98-prerelease | 123 | 11/2/2022 |
3.1.97-prerelease | 122 | 11/2/2022 |
3.1.95-prerelease | 132 | 11/1/2022 |
3.1.83 | 385 | 10/22/2022 |
3.0.73 | 413 | 10/10/2022 |
3.0.71 | 406 | 10/10/2022 |
3.0.69 | 499 | 9/14/2022 |
3.0.59 | 436 | 8/18/2022 |
3.0.56 | 447 | 8/10/2022 |
3.0.49 | 445 | 6/27/2022 |
3.0.48 | 414 | 6/14/2022 |
3.0.44 | 499 | 3/19/2022 |
3.0.38 | 464 | 3/4/2022 |
3.0.37 | 844 | 11/21/2021 |
3.0.35 | 345 | 11/3/2021 |
3.0.34 | 372 | 10/24/2021 |
2.2.26 | 408 | 2/20/2021 |