Dapper Plus is a library that dramatically improves dapper performances by using high efficient Bulk Actions Helpers (Insert, Update, Delete, and Merge).
People using this library often report performance enhancement by 50x times and more!
The library is installed through NuGet. Extension methods are added automatically to your IDbConnection interface.
It can be used with or without Dapper, and it’s compatible with all others Dapper packages.
Dapper Plus Mapper allow to map the conceptual model (Entity) with the storage model (Database) and configure options to perform Bulk Actions.
Bulk Actions allow to perform a bulk insert, update, delete or merge and include related child items.
Bulk Actions Available:
Bulk Actions Examples
|Operations||1,000 Rows||10,000 Rows||100,000 Rows||1,000,000 Rows|
|Insert||9 ms||25 ms||200 ms||2,000 ms|
|Update||50 ms||80 ms||575 ms||6,500 ms|
|Delete||45 ms||70 ms||625 ms||6,800 ms|
|Merge||65 ms||160 ms||1,200 ms||12,000 ms|
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 Actions Examples
Then Bulk Actions
Then Bulk Actions is similar to Also Bulk Actions but modify entities used for the next bulk action using a lambda expression.
Then Bulk Actions Examples
The Dapper Plus Include method allow resolving issues with multiple “ThenBulk[Action]” method.