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

object

Settings

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public static class Settings ``` {{< rawhtml >}}

Fields

DEFAULT_LOG_THRESHOLD

The default value for LogThreshold

Declaration

{{< /rawhtml >}} ```C# public const int DEFAULT_LOG_THRESHOLD = 1000 ``` {{< rawhtml >}}

Field Value

Type	Description
int

DEFAULT_MAX_BUFFER_SIZE

The default value for MaxBufferSize

Declaration

{{< /rawhtml >}} ```C# public const int DEFAULT_MAX_BUFFER_SIZE = 30000 ``` {{< rawhtml >}}

Field Value

Type	Description
int

Properties

AdditionalScope

Declaration

{{< /rawhtml >}} ```C# public static Dictionary AdditionalScope { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static bool AllowMultipleExecutions { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

CloneSettings

The default settings for the CloneBox library, which is used for cloning objects in ETLBox. Objects are cloned in components like Multicast or Merge.

Declaration

{{< /rawhtml >}} ```C# public static CloneSettings CloneSettings { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
CloneSettings

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

{{< /rawhtml >}} ```C# public static IConnectionManager DefaultDbConnection { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static bool DisableAllLogging { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static ILogger LogInstance { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static int? LogThreshold { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static int MaxBufferSize { get; set; } ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static bool SetLogLevelInfoToDebug { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Methods

ClearSettings()

Set all settings back to default values.

Declaration

{{< /rawhtml >}} ```C# public static void ClearSettings() ``` {{< rawhtml >}} {{< /rawhtml >}}