public IQueryable <Category> GetCategories()
        {
            var _db = new MyFirstWebForm.Models.ProductContext();
            IQueryable <Category> query = _db.Categories;

            return(query);
        }
        public IQueryable <Product> GetProducts([QueryString("id")] int?categoryId)
        {
            var _db = new MyFirstWebForm.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 MyFirstWebForm.Models.ProductContext();
            IQueryable <Product> query = _db.Products;

            if (productId.HasValue && productId > 0)
            {
                query = query.Where(p => p.ProductID == productId);
            }
            else
            {
                query = null;
            }
            return(query);
        }