public static List <Category> ListCat() { using (myDB entities = new myDB()) { return(entities.Categories.ToList <Category>()); } }
public IQueryable <Book> GetProduct([QueryString("book_id")] int?book_id) { var _db = new myDB(); IQueryable <Book> query = _db.Books; if (book_id.HasValue && book_id > 0) { query = query.Where(p => p.BookID == book_id); } else { query = null; } return(query); }