Class ControlFlow

Contains static information which affects all ETLBox tasks. Here you can set default connections string, disbale the logging for all processes or set the current stage used in your logging configuration.

Inheritance

System.Object

ControlFlow

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.ControlFlow

Assembly: ETLBox.dll

Syntax

public static class ControlFlow

Fields

DEFAULTLOADPROCESSTABLENAME

Declaration

public const string DEFAULTLOADPROCESSTABLENAME = "etlbox_loadprocess"

Field Value

Type	Description
System.String

DEFAULTLOGTABLENAME

Declaration

public const string DEFAULTLOGTABLENAME = "etlbox_log"

Field Value

Type	Description
System.String

Properties

CurrentLoadProcess

If you used the logging task StartLoadProces (and created the corresponding load process table before) then this Property will hold the current load process information.

Declaration

public static LoadProcess CurrentLoadProcess { get; }

Property Value

Type	Description
LoadProcess

DefaultDbConnection

You can store your general database connection string here. This connection will then used by all Tasks where no DB connection is excplicitly set.

Declaration

public static IConnectionManager DefaultDbConnection { get; set; }

Property Value

Type	Description
IConnectionManager

DisableAllLogging

If set to true, nothing will be logged by any control flow task or data flow component. When switched back to false, all tasks and components will continue to log.

Declaration

public static bool DisableAllLogging { get; set; }

Property Value

Type	Description
System.Boolean

LoadProcessTable

TableName of the current load process logging table

Declaration

public static string LoadProcessTable { get; set; }

Property Value

Type	Description
System.String

LogTable

TableName of the current log process logging table

Declaration

public static string LogTable { get; set; }

Property Value

Type	Description
System.String

STAGE

For logging purposes only. If the stage is set, you can access the stage value in the logging configuration.

Declaration

public static string STAGE { get; set; }

Property Value

Type	Description
System.String

Methods

AddLoggingDatabaseToConfig(IConnectionManager)

Declaration

public static void AddLoggingDatabaseToConfig(IConnectionManager connection)

Parameters

Type	Name	Description
IConnectionManager	connection

AddLoggingDatabaseToConfig(IConnectionManager, LogLevel, String)

You can also set the logging database in the nlog.config file. If you want to programmatically change the logging database, use this method.

Declaration

public static void AddLoggingDatabaseToConfig(IConnectionManager connection, LogLevel minLogLevel, string logTableName = "etlbox_log")

Parameters

Type	Name	Description
IConnectionManager	connection	The new logging database connection manager
NLog.LogLevel	minLogLevel
System.String	logTableName

ClearSettings()

Set all settings back to default (which is null or false)

Declaration

public static void ClearSettings()

GetLogger()

Declaration

public static Logger GetLogger()

Returns

Type	Description
NLog.Logger