Settings
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.
Inherited Members
Namespace: ETLBox
Assembly: ETLBox.dll
Syntax
public static class SettingsFields
DEFAULT_LOG_THRESHOLD
The default value for LogThreshold
Declaration
public const int DEFAULT_LOG_THRESHOLD = 1000Field Value
| Type | Description |
|---|---|
| int |
DEFAULT_MAX_BUFFER_SIZE
The default value for MaxBufferSize
Declaration
public const int DEFAULT_MAX_BUFFER_SIZE = 100000Field Value
| Type | Description |
|---|---|
| int |
Properties
AdditionalScope
Declaration
public static Dictionary<string, object> AdditionalScope { get; set; }Property Value
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| int |
SetLogLevelInfoToDebug
If set to true, all ETLBox log message that are targeted for INFO will be logged as DEBUG.
Declaration
public static bool SetLogLevelInfoToDebug { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Methods
ClearSettings()
Set all settings back to default values.
Declaration
public static void ClearSettings()