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