Using LINQ to dynamic sort data in GridPanel

[sunny_sh]

Hi, everybody,
In the source code of mvc.ext.net, you can find a function names "GetCustomers" in DataController.cs. By it's signature

public AjaxStoreResult GetCustomers(int limit, int start, string dir, string sort)

we can know it ueses dir and sort to sort data.
But reading code, it uses LINQ to implement search and sort. We kown, LINQ doesn't support order by a static string. So this line

orderby(string.Concat(sort, " ", dir))

was not working in fact.

I think below is a better method to dynamic sort data using LINQ. (by vb.net)

Dim selector = GetType(Customer).GetProperty(sort)

if String.Compare("ASC", dir, true) then
    query = query.OrderBy(Function(c) selector.GetValue(c, nothing))
else
    query = query.OrderByDescending(Function(c) selector.GetValue(c, nothing))
end if

Maybe it needs refactor to better smell, but it's now working!

[geoffrey.mcgill]

The .OrderBy Method is an Extension Method which enable passing a string query. See System.Linq.Dynamic.DynamicQueryable

Breaking out .OrderBy into the if/else block is fine, but just not a clean in my opinion.


Hope this helps.

[sunny_sh]

Aha, I didn't notice this namespace. It's a more clever method than me.
Why did I not find this namespace from msdn? It's a new namespace under System.Linq? I found a Microsoft sign on the head of the code file.

[KHafeez]

Guys does any one can help me out in my scenario I am using in my project simple query and fetching records and populating a dataset and then I want to use it for gridpanel but with paging sorting functionallity, i also check out the paging and sorting example given but it uses LINQ and list with NortwindDataContext way to achieve this functions. I want to achieve it by dataset as it is already implemented in my project and i think it will give us new way of implementation of paging and sorting using coolite gridpanel, your quick response is awaited