Class TableData
Defines a list of rows that can be inserted into a table
Inheritance
System.Object
TableData
Implements
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 : ITableData, IDataReader, IDataRecord, IDisposable
Constructors
TableData(TableDefinition)#
Declaration
public TableData(TableDefinition definition)
Parameters
TableData(TableDefinition, Int32)#
Declaration
public TableData(TableDefinition definition, int estimatedBatchSize)
Parameters
Properties
AllowIdentityInsert#
If set to true, values in an indentity column are overwriten with the provided values
Declaration
public bool AllowIdentityInsert { get; set; }
Property Value
Type | Description |
---|
System.Boolean | |
ColumnConverters#
Declaration
public Dictionary<string, Func<object, object>> ColumnConverters { get; set; }
Property Value
Type | Description |
---|
System.Collections.Generic.Dictionary<System.String, System.Func<System.Object, System.Object>> | |
ColumnMapping#
Declaration
public IColumnMappingCollection ColumnMapping { get; }
Property Value
Type | Description |
---|
System.Data.IColumnMappingCollection | |
CurrentRow#
The row that is currently processed when accessing the data reader
Declaration
public object[] CurrentRow { get; }
Property Value
Type | Description |
---|
System.Object[] | |
DataIndexForColumn#
Resolves the index number for a column name
Declaration
public Dictionary<string, int> DataIndexForColumn { get; set; }
Property Value
Type | Description |
---|
System.Collections.Generic.Dictionary<System.String, System.Int32> | |
Definition#
Definition of the destination table
Declaration
public TableDefinition Definition { get; set; }
Property Value
Depth#
Declaration
public int Depth { get; }
Property Value
Type | Description |
---|
System.Int32 | |
DestinationTableName#
The name of the destination table
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#
The row index of the current row
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
Close()#
Declaration
Dispose()#
Declaration
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)#
Resolves the data type name for a column
Declaration
public string GetDataTypeName(string columnName)
Parameters
Type | Name | Description |
---|
System.String | columnName | Column name |
Returns
Type | Description |
---|
System.String | Data type name |
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
Returns
Type | Description |
---|
System.Boolean | |
Read()#
Declaration
Returns
Type | Description |
---|
System.Boolean | |
Implements#
System.Data.IDataReader
System.Data.IDataRecord
System.IDisposable