Interface ITableData

A list of rows and a column mapping ready for bulk insert

Inherited Members
System.Data.IDataReader.Close()
System.Data.IDataReader.GetSchemaTable()
System.Data.IDataReader.NextResult()
System.Data.IDataReader.Read()
System.Data.IDataReader.Depth
System.Data.IDataReader.IsClosed
System.Data.IDataReader.RecordsAffected
System.Data.IDataRecord.GetBoolean(System.Int32)
System.Data.IDataRecord.GetByte(System.Int32)
System.Data.IDataRecord.GetBytes(System.Int32, System.Int64, System.Byte[], System.Int32, System.Int32)
System.Data.IDataRecord.GetChar(System.Int32)
System.Data.IDataRecord.GetChars(System.Int32, System.Int64, System.Char[], System.Int32, System.Int32)
System.Data.IDataRecord.GetData(System.Int32)
System.Data.IDataRecord.GetDataTypeName(System.Int32)
System.Data.IDataRecord.GetDateTime(System.Int32)
System.Data.IDataRecord.GetDecimal(System.Int32)
System.Data.IDataRecord.GetDouble(System.Int32)
System.Data.IDataRecord.GetFieldType(System.Int32)
System.Data.IDataRecord.GetFloat(System.Int32)
System.Data.IDataRecord.GetGuid(System.Int32)
System.Data.IDataRecord.GetInt16(System.Int32)
System.Data.IDataRecord.GetInt32(System.Int32)
System.Data.IDataRecord.GetInt64(System.Int32)
System.Data.IDataRecord.GetName(System.Int32)
System.Data.IDataRecord.GetOrdinal(System.String)
System.Data.IDataRecord.GetString(System.Int32)
System.Data.IDataRecord.GetValue(System.Int32)
System.Data.IDataRecord.GetValues(System.Object[])
System.Data.IDataRecord.IsDBNull(System.Int32)
System.Data.IDataRecord.FieldCount
System.Data.IDataRecord.Item[System.Int32]
System.Data.IDataRecord.Item[System.String]
System.IDisposable.Dispose()
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public interface ITableData : IDataReader, IDataRecord, IDisposable

Properties

AllowIdentityInsert

If set to true, values in an indentity column are overwriten with the provided values

Declaration
    bool AllowIdentityInsert { get; set; }
Property Value
TypeDescription
System.Boolean

ColumnMapping

The column mapping

Declaration
    IColumnMappingCollection ColumnMapping { get; }
Property Value
TypeDescription
System.Data.IColumnMappingCollection

CurrentRow

The row that is currently processed when accessing the data reader

Declaration
    object[] CurrentRow { get; }
Property Value
TypeDescription
System.Object[]

DataIndexForColumn

Resolves the index number for a column name

Declaration
    Dictionary<string, int> DataIndexForColumn { get; set; }
Property Value
TypeDescription
System.Collections.Generic.Dictionary<System.String, System.Int32>

Definition

Definition of the destination table

Declaration
    TableDefinition Definition { get; }
Property Value
TypeDescription
TableDefinition

DestinationTableName

The name of the destination table

Declaration
    string DestinationTableName { get; }
Property Value
TypeDescription
System.String

ReadIndex

The row index of the current row

Declaration
    int ReadIndex { get; }
Property Value
TypeDescription
System.Int32

Rows

Rows/Columns ready for bulk insert

Declaration
    List<object[]> Rows { get; }
Property Value
TypeDescription
System.Collections.Generic.List<System.Object[]>

Methods

GetDataTypeName(String)

Resolves the data type name for a column

Declaration
    string GetDataTypeName(string columnName)
Parameters
TypeNameDescription
System.StringcolumnName

Column name

Returns
TypeDescription
System.String

Data type name