Hello Everyone, I am going to share the code
sample to get the last Inserted row id
using Linq to SQL as given below.
//The Asp.Net code sample to get Last Inserted row Id in Linq to SQL. i.e.
private long AddAccountAddress(AccountAddress
accountAddress, long AccountID, long AddressID)
{
accountAddress.AddressID = AddressID;
accountAddress.AccountID = AccountID;
accountAddress.CreatedBy = 0;
accountAddress.CreatedDate = DateTime.Now;
accountAddress.IsActive = true;
accountAddress.IsDeleted = false;
base.Context.AccountAddresses.Add(accountAddress);
_entities.SaveChanges()
//The Last Inserted AccountAddressID is from
accountAddresses object.
long AccountAddressID =
accountAddress.AccountAddressID;
return AccountAddressID;
}
Thank you!