public List <SqlParameter> MapParamsForUpsert(InvoiceItemData entity) => new List <SqlParameter>
{
new SqlParameter("@invoice_item_key", entity.InvoiceItemKey),
new SqlParameter("@invoice_key", entity.InvoiceKey),
new SqlParameter("@invoice_item_seq", entity.InvoiceItemSeq),
new SqlParameter("@product_key", entity.ProductKey),
new SqlParameter("@product_name", entity.ProductName),
new SqlParameter("@product_desc", entity.ProductDesc),
new SqlParameter("@invoice_item_quantity", entity.InvoiceItemQuantity),
new SqlParameter("@shipto_addr_key", entity.ShiptoAddrKey),
new SqlParameter("@billto_addr_key", entity.BilltoAddrKey),
new SqlParameter("@invoice_item_entry_date", entity.InvoiceItemEntryDate),
new SqlParameter("@order_item_ship_date", entity.OrderItemShipDate),
new SqlParameter("@invoice_item_complete_date", entity.InvoiceItemCompleteDate),
new SqlParameter("@invoice_item_price_per", entity.InvoiceItemPricePer),
new SqlParameter("@invoice_item_line_sum", entity.InvoiceItemLineSum),
new SqlParameter("@invoice_item_account_rep_key", entity.InvoiceItemAccountRepKey),
new SqlParameter("@invoice_item_sales_rep_key", entity.InvoiceItemSalesRepKey),
new SqlParameter("@invoice_item_status_key", entity.InvoiceItemStatusKey),
new SqlParameter("@order_item_key", entity.OrderItemKey),
GetOutParam()
};
public List <SqlParameter> MapParamsForDelete(InvoiceItemData entity) => MapParamsForDelete(entity.InvoiceItemKey);