Dynamic Linq query on Datatable

Question

I want to make the following query dynamic.

var t = from r in dt.AsEnumerable()  
orderby r.Field< int >("id") ascending
select r;

void query(string sorttype,string sortorder)

Is it possbile to change the order by part so that those paramater will come from parameters of a function like sorttype for id in here and sortorder for ascending.

Answer 1

I think this ought to do it:

IEnumerable query<sorttype>(DataTable dt, string sortorder) {
    return dt.GetList().OrderBy(row => row.Field<sorttype>(sortorder));
}

Note that sorttype is a generic type parameter, not a string.