public int NumberOfProducts()
 {
     using var ctx = new NorthwindContext();
     return(ctx.Products.Count());
 }
 public Category GetCategory(int id)
 {
     using var ctx = new NorthwindContext();
     return(ctx.Categories.Find(id));
 }
 public Product GetProduct(int id)
 {
     using var ctx = new NorthwindContext();
     return(ctx.Products.Include(x => x.Category).FirstOrDefault(x => x.Id == id));
 }