public static void DisplayProducts() { using (context context = new context()) { var Productss = context.Product; foreach (var item in Productss) { Console.WriteLine(item.ProductId + "\t" + item.Product); } } }
public static void Displaycustomers() { using (context context = new context()) { var customers = context.CustomerDetails; foreach (var item in customers) { Console.WriteLine(item.Sno + "\t" + item.CustomerName + "\t" + item.PhoneNumber + "\t" + item.ProductId); } } }
public static void insert(string product) { using (context con = new context()) { products pro = new products() { Product = product }; con.Product.Add(pro); con.SaveChanges(); } }
public static void updateproducts(int id, string name) { using (context con = new context()) { var update = con.Product.Where(s => s.ProductId == id).FirstOrDefault(); if (update != null) { update.Product = name; con.Entry(update).State = Microsoft.EntityFrameworkCore.EntityState.Modified; con.SaveChanges(); } } }