Class SqlBulkOperations

Namespace: redb.MSSql.Data
Assembly: redb.MSSql.dll

MS SQL Server implementation of IBulkOperations using SqlBulkCopy.
Much faster than individual INSERTs for large datasets.

public class SqlBulkOperations : IBulkOperations

Inheritance

Object→SqlBulkOperations

Implements

IBulkOperations

Methods

BulkDeleteObjectsAsync(IEnumerable<long>)

Bulk delete objects by IDs.

public Task BulkDeleteObjectsAsync(IEnumerable<long> objectIds)

BulkDeleteValuesAsync(IEnumerable<long>)

Bulk delete values by IDs.

public Task BulkDeleteValuesAsync(IEnumerable<long> valueIds)

BulkDeleteValuesByListItemIdsAsync(IEnumerable<long>)

Bulk delete values by ListItem IDs.

public Task BulkDeleteValuesByListItemIdsAsync(IEnumerable<long> listItemIds)

BulkDeleteValuesByObjectIdsAsync(IEnumerable<long>)

Bulk delete values by object IDs.

public Task BulkDeleteValuesByObjectIdsAsync(IEnumerable<long> objectIds)

BulkInsertObjectsAsync(IEnumerable<RedbObjectRow>)

Bulk insert objects using SqlBulkCopy.

public Task BulkInsertObjectsAsync(IEnumerable<RedbObjectRow> objects)

BulkInsertValuesAsync(IEnumerable<RedbValue>)

Bulk insert values using SqlBulkCopy.

public Task BulkInsertValuesAsync(IEnumerable<RedbValue> values)

BulkUpdateObjectsAsync(IEnumerable<RedbObjectRow>)

Bulk update objects using MERGE statement.

public Task BulkUpdateObjectsAsync(IEnumerable<RedbObjectRow> objects)

BulkUpdateValuesAsync(IEnumerable<RedbValue>)

Bulk update values using MERGE statement.

public Task BulkUpdateValuesAsync(IEnumerable<RedbValue> values)

Constructors

SqlBulkOperations(IRedbConnection)

Create bulk operations handler.