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.
--
Kathleen (MVP-VB)
"Gerald Zukrigl" <(E-Mail Removed)> wrote in message
news:07ce01c3573a$5c2a6db0$(E-Mail Removed)...
> 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
>
|
Similar Threads
