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;
using (IDataReader reader = command.ExecuteReader())
var result = reader.ToEntity<TestObject>();
Console.WriteLine(result.IntColumn);
Console.WriteLine(result.StringColumn);
public int IntColumn { get; set; }
public string StringColumn { get; set; }