I have a code as detailed below which is used to insert a record in one table. However, I need the primary key of the added record and use it elsewhere.
_invoice.Datecreated = DateTime.Now;
_invoice.CustomerInvoiceStatus = CustomerInvoiceStatus.Confirmed;
_invoice.InvoiceTotal = selectedGatePassDespatch.TotalValue;
_invoice.InvoiceReceiptTotal = selectedGatePassDespatch.TotalValue;
_invoice.InvoiceBalance = selectedGatePassDespatch.TotalValue;
_invoice.VatRate = selectedVatRate.Percentage;
_invoice.Posted = true;
_invoice.CustomerContactRelationId = selectedGatePassDespatch.CustomerContact.ContactId;
_invoice.ChartAccountId = selectedStockItem.ChartAccountId;
InvoicebindingSource.EndEdit();
_invoiceService.Insert(_invoice);
So How do I get it Please.
Thanks.