Wednesday, March 31, 2010

Get Identity value after Insert in LINQ C#

// Create object of entity
CustomerSalesInformation obj
CustomerSalesInformation = new CustomerSalesInformation();

// Fiil the entity information
obj
CustomerSalesInformation .Name = "test";

// Submit Query
ObjDatatContext.GetTable().InsertOnSubmit(obj
CustomerSalesInformation );

// Submit Changes
ObjDatatContext.SubmitChanges();

// Get Inserted ID

obj
CustomerSalesInformation .Id // Id is primary key column of CustomerSalesInformation Table

1 comment: