DataSet in Multi tier applications...

Hi All.

I have a question(s).:) We have a multi tiered (more than 3) application. We don't want to use a DATASET to pass from one tier to another. We looked at SQLDATAREADER... but the connection has to be open to use it ... (that is bad)...

Is there a way to use the SQLDataReader? Or what is a better way?

Thanks!

If you use the SQLDataReader then you need an open and exclusive connection there is no way around that. It has to do with the way the datareader works and being a forward only read only object. It doesn't read the whole data at once it only reads each row as it goes along.

Why don't you want to pass the dataset around? You could pass XML around.

There is a small but cool book and tiered design and application structure in this free welcome pack: http://www.vbforums.com/showthread.p...hreadid=262646

Thanks!

They say the Dataset is heavy weight to pass around... that is why!

what about just using a data-table then (part of the data set).

you could also create your own objects to pass around.