Namespace ETLBox.DataFlow
Classes
AggregateColumn
This attribute is used to identify the aggregation property for aggregations. The passed column name identifies the property in the aggregation output object.
ColumnMap
This attribute defines a column name to which the value of the property is mapped when writing or reading from a database. By default, when reading from a database source the mapping which property stores data of which column is resolved by the property names. Using this attribute, you can specify the column name that maps to a propety.
CompareColumn
This attribute defines if the column is included in the comparison to identify object that exists and needs to be updated. It it supposed to use with an object that either inherits from MergeableRow. If you implement the IMergeable interface, you need to override the Equals-method instead.
DataFlow
Contains static information which affects all Dataflow tasks in ETLBox. Here you can set the threshold value when information about processed records should appear.
DataFlowBatchDestination<TInput>
DataFlowDestination<TInput>
DataFlowSource<TOutput>
DataFlowStreamDestination<TInput>
DataFlowStreamSource<TOutput>
DataFlowTask
DataFlowTransformation<TInput, TOutput>
DeleteColumn
This attribute defines if the column is used to identify if the record is supposed to be deleted. If this attribute is set and the given value matches the column of the assigned property, the DbMerge will know that if the records matches (identifed by the IdColumn attribute) it should be deleted.
ErrorHandler
ETLBoxError
The generic ETLBox Exception. See inner exception for more details.
ExcelColumn
This attribute defines either which column index is mapped to the property or the header name that identifies the column By default, when reading from an excel file, a header column is expected in the first row. The name of the header is used to match with the property names of the object. With this attribute, you can define the column index of the excel column for the property or a different header name for a property. The index starts at 0.
ExcelRange
GroupColumn
This attribute is used to identify the grouping property for aggregations. The passed column name identifies the property in the aggregation output object.
IdColumn
This attribute defines if the column is used as an Id for the DBMerge. It it supposed to use with an object that either inherits from MergeableRow or implements the IMergeable interface. If you do not provide this attribute, you need to override the UniqueId property if you inherit from MergeableRow.
MatchColumn
This attribute defines that this property is used to match with the property of the object used in the Source for a Lookup identified by the given lookupSourcePropertyName.
MergeableRow
Inherit from this class if you want to use your data object with a DBMerge, but don't want to implement IMergeableRow yourself. You still needs that you have flagged the id properties with the IdColumn attribute and the properties use to identify equal object flagged with the CompareColumn attribute.
MergeProperties
RetrieveColumn
This attribute defines that this property is used to store the lookup value of the property from the object used in the Source for a Lookup identified by the given lookupSourcePropertyName.
TypeInfo
Interfaces
IDataFlowBatchDestination<TInput>
IDataFlowDestination<TInput>
IDataFlowLinkSource<TOutput>
IDataFlowLinkTarget<TInput>
IDataFlowSource<TOutput>
IDataFlowTransformation<TInput, TOutput>
IMergeableRow
Represents table row in destination database for