Pass a value to an OrderBy or OrderByDescending statement in Linq?

Question

Possible Duplicate:
Dynamic LINQ OrderBy

How can I pass a value to an OrderBy or OrderByDescending statement in Linq? I am trying to get the property name dynamically:

x.GetType().GetProperty(sortField)

Which doesnt seem to work. Any Ideas?

private void DynamicSort(ref List<Quote> myQuotes, String sortField, String direction)
{         
        if(direction == "ASC"){
            this.grdViewDrafts.DataSource = myQuotes.OrderBy(x =>  x.GetType().GetProperty(sortField)).ToList();
        }else{
            this.grdViewDrafts.DataSource = myQuotes.OrderByDescending(x => x.GetType().GetProperty(sortField)).ToList();
        }

}

Solution:

this.grdViewDrafts.DataSource =  myQuotes.OrderBy(x => x.GetType().GetProperty(sortField).GetValue(x, null)).ToList();

http://stackoverflow.com/questions/41244/dynamic-linq-orderby — L.B, Oct 16 '12 at 14:08

score 4 · Accepted Answer · edited Oct 16 '12 at 14:19

4

The actual problem in your code is that you just get PropertyInfo object but not the property value itself. To get property value you have to call GetValue() method of the PropertyInfo object.

edited Oct 16 '12 at 14:19

JSK NS

3,076
2
21
40

answered Oct 16 '12 at 14:17

Anton Sorokin

391
1
6
10

this method made the query performed very slow if you have more records. – Majid Shahabfar Jan 15 '19 at 19:05
@Libertad yes, reflection is slow. You’d best to avoid it unless required and cache PropertyInfo/MethodInfo/etc. methods if possible – Anton Sorokin Jan 15 '19 at 19:10

Pass a value to an OrderBy or OrderByDescending statement in Linq?

1 Answers1