Linqbuilder Query with an OrderBy

Question

I have a 1 : M relationship.

I built a dynamic query based on input from users to return the listing of parents entities along with their children (using predicate builder:

(done successfully new TDataContext().Ps.Where(predicate) )...

but need to order the results by a field found only on the child entities.

I'm at a loss: new TDataContext().Ps.Where(predicate).OrderBy(p => p.Cs. ??)

where Ps = parents collection relationship with Cs = child entities

any help appreciated.

can't you order BEFORE selecting? – Luiscencio Mar 12 '10 at 18:57 — Luiscencio, Mar 12 '10 at 18:57

score 1 · Answer 1 · answered Mar 12 '10 at 19:08

1

One way would be to select childs first:

new TDataContext().Ps.Where(predicate).SelectMany(p=>p.Cs).OrderBy(q => q.Name);

answered Mar 12 '10 at 19:08

Francisco

score 0 · Answer 2 · answered Mar 12 '10 at 19:02

Try something like this:

new TDataContext().Ps.Where(predicate).OrderBy((<datatype of p> p) => p.Cs.Name)

You will have to replace "<datatype of p>" with whatever that is. Also, you will have to replace "Name" with whatever field you want to sort by.

2 Answers2