//busca trabalhos por palavra chave public List <Trabalho> GetTrabalho(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord) { using (BPL_ProjectContext db = new BPL_ProjectContext()) { var v = (from a in db.Trabalhoes.Include(x => x.Professor) where a.Prof_Curso.ToUpper().Contains(search.ToUpper()) || a.Prof_Nome.ToUpper().Contains(search.ToUpper()) || a.Assunto.ToUpper().Contains(search.ToUpper()) || a.Problema.ToUpper().Contains(search.ToUpper()) || a.Professor.Nome.ToUpper().Contains(search.ToUpper()) || a.Status.ToUpper().Contains(search.ToUpper()) select a ); totalRecord = v.Count(); return(v.ToList()); } }