Example #1
0
        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);
        }
Example #2
0
        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);
        }