// @nuget: Norm.net -Version 3.1.0

// @nuget: System.Data.SqlClient -Version 4.8.2

using System;

using System.Linq;

using System.Data.SqlClient;

using Norm;

​

public class Program

{

    public static void Main()

    {

        using var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools());

        var dict = connection.Read<(int Id, string Name)>("SELECT ProductID, ProductName FROM Products").ToDictionary(t => t.Id, t => t.Name);

        foreach(var (key, value) in dict)

        {

            Console.WriteLine($"{key} {value.Trim()}");

        }

    }

}

​