• Getting started
  • API Documentation
  • Pricing
  • Contact
Show / Hide Table of Contents
  • ETLBox.Connection
    • AccessOdbcConnectionManager
    • AdomdConnectionManager
    • ConnectionManagerType
    • Db2ConnectionManager
    • Db2ConnectionString
    • DbConnectionManager<Connection>
    • DbConnectionString<T, TBuilder>
    • IConnectionManager
    • IDbConnectionString
    • MariaDbConnectionManager
    • MariaDbConnectionString
    • MySqlConnectionManager
    • MySqlConnectionString
    • MySqlOdbcConnectionManager
    • OdbcConnectionManager
    • OdbcConnectionString
    • OleDbConnectionManager
    • OleDbConnectionString
    • OracleConnectionManager
    • OracleConnectionString
    • OracleOdbcConnectionManager
    • PostgresConnectionManager
    • PostgresConnectionString
    • PostgresOdbcConnectionManager
    • SqlConnectionManager
    • SqlConnectionString
    • SQLiteConnectionManager
    • SQLiteConnectionString
    • SqlOdbcConnectionManager
    • SqlOleDbConnectionManager
  • ETLBox.ControlFlow
    • ControlFlow
    • ControlFlowTask
    • DbTask
    • DropTask<T>
    • IfExistsTask
    • ILoggableTask
    • ITableData
    • LoggableTask
    • ProcedureDefinition
    • ProcedureParameter
    • QueryParameter
    • TableColumn
    • TableData
    • TableData<T>
    • TableDefinition
  • ETLBox.ControlFlow.Tasks
    • CalculateDatabaseHashTask
    • CleanUpSchemaTask
    • CreateDatabaseTask
    • CreateIndexTask
    • CreateProcedureTask
    • CreateSchemaTask
    • CreateTableTask
    • CreateViewTask
    • DropDatabaseTask
    • DropIndexTask
    • DropProcedureTask
    • DropSchemaTask
    • DropTableTask
    • DropViewTask
    • GetDatabaseListTask
    • IfDatabaseExistsTask
    • IfIndexExistsTask
    • IfProcedureExistsTask
    • IfSchemaExistsTask
    • IfTableOrViewExistsTask
    • RecoveryModel
    • RowCountOptions
    • RowCountTask
    • SqlTask
    • TruncateTableTask
    • XmlaTask
  • ETLBox.DataFlow
    • AggregateColumn
    • ChangeAction
    • ColumnMap
    • CompareColumn
    • DataFlow
    • DataFlowBatchDestination<TInput>
    • DataFlowComponent
    • DataFlowDestination<TInput>
    • DataFlowExecutableSource<TOutput>
    • DataFlowJoinTarget<TInput>
    • DataFlowSource<TOutput>
    • DataFlowStreamDestination<TInput>
    • DataFlowStreamSource<TOutput>
    • DataFlowTransformation<TInput, TOutput>
    • DeleteColumn
    • DistinctColumn
    • ErrorSource
    • ETLBoxError
    • ExcelColumn
    • ExcelRange
    • GroupColumn
    • ICacheManager<TInput, TCache>
    • IDataFlowBatchDestination
    • IDataFlowBatchDestination<TInput>
    • IDataFlowComponent
    • IDataFlowDestination
    • IDataFlowDestination<TInput>
    • IDataFlowExecutableSource
    • IDataFlowExecutableSource<TOutput>
    • IDataFlowLogging
    • IDataFlowSource
    • IDataFlowSource<TOutput>
    • IDataFlowStreamDestination
    • IDataFlowStreamDestination<TInput>
    • IDataFlowStreamSource
    • IDataFlowStreamSource<TOutput>
    • IDataFlowTransformation<TInput, TOutput>
    • IDataFlowTransformation<TOutput>
    • IdColumn
    • IMergeableRow
    • JoinTarget<TInput>
    • MatchColumn
    • MemoryCache<TInput, TCache>
    • MergeableRow
    • MergeMode
    • MergeProperties
    • Network
    • ResourceType
    • RetrieveColumn
    • StreamMetaData
    • TypeInfo
    • UpdateColumn
  • ETLBox.DataFlow.Connectors
    • ConcurrentMemoryDestination
    • ConcurrentMemoryDestination<TInput>
    • CsvDestination
    • CsvDestination<TInput>
    • CsvSource
    • CsvSource<TOutput>
    • CustomBatchDestination
    • CustomBatchDestination<TInput>
    • CustomBatchSource
    • CustomBatchSource<TOutput>
    • CustomDestination
    • CustomDestination<TInput>
    • CustomSource
    • CustomSource<TOutput>
    • DbDestination
    • DbDestination<TInput>
    • DbMerge
    • DbMerge<TInput>
    • DbSource
    • DbSource<TOutput>
    • ExcelSource
    • ExcelSource<TOutput>
    • JsonDestination
    • JsonDestination<TInput>
    • JsonSource
    • JsonSource<TOutput>
    • MemoryDestination
    • MemoryDestination<TInput>
    • MemorySource
    • MemorySource<TOutput>
    • TextDestination
    • TextDestination<TInput>
    • TextSource
    • TextSource<TOutput>
    • VoidDestination
    • VoidDestination<TInput>
    • XmlDestination
    • XmlDestination<TInput>
    • XmlSource
    • XmlSource<TOutput>
  • ETLBox.DataFlow.Transformations
    • Aggregation
    • Aggregation<TInput, TOutput>
    • AggregationMethod
    • BatchTransformation
    • BatchTransformation<TInput, TOutput>
    • BatchTransformation<TInput>
    • BlockTransformation
    • BlockTransformation<TInput, TOutput>
    • BlockTransformation<TInput>
    • CachedBatchTransformation
    • CachedBatchTransformation<TInput, TOutput, TCache>
    • CachedBatchTransformation<TInput, TOutput>
    • CachedBatchTransformation<TInput>
    • CachedRowTransformation
    • CachedRowTransformation<TInput, TOutput, TCache>
    • CachedRowTransformation<TInput, TOutput>
    • CachedRowTransformation<TInput>
    • CacheMode
    • ColumnRename
    • ColumnRename<TInput>
    • CrossJoin
    • CrossJoin<TInput>
    • CrossJoin<TInput1, TInput2, TOutput>
    • CrossJoin<TInput1, TInput2, TOutput>.InMemoryDestination<TInput>
    • Distinct<TInput>
    • LookupTransformation
    • LookupTransformation<TInput, TSource>
    • LookupTransformation<TInput, TSource>.PartialDbCacheSettings
    • MergeJoin
    • MergeJoin<TInput>
    • MergeJoin<TInput1, TInput2, TOutput>
    • Multicast
    • Multicast<TInput>
    • RowDuplication
    • RowDuplication<TInput>
    • RowMultiplication
    • RowMultiplication<TInput, TOutput>
    • RowMultiplication<TInput>
    • RowTransformation
    • RowTransformation<TInput, TOutput>
    • RowTransformation<TInput>
    • Sort
    • Sort<TInput>
    • XmlSchemaValidation
    • XmlSchemaValidation<TInput>
  • ETLBox.Exceptions
    • ETLBoxException
    • ETLBoxFaultedBufferException
    • ETLBoxNotSupportedException
  • ETLBox.Helper
    • BatchLinq
    • BulkSqlGenerator<T>
    • DataTypeConverter
    • ExpandoJsonPathConverter
    • HashHelper
    • IDataTypeConverter
    • JsonPathConverter
    • JsonProperty2JsonPath
    • JsonProperty2JsonPath.MultipleResultsInPath
    • ObjectNameDescriptor
    • PropertyInfoExtension
    • SqlParser
    • StringExtension
  • ETLBox.Logging
    • AbortLoadProcessTask
    • CreateErrorTableTask
    • CreateLoadProcessTableTask
    • CreateLogTableTask
    • CustomTask
    • EndLoadProcessTask
    • ETLLogLayoutRenderer
    • GetLoadProcessAsJSONTask
    • GetLogAsJSONTask
    • LoadProcess
    • LogEntry
    • Logging
    • LogHierarchyEntry
    • LogTask
    • Package
    • ReadLoadProcessTableTask
    • ReadLogTableTask
    • ReadOptions
    • Sequence
    • Sequence<T>
    • StartLoadProcessTask

