How to include sorted navigation properties with Entity Framework

Question

I have an entity A with a collection of B inside. I load them with a _entity.A.Include(a => a.B)

Now I want to have the B's into A sorted by a custom OrderBy. I tried _entity.A.Include(a => a.B.OrderBy(o => o.Version) but I get a :

The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties.

Any ideas on how to accomplish this?

Thanks.

Version is an integer.

Can you post a body of your `OrderBy` ? – Mateusz Rogulski Nov 05 '12 at 14:19 — Mateusz Rogulski, Nov 05 '12 at 14:19

Mateusz Rogulski · Accepted Answer · 2012-11-05T14:48:45.353

4

I think in this case you can try:

var list = _entity.A.Include("B").ToList();
list.ForEach(m => m.B = m.B.OrderBy(o => o.Version));

or:

_entity.A.Include("B").Select(m => new A {
        //some props,
        B = m.B.OrderBy(o => o.Version)
        });

edited Nov 05 '12 at 14:48

answered Nov 05 '12 at 14:29

Mateusz Rogulski

7,357
7
44
62

Agree, but can this by done with just one query to avoid looping the collections twice? – Ignacio Soler Garcia Nov 05 '12 at 14:31
@SoMoS I've added secound solution which have place in one line, but I'm not sure which is better. – Mateusz Rogulski Nov 05 '12 at 14:50
Well, I'm not completely happy with the solution but I will accept it as I don't have other options. Thanks! – Ignacio Soler Garcia Nov 06 '12 at 10:18

How to include sorted navigation properties with Entity Framework

1 Answers1

Linked