using System.Collections.Generic;
using System.Data.Common;
using System.Data.SqlClient;
public static void Main()
string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn UNION SELECT 2, 'BuzzBuzz'";
using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
using (DbCommand command = conn.CreateCommand())
command.CommandText = sql;
List<dynamic> list = command.ExecuteExpandoObjects().ToList();
Console.WriteLine(list[0].IntColumn);
Console.WriteLine(list[0].StringColumn);
Console.WriteLine(list[1].IntColumn);
Console.WriteLine(list[1].StringColumn);