ADO.NET Supported Types and Their Mappings

The following lists the built-in mappings for reading and writing CLR types to YDB types.

Type Mapping Table for Reading

The following shows the mappings used when reading values.

These are the return types when using YdbCommand.ExecuteScalarAsync(), YdbDataReader.GetValue(), and similar methods.

Decimal

Decimal (Precision, Scale) is a parameterized data type in YDB that allows you to explicitly specify:

• Precision — the total number of significant digits;
• Scale — the number of digits after the decimal point.

For more details, see the documentation.

By default, the Decimal(22, 9) type is used. If you need to set different values for Precision and Scale, you can do this in your code.

The example below demonstrates how to store the value 1.5 in the database with the Decimal type and parameters Precision = 5 and Scale = 3.

await new YdbCommand(ydbConnection)
{
    CommandText = $"INSERT INTO {tableName}(Id, Decimal) VALUES (1, @Decimal);",
    Parameters = new YdbParameter { Name = "Decimal", Value = 1.5m, Precision = 5, Scale = 3 }
}.ExecuteNonQueryAsync();

Type Mapping Table for Writing

You can also specify any YDB type using the constructors from Ydb.Sdk.Value.YdbValue. For example:

var parameter = new YdbParameter("$parameter", YdbValue.MakeJsonDocument("{\"type\": \"jsondoc\"}"));