Class TableData<T>

Defines a list of rows that can be inserted into a table

Inheritance
System.Object
TableData<T>
TableData
Implements
ITableData
System.Data.IDataReader
System.Data.IDataRecord
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
public class TableData<T> : ITableData, IDataReader, IDataRecord, IDisposable
Type Parameters
Name Description
T

Object type of a row

Constructors

TableData(TableDefinition)

Declaration
public TableData(TableDefinition definition)
Parameters
Type Name Description
TableDefinition definition

TableData(TableDefinition, Int32)

Declaration
public TableData(TableDefinition definition, int estimatedBatchSize)
Parameters
Type Name Description
TableDefinition definition
System.Int32 estimatedBatchSize

Properties

ColumnMapping

The column mapping

Declaration
public IColumnMappingCollection ColumnMapping { get; }
Property Value
Type Description
System.Data.IColumnMappingCollection

CurrentRow

Declaration
public object[] CurrentRow { get; }
Property Value
Type Description
System.Object[]

Depth

Declaration
public int Depth { get; }
Property Value
Type Description
System.Int32

DestinationTableName

Declaration
public string DestinationTableName { get; }
Property Value
Type Description
System.String

FieldCount

Declaration
public int FieldCount { get; }
Property Value
Type Description
System.Int32

IsClosed

