RemoteDataAdapter best practive large dataset

Hello,

We are using the RemoteDataAdapter in our client-server application to get data from the server and we stuff it in a dataset/datatable (C# WinForms).
But is it possible to work with a DataReader clientside?
If so, how does it work?

Thanks.

Wouter

Hello

In general the best practice is to process large datasets at the server side.

By default Data Abstract works with the detached dataset model. This means that the server fully reads the requested data from the database and then sends it to the client.

That said, it is possible to implement IDataReader streaming from server to the client, however such approach will require custom code and server methods.

How big is your ‘large dataset’?

Regards