Class TableData<T>
Defines a list of rows that can be inserted into a table
Inheritance
System.Object
TableData<T>
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()
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
TableData(TableDefinition, Int32)
Declaration
public TableData(TableDefinition definition, int estimatedBatchSize)
Parameters
Type |
Name |
Description |
TableDefinition |
definition |
|
System.Int32 |
estimatedBatchSize |
|
Properties
ColumnMapping
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
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)
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
Returns
Type |
Description |
System.Boolean |
|
Read()
Declaration
Returns
Type |
Description |
System.Boolean |
|
Implements
System.Data.IDataReader
System.Data.IDataRecord
System.IDisposable