using System;

using System.Data;

using System.Data.SqlClient;

using System.Collections.Generic;

using System.Linq;

using Dapper;

public class Program

{

    public static void Main()

    {

        using(var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerNorthwind()))

        {

            var sql = "SELECT ProductName AS [Key], ProductName AS [Value] FROM Products";

            var result = conn.Query<KeyValuePair<string,string>>(sql)

                .ToDictionary(k => k.Key, v => v.Value);

​

            FiddleHelper.WriteTable(result);

​

        }

    }

}