using System.Collections.Generic;
using System.Data.SqlClient;
public static void Main()
string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn UNION SELECT 2, 'BuzzBuzz' WHERE @Fizz = 1";
var dict = new Dictionary<string, object> {{"@Fizz", 1}};
using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
List<dynamic> list = conn.ExecuteExpandoObjects(sql, dict.ToSqlParameters()).ToList();
Console.WriteLine(list[0].IntColumn);
Console.WriteLine(list[0].StringColumn);
Console.WriteLine(list[1].IntColumn);
Console.WriteLine(list[1].StringColumn);