Linq to sql -error when inserting at 2 resolves the parent child relation

Question

I have order details and order details with OrderID as a foreign key in the order data table. OrderID is the identifier column for Order and is set as auto-generation.

When I do the insert as follows (hardcoded values ​​for simplicity):

LINQ1DataContext db = new LINQ1DataContext();

Order order = new Order();
order.OrdersCustomerID = 1;
order.OrdersDate = time;
db.Orders.InsertOnSubmit(order);

OrdersDetail oDetail = new OrdersDetail();
oDetail.OrdersDetailID = order.OrdersID;
oDetail.OrdersDetailProdID = 1;
oDetail.OrdersDetailQty = 6;
oDetail.OrdersDetailUnitPrice = 2.58m;
db.OrdersDetail.InsertOnSubmit(oDetail); 

db.SubmitChanges();

This results in a "FOREIGN KEY error conflict". I found this because orderID is not created in InsertOnSubmit (order). When the SubmitChanges () function is executed, the OrdersDetailID does not match the OrdersID and receives an error. OrderID will only be generated after "underitchanges ()".

db.SubmitChanges(); db.Orders.InsertOnSubmit(order), orderid , , orderDetails .

: submitChanges insertOnSubmit 2 (parent-child), ?

, insertOnSubmit , , LINQ to SQL SubmitChanges.

,

Answer 1

order.OrdersDetail.Add(oDetail);

db.OrdersDetail.InsertOnSubmit(oDetail);  

, , db.SubmitChanges(). , .

Answer 2

LINQ1DataContext db = new LINQ1DataContext();

Order order = new Order();
order.OrdersCustomerID = 1;
order.OrdersDate = time;
db.Orders.InsertOnSubmit(order);

> db.SubmitChanges();

OrdersDetail oDetail = new OrdersDetail();
oDetail.OrdersDetailID = order.OrdersID;
oDetail.OrdersDetailProdID = 1;
oDetail.OrdersDetailQty = 6;
oDetail.OrdersDetailUnitPrice = 2.58m;
db.OrdersDetail.InsertOnSubmit(oDetail); 

db.SubmitChanges();