How to OrderBy in LINQ to Entities (EF4.1) when I only know the property name at runtime?

Question

I have a linq query of objects of a known type and I need to sort it based on a property of the object. The problem is I only know the property name at runtime and as a string.

ex.

IQueryable<Thing> thing = from t in ctx.Things select t;
t.OrderBy(t => t.Name);   // This would work if I knew the property at compile time...
t.OrderBy("Name asc");    // But this is what I really need!  and it doesn't work.

Is there a way to do this for LINQ to Entities? I'm using entity framework 4.1

See this question http://stackoverflow.com/questions/307512/how-do-i-apply-orderby-on-an-iqueryable-using-a-string-column-name-within-a-gener#308561 — Bobby Richard, Aug 31 '11 at 21:31

Tun Hein · Answer 1 · 2012-02-09T17:25:06.487

-1

There are two

.OrderBy(m => m.Name)
.OrderByDescending(m => m.Name)

First one represents Ascending, the other one descending.

Hope it helps.

What about try this one ! Let's see if helps

    Expression orderByProperty = Expression.Property(prm, sortBy);

    // get the paged records
    IQueryable<PostingListItemDto> query = be.buskerPosting
    .Where(posting => posting.buskerAccount.cmsMember.nodeId == m.Id)
    .OrderBy(orderByExpression)

edited Feb 09 '12 at 17:25

answered Feb 06 '12 at 11:19

Tun Hein

1
2

I don't know the property name at compile time, so that won't work for me. – codemonkey Feb 09 '12 at 02:36

How to OrderBy in LINQ to Entities (EF4.1) when I only know the property name at runtime?

1 Answers1