public IQueryable <Category> GetCategories() { var db = new TBForumPage.Models.ThreadContext(); IQueryable <Category> query = db.Categories; return(query); }
public IQueryable <Thread> GetThreads([QueryString("id")] int?categoryID) { var _db = new TBForumPage.Models.ThreadContext(); IQueryable <Thread> query = _db.Threads; if (categoryID.HasValue && categoryID > 0) { query = query.Where(p => p.CategoryID == categoryID); } return(query); }