// @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, string>("SELECT TOP 10 ProductID, ProductName FROM Products").ToDictionary(t => t.Item1, t => t.Item2);

        foreach(var (key, value) in dict)

        {

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

        }

    }

}

​