Class DbSource
A database source defines either a table or sql query that returns data from a database. Multiple database are supported. Use the corresponding connection manager that fits to your database.
Inheritance
DbSource
Implements
Inherited Members
Namespace: ETLBox.DataFlow
Assembly: ETLBox.dll
Syntax
public class DbSource : DbSource<ExpandoObject>, IDataFlowExecutableSource<ExpandoObject>, IDataFlowSource<ExpandoObject>, IDataFlowExecutableSource, IDataFlowSource, IDataFlowComponent, ILoggableTaskExamples
SqlConnectionManager connMan = new SqlConnectionManager("Data Source=localhost");
DbSource<MyRow> source = new DbSource<MyRow>(connMan, "dbo.table");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 | |
| string | tableName |
DbSource(string)
Declaration
public DbSource(string tableName)Parameters
| Type | Name | Description |
|---|---|---|
| string | tableName |