public ActionResult Index() { var db = new FabricsEntities(); var result = db.Product.Where(p => p.ProductId > 1500).ToList(); return View(result); }
public ActionResult Update5() { var db = new FabricsEntities(); var data = db.Client.Take(5); foreach (var c in data) { c.City = "Taipei"; } db.SaveChanges(); return View(data); }
public ActionResult RemoveClient() { var db = new FabricsEntities(); var data = db.Client.Take(5); foreach (var client in data) { foreach (var order in client.Order) { db.OrderLine.RemoveRange(order.OrderLine); } db.Order.RemoveRange(client.Order); } db.Client.RemoveRange(data); db.SaveChanges(); return View(data); }
// GET: EF public int AddProduct() { using (var db = new FabricsEntities()) { Product product = new Product(); product = new Product() { ProductName = "Tee white", Active = true, Stock = 10, Price = 299 }; db.Product.Add(product); db.SaveChanges(); return product.ProductId; } }