Non traditional database connections and datasets

[Guest]

I have an old COM Object that contains a link to a preparatory database. We
are using VS2005 VB.NET and are looking for ideas to work with it using the
new ADO data methods.

For example, our COM Object contains methods like, FirstRecord, NextRecord,
PriorRecord, etc. This COM object also contains properties like,
CustomerName, CustomerAddress1, CustomerCreditLimit, etc.

What we are looking for is some direction on what is the best method to
connect this COM Object into the ADO. Building a special class that would
load the data into a dataset is to time-consuming for the program. There
could be 300,000 records with 50 fields. Loading them one by one into a
dataset, could take 20 minutes. Besides the memory and network resources
just to generate one report or fill a datagrid.

We only need READ access to the COM object. There are no ODBC drivers
available.

It’s almost like we need a virtual record set or a load on demand datareader
component.

Thanks for your help in advance.

 

[Adrian Moore]

Mike,

If you only plan to access the COM object in a forward only, read-only
manner, then your suggestion of implementing a DbDataReader object makes a
lot of sense.

However, if you need to filter or sort the data, then I don't see you have
an option, but to copy it into a DataTable.

HOpe this helps
Adrian Moore
Microsoft MVP - Windows Networking
http://www.queryadataset.com