How to create a Lambda expression with Group by and Order By

Question

How to create a Lambda expression with Group by and Order By

Navigation

#1 by (3 votes)

1

I'm having trouble creating a Lambda sentence with Group by and Order By Together.

How do I group by the Scope and IDScope column, and sort by IDEscope.

Judgment follows.

 public static List<Escopos> EscoposCalCliente(int IDCalCLiente)
        {
            using (entidadesIUS entidades = new entidadesIUS())
            {
                return entidades.Escopos.Where(e => e.CALClientes.Any(cc => cc.IDCALCliente == IDCalCLiente)).
                ToList().
                GroupBy(es => new {.IDEscopo, es.IDEscopo }).
                SelectMany(esc => esc.OrderBy(escp => escp.IDEscopo));
            }
        }

c# entity-framework-6

asked by anonymous 18.12.2014 / 19:39

1 answer

Schedule page loading via CRON Resize image in java

score 3 · Answer 1

I see no need in your example to use GroupBy and OrderBy . Only OrderBy does all the work.

    public static List<Escopos> EscoposCalCliente(int IDCalCLiente)
    {
        using (entidadesIUS entidades = new entidadesIUS())
        {
            return entidades.Escopos
                .Where(e => e.CALClientes.Any(cc => cc.IDCALCliente == IDCalCLiente))
                .OrderBy(es => es.IDEscopo)
                .ToList();
        }
    }