Class DbDestination<TInput>
A DbDestination represents a database table where ingoing data from the flow is written into. Inserts are done in batches (using Bulk insert or an equivalent INSERT statement).
Inherited Members
Namespace: ETLBox.DataFlow.Connectors
Assembly: ETLBox.dll
Syntax
public class DbDestination<TInput> : DataFlowBatchDestination<TInput>, ILoggableTask, IDataFlowLogging, IDataFlowBatchDestination<TInput>, IDataFlowBatchDestination, IDataFlowDestination<TInput>, IDataFlowDestination, IDataFlowComponent
Type Parameters
Name | Description |
---|---|
TInput | Data type for ingoing data, preferably representing the data type for the destination table. |
Constructors
DbDestination()
Declaration
public DbDestination()
DbDestination(IConnectionManager, String)
Declaration
public DbDestination(IConnectionManager connectionManager, string tableName)
Parameters
Type | Name | Description |
---|---|---|
IConnectionManager | connectionManager | Sets the ConnectionManager |
System.String | tableName | Sets the TableName |
DbDestination(IConnectionManager, String, Int32)
Declaration
public DbDestination(IConnectionManager connectionManager, string tableName, int batchSize)
Parameters
Type | Name | Description |
---|---|---|
IConnectionManager | connectionManager | Sets the ConnectionManager |
System.String | tableName | Sets the TableName |
System.Int32 | batchSize | Sets the BatchSize |
DbDestination(String)
Declaration
public DbDestination(string tableName)
Parameters
Type | Name | Description |
---|---|---|
System.String | tableName | Sets the TableName |
DbDestination(String, Int32)
Declaration
public DbDestination(string tableName, int batchSize)
Parameters
Type | Name | Description |
---|---|---|
System.String | tableName | Sets the TableName |
System.Int32 | batchSize | Sets the BatchSize |
Fields
DEFAULT_BATCH_SIZE_ODBC_OLEDB
Declaration
public const int DEFAULT_BATCH_SIZE_ODBC_OLEDB = 100
Field Value
Type | Description |
---|---|
System.Int32 |
Properties
BulkInsertConnectionManager
The connection manager used for the bulk inserts. This is a copy of the provided connection manager.
Declaration
public IConnectionManager BulkInsertConnectionManager { get; protected set; }
Property Value
Type | Description |
---|---|
IConnectionManager |
ColumnMapping
Declaration
public IEnumerable<ColumnMap> ColumnMapping { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.IEnumerable<ColumnMap> |
ConnectionManager
The connection manager used to connect to the database - use the right connection manager for your database type.
Declaration
public virtual IConnectionManager ConnectionManager { get; set; }
Property Value
Type | Description |
---|---|
IConnectionManager |
DestinationTableDefinition
The table definition of the destination table. By default, the table definition is read from the database. Provide a table definition if the definition of the target can't be read automatically or you want the DbDestination only to use the columns in the provided definition.
Declaration
public TableDefinition DestinationTableDefinition { get; set; }
Property Value
Type | Description |
---|---|
TableDefinition |
TableName
Name of the database table that receives the data from the data flow.
Declaration
public string TableName { get; set; }
Property Value
Type | Description |
---|---|
System.String |
TaskName
A name to identify the task or component. Every component or task comes with a default name that can be overwritten.
Declaration
public override string TaskName { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Overrides
Methods
BulkInsertData(TInput[])
Declaration
protected override void BulkInsertData(TInput[] data)
Parameters
Type | Name | Description |
---|---|---|
TInput[] | data |
Overrides
CheckParameter()
Declaration
protected override void CheckParameter()
Overrides
FinishWrite()
Declaration
protected override void FinishWrite()
Overrides
PrepareWrite()
Declaration
protected override void PrepareWrite()