dotnet remoting: I am writing a remoting application and my server object passes result sets
from a SQL Server database to the clients. What data object should I use if
I want to maximize performance: Dataset, DataReader, other?

"Wannano" <marc.biotteau@sympatico.ca> wrote in
news:OeqGwpgyHHA.4276@TK2MSFTNGP05.phx.gbl:

[quoted text, click to view]

It really depends on the circumstance, but in general, DataReaders are

Hello Wannano!

[quoted text, click to view]

A Dataset is filled by a DataReader. So when you just read simple rows, a
DataReader will be allways faster than a DataSet.

But: A DataSet is much more than a collection of rows. When you use the rich
DataSet features it may be better to use the DataSet than implementing this
behavior on you own.


GP