How to copy data from an Oracle table into an SQLite Table using ado.net and few lines of code.

Question

Hello:

I need to do a generic C# program to let the data reading from an Oracle database table (T1) with, for example, field names a, b, c, d, and saving into an SQLite3 table (T2) with the same field names and types than T1, althought with additional fields that can have null values.

I am using the different ado.net libraries provided for each one of the database products.

What is the best way to do this without impacting the performance during the copy? I want to avoid the overhead that represents the manual type conversion during the data transfer and the traditional abundant coding that ado.net usually demands.

I tried with a test program using OracleDataAdapter (Source) and SQLiteDataAdapter (target) to load Oracle data into a DataSet, but when I want to put data from the dataSet into the Sqlite table using one line of coding (i.e. SqliteDataAdapter.Update(DataSet, "T2");), the program aborts because of schema imcompatibility.

I would like to know a recommended alternative sequence and objects used to solve my requirement or at least a web site containing examples of what I want.

Thanks!!

Answer 1

If you know how to do it, please let me also know. hx