# IDbConnectionExtensions {{< rawhtml >}}

Class IDbConnectionExtensions

Extension methods that add bulk insert, update, delete, and merge operations to IDbConnection.

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

Methods

BulkDelete<T>(IDbConnection, IEnumerable<T>)

Performs a bulk delete operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkDelete(this IDbConnection connection, IEnumerable data) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be deleted.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

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

Performs a bulk delete operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkDelete(this IDbConnection connection, IEnumerable data, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be deleted.
Action<BulkOptions<T>> options

The configurable options for the bulk delete operation.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

BulkInsert<T>(IDbConnection, IEnumerable<T>)

Performs a bulk insert operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkInsert(this IDbConnection connection, IEnumerable data) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be inserted.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

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

Performs a bulk insert operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkInsert(this IDbConnection connection, IEnumerable data, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be inserted.
Action<BulkOptions<T>> options

The configurable options for the bulk insert operation.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

BulkMerge<T>(IDbConnection, IEnumerable<T>)

Performs a merge operation on the specified database connection. The merge operation is a combination of insert, update, and delete operations. By default, the merge operates in Full mode, which tries to delete rows in the target table that don't exist in the source data.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkMerge(this IDbConnection connection, IEnumerable data) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be merged.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

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

Performs a merge operation on the specified database connection. The merge operation is a combination of insert, update, and delete operations. By default, the merge operates in Full mode, which tries to delete rows in the target table that don't exist in the source data.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkMerge(this IDbConnection connection, IEnumerable data, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be merged.
Action<MergeBulkOptions<T>> options

The configurable options for the bulk merge operation.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

BulkUpdate<T>(IDbConnection, IEnumerable<T>)

Performs a bulk update operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkUpdate(this IDbConnection connection, IEnumerable data) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be updated.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

The data type used for the bulk operation.

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

Performs a bulk update operation on the specified database connection.

Declaration
{{< /rawhtml >}} ```C# public static IDbConnection BulkUpdate(this IDbConnection connection, IEnumerable data, Action> options) ``` {{< rawhtml >}}
Parameters
Type Name Description
IDbConnection connection

The database connection.
IEnumerable<T> data

The data to be updated.
Action<BulkOptions<T>> options

The configurable options for the bulk update operation.
Returns
Type Description
IDbConnection

The database connection after execution.
Type Parameters
Name Description
T

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