Declaration
public bool IsClosed { get; }
Property Value
Type Description
System.Boolean

Item[Int32]

Declaration
public object this[int i] { get; }
Parameters
Type Name Description
System.Int32 i
Property Value
Type Description
System.Object

Item[String]

Declaration
public object this[string name] { get; }
Parameters
Type Name Description
System.String name
Property Value
Type Description
System.Object

ReadIndex

Declaration
public int ReadIndex { get; }
Property Value
Type Description
System.Int32

RecordsAffected

Declaration
public int RecordsAffected { get; }
Property Value
Type Description
System.Int32

Rows

Rows/Columns ready for bulk insert

Declaration
public List<object[]> Rows { get; set; }
Property Value
Type Description
System.Collections.Generic.List<System.Object[]>

Methods

ClearData()

Clears the internal list that holds the data and rewinds the pointer for the reader to the start

Declaration
public void ClearData()

Close()

Declaration
public void Close()

Dispose()

Declaration
public void Dispose()

Dispose(Boolean)

Declaration
protected virtual void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing

GetBoolean(Int32)

Declaration
public bool GetBoolean(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Boolean

GetByte(Int32)

Declaration
public byte GetByte(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Byte

GetBytes(Int32, Int64, Byte[], Int32, Int32)

Declaration
public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
Parameters
Type Name Description
System.Int32 i
System.Int64 fieldOffset
System.Byte[] buffer
System.Int32 bufferoffset
System.Int32 length
Returns
Type Description
System.Int64

GetChar(Int32)

Declaration
public char GetChar(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Char

GetChars(Int32, Int64, Char[], Int32, Int32)

Declaration
public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
Parameters
Type Name Description
System.Int32 i
System.Int64 fieldoffset
System.Char[] buffer
System.Int32 bufferoffset
System.Int32 length
Returns
Type Description
System.Int64

GetData(Int32)

Declaration
public IDataReader GetData(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Data.IDataReader

GetDataTypeName(Int32)

Declaration
public string GetDataTypeName(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.String

GetDataTypeName(String)

Declaration
public string GetDataTypeName(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
System.String

GetDateTime(Int32)

Declaration
public DateTime GetDateTime(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.DateTime

GetDecimal(Int32)

Declaration
public decimal GetDecimal(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Decimal

GetDouble(Int32)

Declaration
public double GetDouble(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Double

GetFieldType(Int32)

Declaration
public Type GetFieldType(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Type

GetFloat(Int32)

Declaration
public float GetFloat(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Single

GetGuid(Int32)

Declaration
public Guid GetGuid(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Guid

GetInt16(Int32)

Declaration
public short GetInt16(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Int16

GetInt32(Int32)

Declaration
public int GetInt32(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Int32

GetInt64(Int32)

Declaration
public long GetInt64(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Int64

GetName(Int32)

Declaration
public string GetName(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.String

GetOrdinal(String)

Declaration
public int GetOrdinal(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
System.Int32

GetSchemaTable()

Declaration
public DataTable GetSchemaTable()
Returns
Type Description
System.Data.DataTable

GetString(Int32)

Declaration
public string GetString(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.String

GetValue(Int32)

Declaration
public object GetValue(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Object

GetValues(Object[])

Declaration
public int GetValues(object[] values)
Parameters
Type Name Description
System.Object[] values
Returns
Type Description
System.Int32

IsDBNull(Int32)

Declaration
public bool IsDBNull(int i)
Parameters
Type Name Description
System.Int32 i
Returns
Type Description
System.Boolean

NextResult()

Declaration
public bool NextResult()
Returns
Type Description
System.Boolean

Read()

Declaration
public bool Read()
Returns
Type Description
System.Boolean

Implements

ITableData
System.Data.IDataReader
System.Data.IDataRecord
System.IDisposable
Back to top Crafted with <3 in Berlin
Contact & legal notice