Custom sort

[Mark]

Hi,
I am using RadDomainDataSource and WCF Services to get data from ms sql database. But I have problem with sorting because I want to implement my own sort logic (natural sort of numbers stored as nvarchar). How can I do that?

Any advice would be greatly appreciated.
With regards 
Mark

[Dimitrina]

Hi Mark,

When using RadDomainDataSource then paging, filtering and sorting will be performed directly on the server. 

Still along with the control we are shipping a set of extension methods which allow you to write native LINQ expression against an entity query object. 

Regards,
Didie
Telerik

[Mark]

Hi,
What extension method do you mean? Do you have any example I could use?

With regards
Mark

[Dimitrina]

Hi,

The pager generates Skip and Take clauses on the respective IQueryable and then they are sent for execution directly to server. You can check this forum for an example on how you can invoke them yourself.

You can also check more information on LINQ and also the IQueryable interface, which RadGridView perfectly binds to. Please note that the RadDomainDataSource.DataView implements this interface. 

Regards,
Didie
Telerik