LINQ Compile Query

private static Func<TestDataContext, IEnumerable>

ParentRecords =

CompiledQuery.Compile<TestDataContext, IEnumerable>((TestDataContext db) =>

from m in db.Tablenames

select new { m.CategoryName, m.fk_CategoryId, m.Pk_CategoryId });

Get Identity value after Insert in LINQ C#

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

// Fiil the entity information
objCustomerSalesInformation .Name = "test";

// Submit Query
ObjDatatContext.GetTable().InsertOnSubmit(objCustomerSalesInformation );

// Submit Changes
ObjDatatContext.SubmitChanges();

// Get Inserted ID

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