public void Dispose()
{
if (_db != null)
{
_db.Dispose();
_db = null;
}
}
public IQueryable<Products> GetProducts([QueryString("id")] int? categoryId)
{
var _db = new ProductContext();
IQueryable<Products> query=_db.Products;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(p => p.CategoryID == categoryId);
}
return query;
}
public IQueryable<Category> GetCategories()
{
var _db = new ProductContext();
IQueryable<Category> query = _db.Categories;
return query;
}
