using System.Data.SqlClient;
using System.Collections.Generic;
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<TestObject> list = conn.ExecuteEntities<TestObject>(sql, dict.ToDbParameters(conn)).ToList();
FiddleHelper.WriteTable(list);
public int IntColumnNotExists = -1;
public string StringColumnNotExists;
public string StringColumn { get; set; }