Advertisement
Guest User

msdn LINQ2SQL add with relation between table

a guest
Jul 22nd, 2014
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.93 KB | None | 0 0
  1. Northwind db1 = new Northwind();
  2. // Assume Customer c1 and related Orders o1, o2 are retrieved
  3.  
  4. // Back on the mid-tier, a new context needs to be used
  5. Northwind db2 = new Northwind();
  6.  
  7. // Create new entities for applying changes
  8. Customer c2 = new Customer();
  9. c2.CustomerID = c.CustomerID;
  10. Order o2 = new Order();
  11. o2.OrderID = ...;
  12.  
  13. c2.Orders.Add(o2);
  14.  
  15. // Add other related objects needed for updates
  16.  
  17. // Set properties needed for optimistic concurrency check
  18. ...
  19. // Order o1 to be deleted
  20. Order o1 = new Order();
  21. o1.OrderID = ...;
  22.  
  23. // Tell LINQ to SQL to track the graph transitively
  24. db2.Customers.Attach(c2);
  25. // Now "replay" all the changes
  26.  
  27. // Updates
  28. c2.ContactName = ...;
  29. o2.ShipAddress = ...;
  30.  
  31. // New object for insertion
  32. Order o3 = new Order();
  33. o3.OrderID = ...;
  34. c2.Orders.Add(o3);
  35.  
  36. // Remove order o1
  37. db2.Orders.Remove(o1);
  38.  
  39. // DataContext now knows how to do update/insert/delete
  40. db2.SubmitChanges();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement