Object Type Declaration Doubt - Entity Framework

Question

I need help in defining the correct class statement

Follows my code:

public void BuscaOcorremcias()
{
    //Op 01 - Declarando um IList da Model
    IList<Ocorrencia> ocorrencias = null;
    //Op 02 - Declarando um DbSet
    System.Data.Entity.DbSet<MoradaWeb.Models.Ocorrencia> ocorrencias = null;

    ocorrencias = db.Ocorrencia.Include("Pessoa").Where(c => c.status == true);

    if (MinhaRegradeNegocio)
        ocorrencias = ocorrencias.Where(c => c.Pessoa == PessoaLogada);
}

//My Context

public class MeuContext : DbContext
{
    public MoradaWebContext() : base("name=MinhaConnectionString")
    {   ...   }

    public System.Data.Entity.DbSet<Models.Ocorrencia> Ocorrencia { get; set; }
}

The error that occurs with the above two options (in the code comment) is this:

Cannot implicititly Convert type...

I’m not sure what kind to declare so I can maintain the condition of applying an extra Where if I have to. In this case I want to make the second Where inside the collection itself that has already been searched in the bank.

Answer 1

IS IQueryable what you need.

If you are selecting only the DbSet (db.Ocorrencia, in the example) it is also necessary to call the method AsQueryable because his type is just DbSet. From the first Include, Where or related the type returned becomes a IQueryable.

You can see more details, in this question of mine.

IQueryable<Ocorrencia> ocorrencias = db.Ocorrencia.Include("Pessoa")
                                       .Where(c => c.status == true);

if (MinhaRegradeNegocio)
    ocorrencias = ocorrencias.Where(c => c.Pessoa == PessoaLogada);

It is also possible to use var and let the type be set automatically.