create a crud funcions for manage sql table Order
public void CreateOrder(Order order) { using (var db= new MyDbContext()) { db.Orders.Add(order); db.SaveChanges(); } } public Order GetOrder(int id) { using (var db = new MyDbContext()) { return db.Orders.Get(id); } } public void UpdateOrder(Order order) { using (var db = new MyDbContext()) { var orderToUpdate = GetOrder(order.Id); orderToUpdate.Name = order.Name; db.SaveChanges(); } } public void DeleteOrder(Order order) { using (var db = new MyDbContext()) { var orderToDelete = GetOrder(order.Id); db.Orders.Delete(orderToDelete); db.SaveChanges(); } }