static List <string> GetFirstColumn(DBConnectionWrapper conn, DBTransactionWrapper trans) { string sql = "SELECT first_name FROM employees"; var ret = conn.GetFirstColumn <string>(sql, trans); Console.WriteLine("Queried " + ret.Count + " lines of first column."); return(ret); }
static List <int> GetFirstColumn(DBConnectionWrapper conn, DBTransactionWrapper trans = null) { string sql = "SELECT SalesOrderID FROM [Sales].[SalesOrderHeader]"; var ret = conn.GetFirstColumn <int>(sql, trans); Console.WriteLine("Queried " + ret.Count + " lines of first column."); return(ret); }