using Dapper;

using System;

using Microsoft.Data.SqlClient;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Serialization;

​

var constr = FiddleHelper.GetConnectionStringSqlServer() + "TrustServerCertificate=True;";

constr.Dump();

using var con = new SqlConnection(constr);

var data = await con.QueryAsync<dynamic>("SELECT * FROM GENERATE_SERIES(1, 5)");

FiddleHelper.WriteTable(data);