Group by with Lillo

Question

I have the following tables:

**Aula**
Id
Nome
Data

**Avaliacao**
Aula_Id
Aluno_Id
Organizacao
Didatica

To get a Join of the tables I use the code:

var result = from a in mdc.SBE_AA_Aulas
             join av in mdc.SBE_AA_AvaliacaoAlunos on a.id equals av.SBE_AA_Aula_id

             select new
             {
               a,
               av
             };

Where Organization and Didactic are the notes.

I would like a consultation through Ingli, which brings an average of the Organization and Didactic of each class.

But I can’t do it.

Answer 1

That’s how it works, but I’m not sure it’s the best way:

var result = from a in mdc.SBE_AA_Aulas
            join av in mdc.SBE_AA_AvaliacaoAlunos on a.id equals av.SBE_AA_Aula_id
            group new {a, av} by av.Aula_Id into grp
            select new {
                NomeAula = grp.Select(x => x.a.Nome).FirstOrDefault(),
                MediaOrganizacao = grp.Average(x => x.av.Organizacao),
                MediaDidatica = grp.Average(x => x.av.Didatica)
            }