Where it doesn’t work when listing all records - Entity Framework

Question

I need to return all records containing the branch informed using the clause where, only that the Entity Framework is returning all records ignoring what is in the where. Where am I going wrong?

public IQueryable<PessoaGenerico> GetAllPessoaGenericoByFilial(int id)
{
  return DbSet
   .Where(pg => pg.PessoaFilialId == id)
   .AsQueryable()
   .AsNoTracking();
}

In the example, I’m searching all the records where PessoaFilialId is equal to 31. He should not find and return null, but it’s bringing all.

Answer 1

Missed the ToList(). It turns out that the IQueryable it just creates the query, it will actually run when you "indicate" it with the ToList() or a FirstOrDefault(), for example.

To check for value, you can use the method Any(), that will return true if it has value, example:

if (suaLista.Any()) {
    //Possui valor
}

Reading suggestion: What is the difference between Ienumerable, Iqueryable and List?

_{Maybe someone else can explain it better and in more detail, but in short that’s it.}