Consult in several fields of the record in a single query

Question

I am developing an item list filter, and would like to filter by any term of the item record. I’ve seen this work in Angular, but I’m developing for ASP.NET MVC 5 and using the Entity Framework + Linq for queries.

Someone’s been through it?

Code I’m using to meet demand:

List<Chamado> chamados = (from e in db.Chamado where e.StatusChamado != true select e).ToList();
        if(filtro != null)
        {
            chamados = chamados.Where(s => s.Id.ToString().Contains(filtro)
                                                       || s.Assunto.Contains(filtro)
                                                       || s.Descricao.Contains(filtro)
                                                       || s.ObraDestino.Descricao.Contains(filtro)
                                                       || s.ResponsavelChamado.Nome.Contains(filtro)).ToList();
        }
        return chamados;

Answer 1

It’s correct your approach, but I’d do it differently:

    var chamadosQuery = db.Chamado.Where(!e.StatusChamado);

    if(filtro != null)
    {
        chamadosQuery = chamadosQuery.Where(s => s.Id.ToString().Contains(filtro)
                                                   || s.Assunto.Contains(filtro)
                                                   || s.Descricao.Contains(filtro)
                                                   || s.ObraDestino.Descricao.Contains(filtro)
                                                   || s.ResponsavelChamado.Nome.Contains(filtro));
    }

    return chamados.ToList();