public void CreateWithoutGetOrdinal()
{
Action <SqlDataReader> mapSalesOrderHeader = sqlDataReader =>
{
// ReSharper disable RedundantArgumentName
var temp = new SalesOrderHeader(
salesOrderID: sqlDataReader.GetInt32(0),
revisionNumber: sqlDataReader.GetInt16(1),
orderDate: sqlDataReader.GetDateTime(2),
dueDate: sqlDataReader.GetDateTime(3),
shipDate: sqlDataReader.GetDateTime(4),
status: sqlDataReader.GetInt16(5),
onlineOrderFlag: sqlDataReader.GetBoolean(6),
salesOrderNumber: sqlDataReader.GetString(7),
purchaseOrderNumber: sqlDataReader.GetString(8),
accountNumber: sqlDataReader.GetString(9),
customerID: sqlDataReader.GetInt32(10),
salesPersonID: sqlDataReader.GetInt32(11),
territoryID: sqlDataReader.GetInt32(12),
billToAddressID: sqlDataReader.GetInt32(13),
shipToAddressID: sqlDataReader.GetInt32(14),
shipMethodID: sqlDataReader.GetInt32(15),
creditCardID: sqlDataReader.GetInt32(16),
creditCardApprovalCode: sqlDataReader.GetString(17),
currencyRateID: sqlDataReader.GetInt32(18),
subTotal: sqlDataReader.GetDecimal(19),
taxAmt: sqlDataReader.GetDecimal(20),
freight: sqlDataReader.GetDecimal(21),
totalDue: sqlDataReader.GetDecimal(22),
comment: sqlDataReader.GetString(23),
rowguid: sqlDataReader.GetGuid(24),
modifiedDate: sqlDataReader.GetDateTime(25));
// ReSharper restore RedundantArgumentName
};
this.InvokeQuery(mapSalesOrderHeader);
}
public void CreateWithGetOrdinal()
{
Action<SqlDataReader> mapSalesOrderHeader = sqlDataReader =>
{
int salesOrderID = sqlDataReader.GetOrdinal("SalesOrderID");
int revisionNumber = sqlDataReader.GetOrdinal("RevisionNumber");
int orderDate = sqlDataReader.GetOrdinal("OrderDate");
int dueDate = sqlDataReader.GetOrdinal("DueDate");
int shipDate = sqlDataReader.GetOrdinal("ShipDate");
int status = sqlDataReader.GetOrdinal("Status");
int onlineOrderFlag = sqlDataReader.GetOrdinal("OnlineOrderFlag");
int salesOrderNumber = sqlDataReader.GetOrdinal("SalesOrderNumber");
int purchaseOrderNumber = sqlDataReader.GetOrdinal("PurchaseOrderNumber");
int accountNumber = sqlDataReader.GetOrdinal("AccountNumber");
int customerID = sqlDataReader.GetOrdinal("CustomerID");
int salesPersonID = sqlDataReader.GetOrdinal("SalesPersonID");
int territoryID = sqlDataReader.GetOrdinal("TerritoryID");
int billToAddressID = sqlDataReader.GetOrdinal("BillToAddressID");
int shipToAddressID = sqlDataReader.GetOrdinal("ShipToAddressID");
int shipMethodID = sqlDataReader.GetOrdinal("ShipMethodID");
int creditCardID = sqlDataReader.GetOrdinal("CreditCardID");
int creditCardApprovalCode = sqlDataReader.GetOrdinal("CreditCardApprovalCode");
int currencyRateID = sqlDataReader.GetOrdinal("CurrencyRateID");
int subTotal = sqlDataReader.GetOrdinal("SubTotal");
int taxAmt = sqlDataReader.GetOrdinal("TaxAmt");
int freight = sqlDataReader.GetOrdinal("Freight");
int totalDue = sqlDataReader.GetOrdinal("TotalDue");
int comment = sqlDataReader.GetOrdinal("Comment");
int rowguid = sqlDataReader.GetOrdinal("rowguid");
int modifiedDate = sqlDataReader.GetOrdinal("ModifiedDate");
// ReSharper disable RedundantArgumentName
var temp = new SalesOrderHeader(
salesOrderID: sqlDataReader.GetInt32(salesOrderID),
revisionNumber: sqlDataReader.GetInt16(revisionNumber),
orderDate: sqlDataReader.GetDateTime(orderDate),
dueDate: sqlDataReader.GetDateTime(dueDate),
shipDate: sqlDataReader.GetDateTime(shipDate),
status: sqlDataReader.GetInt16(status),
onlineOrderFlag: sqlDataReader.GetBoolean(onlineOrderFlag),
salesOrderNumber: sqlDataReader.GetString(salesOrderNumber),
purchaseOrderNumber: sqlDataReader.GetString(purchaseOrderNumber),
accountNumber: sqlDataReader.GetString(accountNumber),
customerID: sqlDataReader.GetInt32(customerID),
salesPersonID: sqlDataReader.GetInt32(salesPersonID),
territoryID: sqlDataReader.GetInt32(territoryID),
billToAddressID: sqlDataReader.GetInt32(billToAddressID),
shipToAddressID: sqlDataReader.GetInt32(shipToAddressID),
shipMethodID: sqlDataReader.GetInt32(shipMethodID),
creditCardID: sqlDataReader.GetInt32(creditCardID),
creditCardApprovalCode: sqlDataReader.GetString(creditCardApprovalCode),
currencyRateID: sqlDataReader.GetInt32(currencyRateID),
subTotal: sqlDataReader.GetDecimal(subTotal),
taxAmt: sqlDataReader.GetDecimal(taxAmt),
freight: sqlDataReader.GetDecimal(freight),
totalDue: sqlDataReader.GetDecimal(totalDue),
comment: sqlDataReader.GetString(comment),
rowguid: sqlDataReader.GetGuid(rowguid),
modifiedDate: sqlDataReader.GetDateTime(modifiedDate)
);
// ReSharper restore RedundantArgumentName
};
this.InvokeQuery(mapSalesOrderHeader);
}
public void CreateWithoutGetOrdinal()
{
Action<SqlDataReader> mapSalesOrderHeader = sqlDataReader =>
{
// ReSharper disable RedundantArgumentName
var temp = new SalesOrderHeader(
salesOrderID: sqlDataReader.GetInt32(0),
revisionNumber: sqlDataReader.GetInt16(1),
orderDate: sqlDataReader.GetDateTime(2),
dueDate: sqlDataReader.GetDateTime(3),
shipDate: sqlDataReader.GetDateTime(4),
status: sqlDataReader.GetInt16(5),
onlineOrderFlag: sqlDataReader.GetBoolean(6),
salesOrderNumber: sqlDataReader.GetString(7),
purchaseOrderNumber: sqlDataReader.GetString(8),
accountNumber: sqlDataReader.GetString(9),
customerID: sqlDataReader.GetInt32(10),
salesPersonID: sqlDataReader.GetInt32(11),
territoryID: sqlDataReader.GetInt32(12),
billToAddressID: sqlDataReader.GetInt32(13),
shipToAddressID: sqlDataReader.GetInt32(14),
shipMethodID: sqlDataReader.GetInt32(15),
creditCardID: sqlDataReader.GetInt32(16),
creditCardApprovalCode: sqlDataReader.GetString(17),
currencyRateID: sqlDataReader.GetInt32(18),
subTotal: sqlDataReader.GetDecimal(19),
taxAmt: sqlDataReader.GetDecimal(20),
freight: sqlDataReader.GetDecimal(21),
totalDue: sqlDataReader.GetDecimal(22),
comment: sqlDataReader.GetString(23),
rowguid: sqlDataReader.GetGuid(24),
modifiedDate: sqlDataReader.GetDateTime(25));
// ReSharper restore RedundantArgumentName
};
this.InvokeQuery(mapSalesOrderHeader);
}
public void CreateWithGetOrdinal()
{
Action <SqlDataReader> mapSalesOrderHeader = sqlDataReader =>
{
int salesOrderID = sqlDataReader.GetOrdinal("SalesOrderID");
int revisionNumber = sqlDataReader.GetOrdinal("RevisionNumber");
int orderDate = sqlDataReader.GetOrdinal("OrderDate");
int dueDate = sqlDataReader.GetOrdinal("DueDate");
int shipDate = sqlDataReader.GetOrdinal("ShipDate");
int status = sqlDataReader.GetOrdinal("Status");
int onlineOrderFlag = sqlDataReader.GetOrdinal("OnlineOrderFlag");
int salesOrderNumber = sqlDataReader.GetOrdinal("SalesOrderNumber");
int purchaseOrderNumber = sqlDataReader.GetOrdinal("PurchaseOrderNumber");
int accountNumber = sqlDataReader.GetOrdinal("AccountNumber");
int customerID = sqlDataReader.GetOrdinal("CustomerID");
int salesPersonID = sqlDataReader.GetOrdinal("SalesPersonID");
int territoryID = sqlDataReader.GetOrdinal("TerritoryID");
int billToAddressID = sqlDataReader.GetOrdinal("BillToAddressID");
int shipToAddressID = sqlDataReader.GetOrdinal("ShipToAddressID");
int shipMethodID = sqlDataReader.GetOrdinal("ShipMethodID");
int creditCardID = sqlDataReader.GetOrdinal("CreditCardID");
int creditCardApprovalCode = sqlDataReader.GetOrdinal("CreditCardApprovalCode");
int currencyRateID = sqlDataReader.GetOrdinal("CurrencyRateID");
int subTotal = sqlDataReader.GetOrdinal("SubTotal");
int taxAmt = sqlDataReader.GetOrdinal("TaxAmt");
int freight = sqlDataReader.GetOrdinal("Freight");
int totalDue = sqlDataReader.GetOrdinal("TotalDue");
int comment = sqlDataReader.GetOrdinal("Comment");
int rowguid = sqlDataReader.GetOrdinal("rowguid");
int modifiedDate = sqlDataReader.GetOrdinal("ModifiedDate");
// ReSharper disable RedundantArgumentName
var temp = new SalesOrderHeader(
salesOrderID: sqlDataReader.GetInt32(salesOrderID),
revisionNumber: sqlDataReader.GetInt16(revisionNumber),
orderDate: sqlDataReader.GetDateTime(orderDate),
dueDate: sqlDataReader.GetDateTime(dueDate),
shipDate: sqlDataReader.GetDateTime(shipDate),
status: sqlDataReader.GetInt16(status),
onlineOrderFlag: sqlDataReader.GetBoolean(onlineOrderFlag),
salesOrderNumber: sqlDataReader.GetString(salesOrderNumber),
purchaseOrderNumber: sqlDataReader.GetString(purchaseOrderNumber),
accountNumber: sqlDataReader.GetString(accountNumber),
customerID: sqlDataReader.GetInt32(customerID),
salesPersonID: sqlDataReader.GetInt32(salesPersonID),
territoryID: sqlDataReader.GetInt32(territoryID),
billToAddressID: sqlDataReader.GetInt32(billToAddressID),
shipToAddressID: sqlDataReader.GetInt32(shipToAddressID),
shipMethodID: sqlDataReader.GetInt32(shipMethodID),
creditCardID: sqlDataReader.GetInt32(creditCardID),
creditCardApprovalCode: sqlDataReader.GetString(creditCardApprovalCode),
currencyRateID: sqlDataReader.GetInt32(currencyRateID),
subTotal: sqlDataReader.GetDecimal(subTotal),
taxAmt: sqlDataReader.GetDecimal(taxAmt),
freight: sqlDataReader.GetDecimal(freight),
totalDue: sqlDataReader.GetDecimal(totalDue),
comment: sqlDataReader.GetString(comment),
rowguid: sqlDataReader.GetGuid(rowguid),
modifiedDate: sqlDataReader.GetDateTime(modifiedDate)
);
// ReSharper restore RedundantArgumentName
};
this.InvokeQuery(mapSalesOrderHeader);
}
