Interface ITableData
A list of rows and a column mapping ready for bulk insert
Inherited Members
Namespace: ETLBox
Assembly: ETLBox.dll
Syntax
{{< /rawhtml >}} ```C# public interface ITableData : IDataReader, IDataRecord, IDisposable ``` {{< rawhtml >}}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
{{< /rawhtml >}} ```C# bool AllowIdentityInsert { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| bool |
ColumnMapping
The column mapping
Declaration
{{< /rawhtml >}} ```C# IColumnMappingCollection ColumnMapping { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| IColumnMappingCollection |
CurrentRow
The row that is currently processed when accessing the data reader
Declaration
{{< /rawhtml >}} ```C# object[] CurrentRow { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| object[] |
DataIndexForColumn
Resolves the index number for a column name
Declaration
{{< /rawhtml >}} ```C# DictionaryProperty Value
| Type | Description |
|---|---|
| Dictionary<string, int> |
Definition
Definition of the destination table
Declaration
{{< /rawhtml >}} ```C# TableDefinition Definition { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| TableDefinition |
DestinationTableName
The name of the destination table
Declaration
{{< /rawhtml >}} ```C# string DestinationTableName { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| string |
KeepIdentity
By default, identity columns are included. If set to false, identity columns will be ignored
Declaration
{{< /rawhtml >}} ```C# bool KeepIdentity { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| bool |
ReadIndex
The row index of the current row
Declaration
{{< /rawhtml >}} ```C# int ReadIndex { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| int |
Rows
Rows/Columns ready for bulk insert
Declaration
{{< /rawhtml >}} ```C# ListProperty Value
| Type | Description |
|---|---|
| List<object[]> |
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
{{< /rawhtml >}} ```C# SortedListProperty Value
| Type | Description |
|---|---|
| SortedList<int, object[]> |
ValueGeneratedColumnNames
A collection of all column names that are value generated columns (e.g. columns with a COMPUTED or DEFAULT value)
Declaration
{{< /rawhtml >}} ```C# ICollectionProperty Value
| Type | Description |
|---|---|
| ICollection<string> |
Methods
AddSequenceColumn(string)
Allows to name a column that is specifically used as a sequence column. The column will then be treated differently.
Declaration
{{< /rawhtml >}} ```C# void AddSequenceColumn(string columnName) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| string | columnName |
GetDataTypeName(string)
Resolves the data type name for a column
Declaration
{{< /rawhtml >}} ```C# string GetDataTypeName(string columnName) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| string | columnName | Column name |
Returns
| Type | Description |
|---|---|
| string | Data type name |
GetTableColumn(string)
Resolves the column in the table definition
Declaration
{{< /rawhtml >}} ```C# TableColumn GetTableColumn(string columnName) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| string | columnName | Column name |
Returns
| Type | Description |
|---|---|
| TableColumn |
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
{{< /rawhtml >}} ```C# void RewindReadIndex(int position) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| int | position |