OracleBulkCopyColumnMappingCollection Class
The OracleBulkCopyColumnMappingCollection class represents a collection of OracleBulkCopyColumnMapping objects that are used to map columns in the data source to columns in a destination table.
Class Inheritance
System.Object
System.CollectionBase
System.OracleBulkCopyColumnMappingCollection
Declaration
// C#
public sealed class OracleBulkCopyColumnMappingCollection : CollectionBaseRequirements
| Provider | ODP.NET, Unmanaged Driver | ODP.NET, Managed Driver | ODP.NET Core |
|---|---|---|---|
| Assembly | Oracle.DataAccess.dll |
Oracle.ManagedDataAccess.dll |
Oracle.ManagedDataAccess.dll |
| Namespace | Oracle.DataAccess.Client |
Oracle.ManagedDataAccess.Client |
Oracle.ManagedDataAccess.Client |
| .NET Framework | See System Requirements | See System Requirements | - |
| .NET (Core) | - | - | See System Requirements |
Thread Safety
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
Remarks
Column mappings define the mapping between data source and the target table.
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 name if the mapping is specified by ordinal position. To avoid this performance overhead, specify the mapping by column name.
Example
// C#