Getting an Identity of the most recent added record

Question

Hi All,

 

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.

 

Peter.