CA.Blocks.SQLServerDataAccess 3.1.124

• Homepage
• Documentation
• NuGet Package SQL Server
• NuGet Package My SQL
• NuGet Package SQlite

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