Unable to cast COM object of type 'ADODB.RecordsetClass' to classtype 'System.Object[]'

[Steve Gerrard]

I think you must be comparing apples and oranges.

While ado.net may not be a speed demon, it is not in general 57 times
slower than ADODB through COM. Perhaps you used too many gee-wizards
to setup your ADO.Net test, instead of just coding it directly like
you did for ADODB.

For example, so you don't think I'm making it up: using an OleDbConnection and
an OleDbDataAdapter, I just ran some tests on a table of 137,000 records. Time
to fill a generic DataTable: 4.2 seconds. Time to fill a wizard-generated typed
table in a typed dataset: 9.4 seconds.