Suggestion: OracleLoader to support IDataReader as a row source

[Dennis Wanke]

I suggest OracleLoader (in fact, all DbLoader descendants) should provide a method for importing data from a data Reader (in addition to LoadTable() that accepts a DataTable).

[Pinturiccio]

We will investigate the possibility to import data from OracleDataReader with OracleLoader and post here about the results as soon as possible.

[Dennis Wanke]

In fact we've already implemented this logic:

Code: Select all

loader.Open();
while (reader.Read())
{
    foreach (OracleLoaderColumn column in loader.Columns)
    {
        var name = column.Name;
        loader.SetValue(name, reader.GetValue(reader.GetOrdinal(name)));
    }
    loader.NextRow();
}

But maybe you can do it more optimally. You may also consider an option similar to SqlBulkCopy.EnableStreaming.