How to handle paging & sorting efficiently through WCF RIA service using dataset while dealing huge tables

Question

I have successfully created a WCF RIA service by creating DomainService class and accessing the oracle database using ADO.NET. However creating a domainservice using ADO.NET seems to have limitations when compared to creating a domainservice using entity framework in terms of efficient sorting, paging of huge tables(more than 5 million records). Is there any way to implement efficient paging and sorting using ADO.NET? If so, can anyone share some code?

I want to databind the domainservice to silverlight datagrid and expecting paging/sorting on datagrid.

Answer 1

@Henrik Thanks for the link.

For the sake of others who has same/similar type of scenario,Here there is another link that is more specific to my question i.e. using ADO.NET (& eventually dataset)