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.
Best Answer
@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)