public List <Category> GetCategories()
{
using (var context = new NorthwindSlimEntities())
{
var categories = context.Categories.OrderBy(a => a.CategoryId).ToList();
return(categories);
}
}
public List <Product> GetProductsByCategory(int categoryId)
{
using (var context = new NorthwindSlimEntities())
{
var products = context.Products.Where(a => a.CategoryId == categoryId).OrderBy(a => a.ProductName).ToList();
return(products);
}
}