Class TableData Defines a list of rows that can be inserted into a table
Namespace : ETLBox.ControlFlowAssembly : ETLBox.dllSyntax# public class TableData : ITableData , IDataReader , IDataRecord , IDisposable Constructors TableData(TableDefinition)#
Declaration public TableData ( TableDefinition definition ) Parameters TableData(TableDefinition, int)#
Declaration public TableData ( TableDefinition definition , int estimatedBatchSize ) Parameters Properties AllowIdentityInsert# If set to true, the connection manager will try to enable identity inserts for the corresponding table (not supported by every database)
Declaration public bool AllowIdentityInsert { get ; set ; } Property Value ColumnConverters#
Declaration public Dictionary < string , Func < object , object >> ColumnConverters { get ; set ; } Property Value ColumnMapping#
Declaration public IColumnMappingCollection ColumnMapping { get ; } Property Value CurrentRow# The row that is currently processed when accessing the data reader
Declaration public object [] CurrentRow { get ; } Property Value DataIndexForColumn# Resolves the index number for a column name
Declaration public Dictionary < string , int > DataIndexForColumn { get ; set ; } Property Value Definition# Definition of the destination table
Declaration public TableDefinition Definition { get ; } Property Value Depth#
Declaration public int Depth { get ; } Property Value DestinationTableName# The name of the destination table
Declaration public string DestinationTableName { get ; } Property Value FieldCount#
Declaration public int FieldCount { get ; } Property Value IsClosed#
Declaration public bool IsClosed { get ; } Property Value this[int]#
Declaration public object this [ int i ] { get ; } Parameters Property Value this[string]#
Declaration public object this [ string name ] { get ; } Parameters Property Value KeepIdentity# By default, identity columns are included. If set to false, identity columns will be ignored
Declaration public bool KeepIdentity { get ; set ; } Property Value ReadIndex# The row index of the current row
Declaration public int ReadIndex { get ; } Property Value RecordsAffected#
Declaration public int RecordsAffected { get ; } Property Value Rows# Rows/Columns ready for bulk insert
Declaration public List < object []> Rows { get ; set ; } Property Value ValueGeneratedColumnData# A sorted list which contains data for each value generated column (the order in the object array is
the same as defined in ValueGeneratedColumnNames ).
The key of the list is a unique sequence number, and the order matches also to each entry in the Rows .
Declaration public SortedList < int , object []> ValueGeneratedColumnData { get ; set ; } Property Value ValueGeneratedColumnNames# A collection of all column names that are value generated columns (e.g. columns with a COMPUTED or DEFAULT value)
Declaration public ICollection < string > ValueGeneratedColumnNames { get ; set ; } Property Value Methods AddSequenceColumn(string)# Allows to name a column that is specifically used as a sequence column. The column will then be treated differently.
Declaration public void AddSequenceColumn ( string sequenceColumnName ) Parameters Type Name Description string sequenceColumnName
Close()#
Declaration Dispose()#
Declaration Dispose(bool)#
Declaration protected virtual void Dispose ( bool disposing ) Parameters Type Name Description bool disposing
GetBoolean(int)#
Declaration public bool GetBoolean ( int i ) Parameters Returns GetByte(int)#
Declaration public byte GetByte ( int i ) Parameters Returns GetBytes(int, long, byte[], int, int)#
Declaration public long GetBytes ( int i , long fieldOffset , byte [] buffer , int bufferoffset , int length ) Parameters Returns GetChar(int)#
Declaration public char GetChar ( int i ) Parameters Returns GetChars(int, long, char[], int, int)#
Declaration public long GetChars ( int i , long fieldoffset , char [] buffer , int bufferoffset , int length ) Parameters Returns GetData(int)#
Declaration public IDataReader GetData ( int i ) Parameters Returns GetDataTypeName(int)#
Declaration public string GetDataTypeName ( int i ) Parameters Returns GetDataTypeName(string)# Resolves the data type name for a column
Declaration public string GetDataTypeName ( string columnName ) Parameters Type Name Description string columnName Column name
Returns Type Description string Data type name
GetDateTime(int)#
Declaration public DateTime GetDateTime ( int i ) Parameters Returns GetDecimal(int)#
Declaration public decimal GetDecimal ( int i ) Parameters Returns GetDouble(int)#
Declaration public double GetDouble ( int i ) Parameters Returns GetFieldType(int)#
Declaration public Type GetFieldType ( int i ) Parameters Returns GetFloat(int)#
Declaration public float GetFloat ( int i ) Parameters Returns GetGuid(int)#
Declaration public Guid GetGuid ( int i ) Parameters Returns GetInt16(int)#
Declaration public short GetInt16 ( int i ) Parameters Returns GetInt32(int)#
Declaration public int GetInt32 ( int i ) Parameters Returns GetInt64(int)#
Declaration public long GetInt64 ( int i ) Parameters Returns GetName(int)#
Declaration public string GetName ( int i ) Parameters Returns GetOrdinal(string)#
Declaration public int GetOrdinal ( string name ) Parameters Returns GetSchemaTable()#
Declaration public DataTable GetSchemaTable () Returns GetString(int)#
Declaration public string GetString ( int i ) Parameters Returns GetTableColumn(string)# Resolves the column in the table definition
Declaration public TableColumn GetTableColumn ( string columnName ) Parameters Type Name Description string columnName Column name
Returns GetValue(int)#
Declaration public object GetValue ( int i ) Parameters Returns GetValues(object[])#
Declaration public int GetValues ( object [] values ) Parameters Type Name Description object []values
Returns IsDBNull(int)#
Declaration public bool IsDBNull ( int i ) Parameters Returns NextResult()#
Declaration Returns Read()#
Declaration Returns RewindReadIndex(int)# The IDataReader is iterated via the Read() method - once the last record was read,
the Read() will return false. If you want to iterate again, you can use
this method to "rewind" and start with the first record again.
Declaration public void RewindReadIndex ( int position = 0 ) Parameters Type Name Description int position
Implements#
ETLBox