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)); }