OracleLoaderColumn Class

Represents the attributes for column loading.

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

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      Devart.Common.DbLoaderColumn
         Devart.Data.Oracle.OracleLoaderColumn

Syntax

[Visual Basic]
Public Class OracleLoaderColumn 
   Inherits DbLoaderColumn

[C#]
public class OracleLoaderColumn : DbLoaderColumn

Remarks

Each OracleLoader uses a Columns to maintain a collection of OracleLoaderColumn objects. The OracleLoaderColumn object represents the attributes for column loading. Every OracleLoaderColumn object corresponds to one of the table fields with the same name as its Devart.Common.DbLoaderColumn.Name property.

You can manually make changes to the Columns collection to exclude some columns from INSERT statement generated by OracleLoader object.

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

Example

This sample shows how to perform loading of data into a table with the last column set to default value.

[C#]

public void LoadData(OracleConnection myConnection) 
{ 
  myConnection.Open(); 
  OracleLoader loader = new OracleLoader(); 
  loader.Connection = myConnection; 
  loader.TableName = "load_table"; 
  try 
  { 
    loader.CreateColumns(); 
    //Do not insert data in the last column 
    loader.Columns.RemoveAt(loader.Columns.Count-1); 
    loader.Open(); 
    for (int i = 1; i <= 100; i++) 
    { 
      loader.SetValue("id", i); 
      loader.SetValue(1, "test string"); 
      loader.SetValue("date_field", DateTime.Now); 
      loader.NextRow(); 
    } 
    loader.Close(); 
  } 
  finally 
  { 
    myConnection.Close(); 
  } 
}

[Visual Basic]

Public Sub LoadData(ByVal myConnection As OracleConnection)
   myConnection.Open()
   Dim loader As OracleLoader
   loader = New OracleLoader
   loader.Connection = myConnection
   loader.TableName = "load_table"
   Try
     loader.CreateColumns()
     ' Do not insert data in the last column
     loader.Columns.RemoveAt(loader.Columns.Count - 1)
     loader.Open()
     Dim i As Integer
     For i = 1 To 100
       loader.SetValue("id", i)
       loader.SetValue(1, "test string")
       loader.SetValue("date_field", DateTime.Now)
       loader.NextRow()
     Next i
     loader.Close()
   Finally
     myConnection.Close()
   End Try
 End Sub

See Also

Language