Class Settings

Contains static information which affects all Dataflow tasks in ETLBox. Here you can set the threshold value when information about processed records should appear.

Inheritance
Settings
Namespace: ETLBox
Assembly: ETLBox.dll
Syntax
    public static class Settings

Fields

DEFAULT_LOG_THRESHOLD

The default value for LogThreshold

Declaration
    public const int DEFAULT_LOG_THRESHOLD = 1000
Field Value
TypeDescription
int

DEFAULT_MAX_BUFFER_SIZE

The default value for MaxBufferSize

Declaration
    public const int DEFAULT_MAX_BUFFER_SIZE = 100000
Field Value
TypeDescription
int

Properties

AdditionalScope

Declaration
    public static Dictionary<string, object> AdditionalScope { get; set; }
Property Value
TypeDescription
Dictionary<string, object>

AllowMultipleExecutions

If set to false, components in a network can only be executed once. The recommendation is to set this property to false, as reusing components in the same or different networks may lead to unexpected results (and possible side effects to existing data). But to avoid unexpected behavior, this property is set to true by default.

Declaration
    public static bool AllowMultipleExecutions { get; set; }
Property Value
TypeDescription
bool

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
TypeDescription
IConnectionManager

DisableAllLogging

If set to true, no log messages will be produced for all components. Logging can be enabled/disabled for all components individually using the DisableLogging property on each component.

Declaration
    public static bool DisableAllLogging { get; set; }
Property Value
TypeDescription
bool

LogInstance

An ILogger instance which is used by all components, unless there is a specific logger instance set for a component individually. If the component has no logger instance set, and the LogInstance is null, no logging will be performed.

Declaration
    public static ILogger LogInstance { get; set; }
Property Value
TypeDescription
ILogger

LogThreshold

To avoid getting a log message for every row, by default only a log message is generated every 1000 rows. Setting this property will decrease or increase this default value for all dataflow components. The individual log threshold can be overwritten in each component separately.

Declaration
    public static int? LogThreshold { get; set; }
Property Value
TypeDescription
int?

MaxBufferSize

The default maximum size for all buffers in the dataflow. This is the default value. Each maximum buffer size value can overwritten in a dataflow component seperately.

Declaration
    public static int MaxBufferSize { get; set; }
Property Value
TypeDescription
int

Methods

ClearSettings()

Set all settings back to default values.

Declaration
    public static void ClearSettings()