static List <Employee> QueryOracle(DBConnectionWrapper conn, DBTransactionWrapper trans)
{
string sql = "select * from employees";
var ret = conn.Query <Employee>(sql, trans);
Console.WriteLine(ret.Count + " rows queried.");
return(ret);
}
static List <SalesOrderHeader> Query(DBConnectionWrapper conn, DBTransactionWrapper trans)
{
string sql = "SELECT [SalesOrderID],[RevisionNumber],[OrderDate],[DueDate],[ShipDate],[Status],[OnlineOrderFlag],[SalesOrderNumber],[PurchaseOrderNumber],[AccountNumber],[CustomerID],[SalesPersonID],[TerritoryID],[BillToAddressID],[ShipToAddressID],[ShipMethodID],[CreditCardID],[CreditCardApprovalCode],[CurrencyRateID],[SubTotal],[TaxAmt],[Freight],[TotalDue],[Comment],[rowguid],[ModifiedDate] FROM [Sales].[SalesOrderHeader]";
var ret = conn.Query <SalesOrderHeader>(sql, trans);
Console.WriteLine("Queried " + ret.Count + " records.");
return(ret);
}
