public static void UpdateCategory(Product[] products, Category newCategory) { using (DbNorthwind db = new DbNorthwind()) { foreach (Product prod in products) { prod.Category = newCategory; db.Update(prod); } } }
public static void ReplaceByProduct(Product newProduct) { using (DbNorthwind db = new DbNorthwind()) { var prod = from p in db.Product where p.ProductID == newProduct.ProductID select p; if (prod.Count() == 0) newProduct.ProductID = Convert.ToInt32(db.InsertWithIdentity(newProduct)); var q = (from o in db.Order where o.ShippedDate == null select o).ToList(); foreach (Order order in q) { OrderDetail orderDetail = (from od in db.OrderDetail where od.Order.OrderID == order.OrderID select od).First(); orderDetail.Product = newProduct; db.Update(orderDetail); } } }