i'm looking for direction in terms (i hope) of existing documentation
or solution.
i have some databases (mssql & sybase, several flavors of each) that
i would like to run some queries on from ado.net in either c# or
vb.net. as the queries are based on combinations of these databases
and i'm looking to use an embedded firebird engine to temporarily
store the relevant data then re-query it from within birebird.
i'm running into a time bottleneck getting to data into the firebird
db. what is the quickest way to get a million or 2 records into a
firebird database from ado.net?

currently i select the relevant data from the source databases into
an ado.net dataset, open a connection to the firebird db, create a
table in the local firdbird database based on the schema of the
dataset, then step thru each of the records in that dataset and
generate an insert statement to insert the data into the firebird
database, and finally close the connection.

if the dataset only contained a 100,000 records the time would be
acceptable at about a second per 1000 records, but at a million or 2
reconds this just takes too long. i'm hoping that there exists a
solution that can insert the data into the firebird in close to the
same time that it takes to get the data from the source databases.
ex, a million or so records from the source databases takes about 3
minutes.

is it possible to select the data from the source databases directly
into the firebird database?

i'm using the 1.6.3 .net provider and the 1.5.2.4731 embedded
firebird engine, and am not at all oposed to changing either if it
will help.

help with either of these questions is much appreciated.
gabe