Add(string, int)
This method creates and adds an OracleBulkCopyColumnMapping object to the collection using the supplied source column name and destination column ordinal.
Declaration
// C# public OracleBulkCopyColumnMapping Add(string sourceColumn, int destinationColumnIndex);
Parameters
-
sourceColumnThe name of the source column within the data source.
-
destinationColumnIndexThe ordinal position of the destination column within the destination table.
Return Value
The newly created OracleBulkCopyColumnMapping object that was added to the collection.
Exceptions
InvalidOperationException - The bulk copy operation is in progress.
Remarks
It is not necessary to specify column mappings for all the columns in the data source. If a ColumnMapping is not specified, then, by default, columns are mapped based on the ordinal position. This succeeds only if the source and destination table schema match. If there is a mismatch, an InvalidOperationException is thrown.
All the mappings in a mapping collection must be by name or ordinal position.
Note:
Oracle Data Provider for .NET makes one or more round trips to the database to determine the column names if the mapping is specified by ordinal resulting in a performance overhead. Therefore, it is recommended to specify the mapping by column names.