i am writing a windows app (vb.net) that uses different databases (MS
SQL, Oracle9i,...). The database used for a decent module of the app
can change from time to time - so the goal is to have a generic
database access layer (wrapper) to connect to the different databases.
This works fine as long as i return a dataset, because its
disconnected and dbms-independent (my wrapper fills the dataset by
using the appropriate dataadapter and returns the dataset).
Now the problem: Sometimes i need to read large amounts of data (about
200.000 rows). In this case the dataadapter/dataset becomes too slow,
therefore i want to use a datareader. But since the datareader is not
dbms-independent, id have to struggle with different datareaders in
my modules again (and thats what I dont want to do).
So my question is: does anybody know a good way to get the data of the
datareader into my modules without having them to know which dbms the
data came from? One way would be to populate the data to a datatable,
but in this case I could also use a dataadapter...
Thanks in advance,