public Order CreateOrder(Order order) { var dc = new DataClassesDataContext(_connectionString); if (order.Shipper != null) { dc.Shippers.Attach(order.Shipper, false); } if (order.Customer != null) { dc.Customers.Attach(order.Customer, false); } if (order.Employee != null) { dc.Employees.Attach(order.Employee, false); } dc.Orders.InsertOnSubmit(order); dc.SubmitChanges(); return order; }
partial void DeleteOrder(Order instance);
partial void UpdateOrder(Order instance);
partial void InsertOrder(Order instance);
public Order UpdateOrder(Order order) { var dc = new DataClassesDataContext(_connectionString); dc.Orders.Attach(order, ReadOrder(order.OrderID)); dc.SubmitChanges(); return order; }
public void DeleteOrder(Order order) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Order> s = from e in dc.Orders where e.OrderID == order.OrderID select e; dc.Orders.DeleteOnSubmit(s.First()); dc.SubmitChanges(); }