linq to sql obtain primary keey value

In a C# 2010 application that I am working on, I want to use linq to sql to update 2 tables in a sql server 2008 database.

I want to do the following:
create new Table1 object ;
InsertOnSubmit(tbl1)
**Table 1 will contain the primary key.
create new Table2 object;
table2 will contain a foreign key column that refers to primary key in
table1 object.
InsertOnSubmit(tbl2)
SubmitChanges()

Before and/or right after the submitchanges() event occurs, I would like to know what the value is for the primary key in table1 and the foreign key value is in table2. I would like to know what the table key value is so I can display this information on reports that will be generated right after the record(s) have been inserted into the database. Thus can you tell me how to determine what the primary key value is for table1 that also refers to the foreign key value in table 2?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

pradeep kumar14y ago
Accepted answer
In this case I think Your primary key will be same as that of second table foreign key.
Eg: tb_1 int primary key,
then tb_2 int
this both will have relation right.?
then you can use transaction scope.!!

using(transaction scope ts=new transaction scope){
using(dbcontext model =new dbcontext())
{

model.InsertOnsubmit(obj_name);
model.submitchanges();

}

write your update query here...////
{
and map the values here...///

}

}
ts.complete(); ///This is very important you have to close the transaction scope.