DB Extensions
Class BulkOperations
Base class that is used for creating ETLBox bulk operations.
Inherited Members
Namespace: ETLBox.DbExtensions
Assembly: ETLBox.DbExtensions.dll
Syntax
public class BulkOperationsConstructors
BulkOperations()
Declaration
public BulkOperations()BulkOperations(IConnectionManager)
Declaration
public BulkOperations(IConnectionManager connectionManager)Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connectionManager |
Properties
ConnectionManager
An ETLBox IConnectionManager used to wrap the current ADO.NET connection manager.
Declaration
public IConnectionManager ConnectionManager { get; set; }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
public void BulkDelete<T>(IEnumerable<T> newRecords)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
public void BulkDelete<T>(IEnumerable<T> newRecords, Action<BulkOptions<T>> options)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
public void BulkInsert<T>(IEnumerable<T> newRecords)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
public void BulkInsert<T>(IEnumerable<T> newRecords, Action<BulkOptions<T>> options)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
public void BulkMerge<T>(IEnumerable<T> newRecords)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
public void BulkMerge<T>(IEnumerable<T> newRecords, Action<MergeBulkOptions<T>> options)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
public void BulkUpdate<T>(IEnumerable<T> newRecords)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
public void BulkUpdate<T>(IEnumerable<T> newRecords, Action<BulkOptions<T>> options)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. |