public ActionResult PriceUp() { var db = new FabricsEntities(); foreach (var item in db.Product) { item.Price += 1; } db.SaveChanges(); //db.Database.ExecuteSqlCommand("UPDATE dbo.Product SET Price=Price+1"); return(RedirectToAction("Top10")); }
public ActionResult PriceUp_Each(int?id) { var db = new FabricsEntities(); foreach (var item in db.Product) { if (null != id && id == item.ProductId) { item.Price += 1; } } db.SaveChanges(); return(RedirectToAction("Top10")); }