Class DbSource<TOutput>

A database source defines either a table or sql query that returns data from a database. While reading the result set or the table, data is asnychronously posted into the targets.

Inheritance
System.Object
GenericTask
DataFlowTask
DataFlowSource<TOutput>
DbSource<TOutput>
DbSource
Implements
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.DataFlow.Connectors
Assembly: ETLBox.dll
Syntax
public class DbSource<TOutput> : DataFlowSource<TOutput>, ITask, IDataFlowSource<TOutput>, IDataFlowLinkSource<TOutput>
Type Parameters
Name Description
TOutput

Type of data output.
Examples
DbSource<MyRow> source = new DbSource<MyRow>("dbo.table");
source.LinkTo(dest); //Transformation or Destination
source.Execute(); //Start the data flow

Constructors

DbSource()

Declaration
public DbSource()

DbSource(IConnectionManager)

Declaration
public DbSource(IConnectionManager connectionManager)
Parameters
Type Name Description
IConnectionManager connectionManager

DbSource(IConnectionManager, String)

Declaration
public DbSource(IConnectionManager connectionManager, string tableName)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName

DbSource(String)

Declaration
public DbSource(string tableName)
Parameters
Type Name Description
System.String tableName

Properties

ColumnNames

Declaration
public List<string> ColumnNames { get; set; }
Property Value
Type Description
System.Collections.Generic.List<System.String>

ColumnNamesEvaluated

Declaration
public List<string> ColumnNamesEvaluated { get; }
Property Value
Type Description
System.Collections.Generic.List<System.String>

SourceTableDefinition

Declaration
public TableDefinition SourceTableDefinition { get; set; }
Property Value
Type Description
TableDefinition

Sql

Declaration
public string Sql { get; set; }
Property Value
Type Description
System.String

SqlForRead

Declaration
public string SqlForRead { get; }
Property Value
Type Description
System.String

TableName

Declaration
public string TableName { get; set; }
Property Value
Type Description
System.String

TaskName

Declaration
public override string TaskName { get; }
Property Value
Type Description
System.String
Overrides

Methods

Execute()

Declaration
public override void Execute()
Overrides
ETLBox.DataFlow.DataFlowSource<TOutput>.Execute()

Implements