Are DataAdapters loading the data in connection-mode possible?

[Gerald Zukrigl]

Hi!

We want are having a selfwritten OODB and now we want to
allow our customers to use ADO.NET for accessing this data.
Of course some will say now, ADO.NET is not OODB-prepared,
but we've found a mapping of classes into tables. But we
are in trouble
concerning the ado.net connection modes.

For performance reasons (time and memory) we want to load
the information row by row, as it is needed, just in time.
As far as I've found information one can use an
IDataReader, but is using this possible also with datasets.

As we are holding a connection to our database
permanently, nothing speaks for a offline-dataset but the
possibility to query data by sql from the dataset itself
makes it very interesting of course.


Is there a way of createing a dataset which loads the
information just in time (when it is needed) from the
datasource?

Can you recommend a good book concerning the ADO.NET
internals?

Any other sources of information concerning this topic?


Thank you,

Gerald Zukrigl
AXAVIA Software GmbH
Linz, AUSTRIA, EUROPE

 

[Kathleen Dollard]

Gerald,

Is there a way of createing a dataset which loads the
information just in time (when it is needed) from the
datasource?

I would not go so far as saying "No", but if someone does, I hope they write
an article on it. It is right up there between very dificult and impossible.
This is simply not what the DataSet was designed for. It was designed as a
container, and the DataReader was designed to interact with a forward only
cursor.

I think you should approach your problem which appears to be a paging
problem, a different way. Perhaps you could clarify the scenario in which
you think row by row retrieval will be faster.