How to call Linq method in View?

Question

Good morning, everyone. my question is this, I have the following method in my model:

public IQueryable GetConsulta()
{
    var q = (from c in Datacontext.Tabela1
                join b in Datacontext.Tabela2 on c.CodClase equals b.CodClase
                join d in Datacontext.Tabela3 on b.CodImobilizado equals d.CodImobilizado
                where c.CodClase == b.CodClase && b.CodImobilizado == d.CodImobilizado
                select new
                {
                    taxa = c.Taxa,
                    ano = DateTime.Parse(b.Data).Year,
                    data = d.Data,
                    valorAquisicao = b.Valor,

                });

    return q;
}

In View it’s like this:

void getConsulta(){
    var a = model.GetConsulta();    
    foreach(var linha in a){
      //faça algo
    }
}

The problem is that I cannot access the variables created in the model method in the View foreach.

Could someone help me.

Answer 1

The problem is in the type of return you are using, in this approach, you do not specify which return of Iqueryable, consequently in the view, you will not be able to view the desired data.

A suggestion would be to type your return with a model class:

class Modelo {
    public string taxa { get; set; }
    public int ano { get; set; }
    public DateTime data { get; set; }
    public decimal valorAquisicao { get; set; }
}

public IQueryable<Modelo> GetConsulta()
{
    var q = (from c in Datacontext.Tabela1
                join b in Datacontext.Tabela2 on c.CodClase equals b.CodClase
                join d in Datacontext.Tabela3 on b.CodImobilizado equals d.CodImobilizado
                where c.CodClase == b.CodClase && b.CodImobilizado == d.CodImobilizado
                select new Modelo()
                {
                    taxa = c.Taxa,
                    ano = DateTime.Parse(b.Data).Year,
                    data = d.Data,
                    valorAquisicao = b.Valor,

                });

    return q;
}

In View it would look like this:

void getConsulta(){
    var a = model.GetConsulta();    
    foreach(Modelo linha in a){
      //faça algo
    }
}