public IQueryable <Category> GetCategories() { var _db = new WebApplication3.Models.ProductContext(); IQueryable <Category> query = _db.Categories; return(query); }
//so now we're going to populate it public IQueryable <Product> GetProducts([QueryString("id")] int?categoryId) { var _db = new WebApplication3.Models.ProductContext(); IQueryable <Product> query = _db.Products; if (categoryId.HasValue && categoryId > 0) { query = query.Where(p => p.CategoryID == categoryId); } return(query); }
public IQueryable <Product> GetProduct([QueryString("productID")] int?productId) { var _db = new WebApplication3.Models.ProductContext(); IQueryable <Product> query = _db.Products; if (productId.HasValue && productId > 0) { query = query.Where(p => p.ProductID == productId); } else { query = null; } return(query); }