OracleLoaderColumnCollection Class

Represents a collection of columns relevant to a OracleLoader.

For a list of all members of this type, see OracleLoaderColumnCollection members.

Inheritance Hierarchy

System.Object
   System.Collections.CollectionBase
      Devart.Common.DbLoaderColumnCollection
         Devart.Data.Oracle.OracleLoaderColumnCollection

Syntax

[Visual Basic]
Public Class OracleLoaderColumnCollection 
   Inherits DbLoaderColumnCollection
   Implements ICollection, IEnumerable, IList

[C#]
public class OracleLoaderColumnCollection : DbLoaderColumnCollection, ICollection, IEnumerable, IList

Remarks

Use OracleLoaderColumnCollection class to add or remove columns that will be loaded. Order and number of columns in the collection must be equal to the order and number of columns in the loaded table.

Note: This class is available with dotConnect for Oracle Professional edition only.

Example

Following example displays all loader columns.

[C#]

public void DisplayColumns(string tableName, OracleConnection conn) { 
 
  // Create loader instance 
  OracleLoader loader = new OracleLoader(); 
 
  // Set up working connection 
  // Connection must be opened 
  loader.Connection = conn; 
 
  // Set up table name for loading 
  loader.TableName = tableName; 
 
  // Create column collection for loading table 
  loader.CreateColumns(); 
 
  // Iterate through column collection 
  foreach (OracleLoaderColumn column in loader.Columns) 
    Console.WriteLine(column.Name); 
}

[Visual Basic]

Public Sub DisplayColumns(tableName as string, conn as OracleConnection)
 
  ' Create loader instance
   Dim loader as OracleLoader = new OracleLoader()
 
  ' Set up working connection
   ' Connection must be opened
   loader.Connection = conn
 
  ' Set up table name for loading
   loader.TableName = tableName
 
  ' Create column collection for loading table
   loader.CreateColumns()
 
  ' Iterate through column collection
   Dim column as OracleLoaderColumn
   For Each column in loader.Columns
     Console.WriteLine(column.Name)
   Next
 End Sub

See Also

Language