Every data type, written and read back

Runs the sample. Generated for this page; it reads the connection string from the environment.

using ArxSamples.MSSQL;
using ArxSamples.MSSQL.Operations.Retrieve.RealCases;

// The connection string comes from the environment, never from the code (see "Configure the connection").
var connectionString = Environment.GetEnvironmentVariable("ARX_SAMPLES_SQLSERVER")
    ?? throw new InvalidOperationException("Set the ARX_SAMPLES_SQLSERVER environment variable to your SQL Server connection string.");

await new RealCase1_EveryDataTypeReadBack().RunAsync(new SampleContext(connectionString));

The sample, as it is in the repository.

using ARX.SDK.Models;
using ARX.SDK.Services;
using static ArxSamples.MSSQL.SampleOutput;

namespace ArxSamples.MSSQL.Operations.Retrieve.RealCases;

/// <summary>
/// What each SQL Server type reads back as, in one scenario: a row of data_type_showcase is written with
/// Create and read with Retrieve, and each attribute's .NET type is printed.
/// </summary>
public sealed class RealCase1_EveryDataTypeReadBack : ISample
{
    public string Name => "retrieve-real-1-every-data-type-read-back";

    public string Title => "Every data type, written and read back";

    public async Task RunAsync(SampleContext dbContext)
    {
        await Scenario1_WriteThenReadEveryTypeAsync(dbContext);
    }

    /// <summary>1. Write one value of each type, read the row, print each attribute's type and value.</summary>
    private static async Task Scenario1_WriteThenReadEveryTypeAsync(SampleContext dbContext)
    {
        Step("1. Written with Create, read with Retrieve");

        var row = new ArxEntity("data_type_showcase");
        row["text_value"] = "Read back R641";
        row["char_value"] = "AB";
        row["smallint_value"] = (short)7;
        row["int_value"] = 42;
        row["bigint_value"] = 9_000_000_000L;
        row["decimal_value"] = 12345.678901m;
        row["money_value"] = 19.99m;
        row["real_value"] = 1.5f;
        row["float_value"] = 2.25d;
        row["bit_value"] = true;
        row["uniqueidentifier_value"] = Guid.Parse("6c1b3a6e-7c2d-4c7e-9a51-2a9c6b0e1641");
        row["datetimeoffset_value"] = new DateTimeOffset(2026, 4, 1, 11, 30, 0, TimeSpan.FromHours(2));
        row["datetime2_value"] = new DateTime(2026, 4, 1, 9, 30, 0);
        row["date_value"] = new DateOnly(2026, 4, 1);
        row["time_value"] = new TimeOnly(9, 30);
        row["varbinary_value"] = new byte[] { 1, 2, 3 };
        row["json_value"] = new ArxJsonB { SerializedValue = "{\"tier\": \"gold\"}" };
        row["mood"] = new ArxSelectionSetValue("Mood", "happy");
        var id = await dbContext.Service.CreateAsync(row);

        var read = await dbContext.Service.RetrieveAsync("data_type_showcase", id) ?? throw new InvalidOperationException("The data_type_showcase record isn't there.");

        foreach (var column in new[] { "text_value", "char_value", "smallint_value", "int_value", "bigint_value", "decimal_value", "money_value", "real_value",
                     "float_value", "bit_value", "uniqueidentifier_value", "datetimeoffset_value", "datetime2_value", "date_value", "time_value",
                     "varbinary_value", "json_value", "mood" })
        {
            var value = read[column];
            var text = value switch
            {
                ArxJsonB json => json.SerializedValue,
                DateTime dateTime => $"{dateTime:yyyy-MM-dd HH:mm} ({dateTime.Kind})",
                DateTimeOffset offset => $"{offset:yyyy-MM-dd HH:mm zzz}",
                Array array => "[" + string.Join(", ", array.Cast<object>()) + "]",
                _ => value?.ToString()
            };

            Show($"{column,-18} {value?.GetType().Name,-10} {text}");
        }

        /* ===========================================================
         * [DIRECT QUERY CHECK]
         * -----------------------------------------------------------
         * SELECT char_value, date_value, time_value, datetimeoffset_value, json_value, mood
         * FROM data_type_showcase
         * WHERE text_value = 'Read back R641';
         * -- Expect: 1 row, "AB " (nchar(3) keeps its padding), 2026-04-01, 09:30:00.0000000, 2026-04-01 11:30:00.0000000 +02:00,
         * --         {"tier": "gold"}, happy.
         * ===========================================================
         */
    }
}

  > 1. Written with Create, read with Retrieve
      text_value         String     Read back R641
      char_value         String     AB 
      smallint_value     Int16      7
      int_value          Int32      42
      bigint_value       Int64      9000000000
      decimal_value      Decimal    12345.678901
      money_value        Decimal    19.9900
      real_value         Single     1.5
      float_value        Double     2.25
      bit_value          Boolean    True
      uniqueidentifier_value Guid       6c1b3a6e-7c2d-4c7e-9a51-2a9c6b0e1641
      datetimeoffset_value DateTimeOffset 2026-04-01 09:30 +00:00
      datetime2_value    DateTime   2026-04-01 09:30 (Unspecified)
      date_value         DateOnly   01/04/2026
      time_value         TimeOnly   9:30 am
      varbinary_value    Byte[]     [1, 2, 3]
      json_value         String     {"tier": "gold"}
      mood               String     happy