using System.Data.Common;
using System.Data.SqlClient;
public static void Main()
const string sql = @"SELECT 1 As IntColumn";
using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
using (DbCommand command = conn.CreateCommand())
command.CommandText = sql;
using (IDataReader reader = command.ExecuteReader())
var result1 = reader.GetValueTo<int>("IntColumn");
var result2 = reader.GetValueToOrDefault<int>("UnknownColumn");
int result3 = reader.GetValueToOrDefault("UnknownColumn", -1);
int result4 = reader.GetValueToOrDefault("UnknownColumn", (dataReader, s) => -2);
Console.WriteLine(result1);
Console.WriteLine(result2);
Console.WriteLine(result3);
Console.WriteLine(result4);