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