Class BulkOptionsShared<T>

Inheritance

object

BulkOptionsShared<T>

BulkOptions<T>

MergeBulkOptions<T>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.DbExtensions

Assembly: ETLBox.DbExtensions.dll

Syntax

{{< /rawhtml >}} ```C# public abstract class BulkOptionsShared ``` {{< rawhtml >}}

Type Parameters

Name	Description
T

Properties

AllowIdentityInsert

Enables identity insert for the operation - this will override existing values in identity / auto-increment / serial columns.

Declaration

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

Property Value

Type	Description
bool

BatchSize

The number of records to be processed in a single batch.

Declaration

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

Property Value

Type	Description
int

ColumnConverters

Allows custom conversions for specific columns.

Declaration

{{< /rawhtml >}} ```C# public ICollection ColumnConverters { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<ColumnConverter>

ColumnMapping

You can specify mapping between the property names of your input data and the database columns. You can also specifiy here if you want to ignore particular properties/columns during the operation.

Declaration

{{< /rawhtml >}} ```C# public ICollection ColumnMapping { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<DbColumnMap>

ErrorData

Contains erroneous data. RedirectErroneousBatches must be set to true.

Declaration

{{< /rawhtml >}} ```C# public ICollection ErrorData { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<ETLBoxError>

IdColumns

You can specify the columns that are used to identify a row in the database. This is only relevant for update/delete/merge operations.

Declaration

{{< /rawhtml >}} ```C# public ICollection IdColumns { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<IdColumn>

IgnoreDefaultColumnsOnInsert

When inserting data, columns that have a DEFAULT constraint are ignored.

Declaration

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

Property Value

Type	Description
bool

OnProgress

Action is invoked for every processed batch.

Declaration

{{< /rawhtml >}} ```C# public Action OnProgress { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
Action<int>

ReadGeneratedValues

Indicates whether to read back generated values like auto-incremented IDs. This will only work for databases that support this feature.

Declaration

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

Property Value

Type	Description
bool

RedirectErroneousBatches

Indicates whether to redirect erroneous batches.
By default an exception is thrown when a batch can't be inserted into a database, and the bulk operation is stopped. Setting this to true won't stop execution when a batch can't be processed. ErrorData will hold details about flawed batch.

Declaration

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

Property Value

Type	Description
bool

TableName

By default, the table name is the type/class name of the data (or the type/class name + 's'). Assign a value if you want to specify a specific table name.

Declaration

{{< /rawhtml >}} ```C# public string TableName { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

TablePrefix

By default, the table name is either the type/class name of the data (or the type/class name + 's'). Set this value if you want to have a prefix added to this default.

Declaration

{{< /rawhtml >}} ```C# public string TablePrefix { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

TableSuffix

By default, the table name is either the type/class name of the data (or the type/class name + 's'). Set this value if you want to have a suffix added to this default.

Declaration

{{< /rawhtml >}} ```C# public string TableSuffix { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string