Dapper Plus Mapper allow to map the conceptual model (Entity) with the storage model (Database) and configure options to perform Bulk Actions. An entity can be mapped more than once using a MappingKey.

Map

Definition

Dapper Plus Mapper allows mapping the conceptual model (Entity) with the storage model (Database).

Name	Description
Identity	Sets column(s) which the database generates value. The value is outputted from the destination table (insert and merge action).
Ignore	Sets column(s) to ignore.
Key	Sets column(s) to use for Primary Key (update, delete, and merge action).
Map	Sets column(s) to input to the destination table.
MapValue	Sets value to map to the destination table.
Output	Sets column(s) to output from the destination table (insert, update, and merge action).
Table	Sets the destination table or view name (including schema).

Mapper - Identity

Sets column(s) which the database generates value. The value is outputted from the destination table (insert and merge action).

Mapper - Ignore

Sets column(s) to ignore.

Mapper - Key

Sets column(s) to use for Primary Key (update, delete, and merge action).

Mapper - Map

Sets column(s) to input to the destination table.

Map with an anonymous type. Sets the property name only if different from the database.

Mapper - MapValue

Sets value to map to the destination table.

Mapper - Output

Sets column(s) to output from the destination table (insert, update, and merge action).

Mapper - Table

Sets the destination table or view name (including schema). By default, the name mapped is singular.

Bulk Actions

Bulk Actions allow to perform a bulk insert, update, delete or merge and include related child items.

Bulk Insert

Description

The Dapper Plus BulkInsert extension method lets you insert a large number of entities in your database.

Performance Comparison

Operations	1,000 Entities	2,000 Entities	5,000 Entities
Execute (Many)	1,200 ms	2,400 ms	6,000 ms
BulkInsert	50 ms	55 ms	75 ms

HINT: A lot of factors might affect the benchmark time such as index, column type, latency, throttling, etc.

Bulk Insert Entity

The Dapper Plus BulkInsert method allows inserting a single or multiple entities of the same type.

Bulk Insert IEnumerable

The Dapper Plus BulkInsert method allows inserting a single enumerable or multiple enumerable of entities of the same type.

Bulk Insert with "One to One" Relation

The Dapper Plus BulkInsert method allows inserting a related item with a "One to One" relation.

Bulk Insert with "One to Many" Relation

The Dapper Plus BulkInsert method allow inserting related items with a "One to Many" relation.

Bulk Insert with "Mixed" Relation

The Dapper Plus BulkInsert method allows inserting related item(s) with any relation.

Bulk Insert Chain Action

The Dapper Plus BulkInsert method allows chaining multiple bulk action methods.

Bulk Update

Definition

The Dapper Plus BulkUpdate method allows to UPDATE entities in a database table or a view.

Bulk Update Entity

The Dapper Plus BulkUpdate method allows updating a single or multiple entities of the same type.

Bulk Update IEnumerable

The Dapper Plus BulkUpdate method allows updating a single enumerable or multiple enumerable of entities of the same type.

Bulk Update with "One to One" Relation

The Dapper Plus BulkUpdate method allows updating a related item with a "One to One" relation.

Bulk Update with "One to Many" Relation

The Dapper Plus BulkUpdate method allows updating related items with a "One to Many" relation.

Bulk Update with "Mixed" Relation

The Dapper Plus BulkUpdate method allows updating related item(s) with any relation.

Bulk Update Chain Action

The Dapper Plus BulkUpdate method allows chaining multiple bulk action methods.

Bulk Delete

Definition

The Dapper Plus BulkDelete method allows to DELETE entities in a database table or a view.

Bulk Delete Entity

The Dapper Plus BulkDelete method allows deleting a single or multiple entities of the same type.

Bulk Delete IEnumerable

The Dapper Plus BulkDelete method allows deleting a single enumerable or multiple enumerable of entities of the same type.

Bulk Delete with "One to One" Relation

The Dapper Plus BulkDelete method allows deleting a related item with a "One to One" relation.

Bulk Delete with "One to Many" Relation

The Dapper Plus BulkDelete method allows deleting related items with a "One to Many" relation.

Bulk Delete with "Mixed" Relation

The Dapper Plus BulkDelete method allows deleting related item(s) with any relation.

Bulk Delete Chain Action

The Dapper Plus BulkDelete method allows chaining multiple bulk action methods.

Bulk Merge

Definition

The Dapper Plus BulkMerge method allows to MERGE entities in a database table or a view.

Bulk Merge Entity

The Dapper Plus BulkMerge method allows merging a single or multiple entities of the same type.

Bulk Merge IEnumerable

The Dapper Plus BulkMerge method allows merging a single enumerable or multiple enumerable of entities of the same type.

Bulk Merge with "One to One" Relation

The Dapper Plus BulkMerge method allows merging a related item with a "One to One" relation.

Bulk Merge with "One to Many" Relation

The Dapper Plus BulkMerge method allows merging related items with a "One to Many" relation.

Bulk Merge with "Mixed" Relation

The Dapper Plus BulkMerge method allows merging related item(s) with any relation.

Bulk Merge Chain Action

The Dapper Plus BulkMerge method allows chaining multiple bulk action methods.

Also Bulk Actions

