How to insert a record with LINQ and C# and return the Primary Key of that record

Question

What's the best way to write a LINQ query that inserts a record and then returns the primary key of that newly inserted record using C# ?

Answer 1

The primary key value will be in that property after the SubmitChanges().

MyTable record = new MyTable();
record.Name = "James Curran";
db.MyTable.InsertOnSubmit(record);
db.SubmitChanges();
Console.WriteLine("record inserted as ID : {0}", record.Id);

Answer 2

Any field with AutoGeneratedValue=true will be filled in after that record is submitted to the database by dc.SubmitChanges()