public static void Delete(int id) { DemodataEntities db = new DemodataEntities(); Product p1 = db.Products.Find(id); db.Products.Remove(p1); db.SaveChanges(); Console.WriteLine("\nProduct Table after Delete"); var result = db.Products.ToList <Product>(); foreach (var r in result) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty); } }
public static void Update(int id, string name) { DemodataEntities db = new DemodataEntities(); Product product = db.Products.Find(id); product.Name = name; db.Entry(product).State = EntityState.Modified; db.SaveChanges(); Console.WriteLine("\nProduct Table after Update"); var result = db.Products.ToList <Product>(); foreach (var r in result) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty); } }
public static void Insert() { DemodataEntities db = new DemodataEntities(); Product product = new Product { Name = "Processor", Price = 27000, Qty = 5 }; db.Products.Add(product); db.SaveChanges(); Console.WriteLine("\nProduct Table after Insert"); var result = db.Products.ToList <Product>(); foreach (var r in result) { Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty); } }