LINQ TO SQL. Get the id of the added post

Question

SQL

How can I get the id of the entry added to the table. I use LINQ TO SQL.

Adding an entry: Is it possible to do this without calling select on this entry?

DISC disc = new DISC();
disc.DISC_DATE = basecddate;
disc.CHART_TYPE = 3;
disc.DISC_NUMBER = week;
disc.DISC_TYPE = 1;
contex.DISC.InsertOnSubmit(disc);
contex.SubmitChanges();

Answer 1

As far as I remember just disc.id