Also Bulk Actions allow to perform bulk action with a lambda expression using entities from the last Bulk[Action] or ThenBulk[Action] used.

Also Bulk Insert

Definition

The Dapper Plus AlsoBulkInsert method allow to INSERTs entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Also Bulk Insert with "One to One" Relation

The Dapper Plus AlsoBulkInsert method allows inserting a related item with a "One to One" relation.

Also Bulk Insert with "One to Many" Relation

The Dapper Plus AlsoBulkInsert method allows inserting related items with a "One to Many" relation.

Also Bulk Insert and Mixed Relation

The Dapper Plus AlsoBulkInsert method allows inserting related item(s) with any relation.

Also Bulk Insert Chain Action

The Dapper Plus AlsoBulkInsert method allows chaining multiple bulk action methods.

Also Bulk Update

Definition

The Dapper Plus AlsoBulkUpdate method allow to UPDATE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Also Bulk Update with "One to One" Relation

The Dapper Plus AlsoBulkUpdate method allows updating a related item with a "One to One" relation.

Also Bulk Update with "One to Many" Relation

The Dapper Plus AlsoBulkUpdate method allows updating related items with a "One to Many" relation.

Also Bulk Update and Mixed Relation

The Dapper Plus AlsoBulkUpdate method allows updating related item(s) with any relation.

Also Bulk Update Chain Action

The Dapper Plus AlsoBulkUpdate method allows chaining multiple bulk action methods.

Also Bulk Delete

Definition

The Dapper Plus AlsoBulkDelete method allows to DELETE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Also Bulk Delete with "One to One" Relation

The Dapper Plus AlsoBulkDelete method allows deleting a related item with a "One to One" relation.

Also Bulk Delete with "One to Many" Relation

The Dapper Plus AlsoBulkDelete method allows deleting related items with a "One to Many" relation.

Also Bulk Delete and Mixed Relation

The Dapper Plus AlsoBulkDelete method allows deleting related item(s) with any relation.

Also Bulk Delete Chain Action

The Dapper Plus AlsoBulkDelete method allows chaining multiple bulk action methods.

Also Bulk Merge

Definition

The Dapper Plus AlsoBulkMerge method allows to MERGE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Also Bulk Merge with "One to One" Relation

The Dapper Plus AlsoBulkMerge method allows merging a related item with a "One to One" relation.

Also Bulk Merge with "One to Many" Relation

The Dapper Plus AlsoBulkMerge method allows merging related items with a "One to Many" relation.

Also Bulk Merge and Mixed Relation

The Dapper Plus AlsoBulkMerge method allows merging related item(s) with any relation.

Also Bulk Merge Chain Action

The Dapper Plus AlsoBulkMerge method allows chaining multiple bulk action methods.

Then Bulk Actions

Then Bulk Actions is similar to Also Bulk Actions but move foward the chaining for the next bulk action.

Then Bulk Insert

Definition

The Dapper Plus ThenBulkInsert method allows to INSERT entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Then Bulk Insert with "One to One" Relation

The Dapper Plus ThenBulkInsert method allows inserting a related item with a "One to One" relation.

Then Bulk Insert with "One to Many" Relation

The Dapper Plus ThenBulkInsert method allows inserting related items with a "One to Many" relation.

Then Bulk Insert Chaining

The Dapper Plus ThenBulkInsert method allows chaining multiple bulk action methods.

Then Bulk Update

Definition

The Dapper Plus ThenBulkUpdate method allows to UPDATE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Then Bulk Update with "One to One" Relation

The Dapper Plus ThenBulkUpdate method allows updating a related item with a "One to One" relation.

Then Bulk Update with "One to Many" Relation

The Dapper Plus ThenBulkUpdate method allows updating related items with a "One to Many" relation.

Then Bulk Update Chaining

The Dapper Plus ThenBulkUpdate method allows chaining multiple bulk action methods.

Then Bulk Delete

Definition

The Dapper Plus ThenBulkDelete method allows to DELETE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Then Bulk Delete with "One to One" Relation

The Dapper Plus ThenBulkDelete method allows deleting a related item with a "One to One" relation.

Then Bulk Delete with "One to Many" Relation

The Dapper Plus ThenBulkDelete method allows deleting related items with a "One to Many" relation.

Then Bulk Delete Chaining

The Dapper Plus ThenBulkDelete method allows chaining multiple bulk action methods.

Then Bulk Merge

Definition

The Dapper Plus ThenBulkMerge method allows to MERGE entities in a database table or a view using a lambda expression.

The lambda expression uses the entity or the IEnumerable from the last Bulk[Action] or ThenBulk[Action] chained method. (The action can be an insert, update, delete or merge operation).

Then Bulk Merge with "One to One" Relation

The Dapper Plus ThenBulkMerge method allows merging a related item with a "One to One" relation.

Then Bulk Merge with "One to Many" Relation

The Dapper Plus ThenBulkMerge method allows merging related items with a "One to Many" relation.

Then Bulk Merge Chaining

The Dapper Plus ThenBulkMerge method allows chaining multiple bulk action methods.

Utilities Actions

The Dapper Plus utilities give you more flexibility to control chaining methods.

Include

ThenForEach

Quick Navigation;