# BulkOperations {{< rawhtml >}}

Class BulkOperations

Base class that is used for creating ETLBox bulk operations.

Inheritance
object
BulkOperations
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 class BulkOperations ``` {{< rawhtml >}}

Constructors

BulkOperations()

Declaration
{{< /rawhtml >}} ```C# public BulkOperations() ``` {{< rawhtml >}}

BulkOperations(IConnectionManager)

Declaration
{{< /rawhtml >}} ```C# public BulkOperations(IConnectionManager connectionManager) ``` {{< rawhtml >}}
Parameters
Type Name Description
IConnectionManager connectionManager

Properties

ConnectionManager

An ETLBox IConnectionManager used to wrap the current ADO.NET connection manager.

Declaration
{{< /rawhtml >}} ```C# public IConnectionManager ConnectionManager { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
IConnectionManager

Methods

BulkDelete<T>(IEnumerable<T>)

Let you delete a large number of records in your database by utilizing bulk delete sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkDelete(IEnumerable newRecords) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for deletion.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkDelete<T>(IEnumerable<T>, Action<BulkOptions<T>>)

Let you delete a large number of records in your database by utilizing bulk delete sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkDelete(IEnumerable newRecords, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for deletion.
Action<BulkOptions<T>> options

Configurable options for the bulk operation.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkInsert<T>(IEnumerable<T>)

Let you insert a large number of records in your database by utilizing bulk insert sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkInsert(IEnumerable newRecords) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for insertion.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkInsert<T>(IEnumerable<T>, Action<BulkOptions<T>>)

Let you insert a large number of records in your database by utilizing bulk insert sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkInsert(IEnumerable newRecords, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for insertion.
Action<BulkOptions<T>> options

Configurable options for the bulk operation.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkMerge<T>(IEnumerable<T>)

Let you merge a large number of records in your database by utilizing bulk sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkMerge(IEnumerable newRecords) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for syncing.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkMerge<T>(IEnumerable<T>, Action<MergeBulkOptions<T>>)

Let you merge a large number of records in your database by utilizing bulk sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkMerge(IEnumerable newRecords, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for syncing.
Action<MergeBulkOptions<T>> options

Configurable options for the bulk operation.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkUpdate<T>(IEnumerable<T>)

Let you update a large number of records in your database by utilizing bulk update sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkUpdate(IEnumerable newRecords) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for updating.
Type Parameters
Name Description
T

Data type used for the bulk operation.

BulkUpdate<T>(IEnumerable<T>, Action<BulkOptions<T>>)

Let you update a large number of records in your database by utilizing bulk update sql.

Declaration
{{< /rawhtml >}} ```C# public void BulkUpdate(IEnumerable newRecords, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IEnumerable<T> newRecords

List containing the records for updating.
Action<BulkOptions<T>> options

Configurable options for the bulk operation.
Type Parameters
Name Description
T

Data type used for the bulk operation.
{{< /rawhtml >}}