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); }