Like Dapper,
Dapper Plus is a NuGet library that you can add to your project that will extend your IDbConnection
and IDbTransaction
interface with high efficient Bulk Actions Helpers (Insert, Update, Delete, and Merge).
It can be used with or without Dapper, and it's compatible with all others Dapper packages.
// CONFIGURE & MAP entity
DapperPlusManager.Entity<Order>().Table("Orders").Identity(x => x.ID);
// CHAIN & SAVE entity
connection.BulkInsert(orders)
.AlsoInsert(order => order.Items);
.Include(order => order.ThenMerge(order => order.Invoice)
.AlsoMerge(invoice => invoice.Items))
.AlsoMerge(order => order.ShippingAddress);
PM> Install-Package Z.Dapper.Plus
* PRO Version unlocked for the current month
Stay updated with latest changes
Dapper Plus - Actions
- Introduction
- Bulk Actions
- Also Bulk Actions
- Then Bulk Actions
- Include Actions
- Transaction
Dapper Plus - Mapper
Dapper Plus - Manager
Dapper Plus Mapper allow to map the conceptual model (Entity) with the storage model (Database) and configure options to perform Bulk Actions.
DapperPlusManager.Entity<Order>().Table("Orders")
.Identity(x => x.ID)
.BatchSize(200);
Bulk Actions allow to perform a bulk insert, update, delete or merge and include related child items.
connection.BulkInsert(orders, order => order.Items)
.BulkInsert(invoices, invoice => invoice.Items)
.BulkMerge(shippingAddresses);
Also Bulk Actions allow to perform bulk action with a lambda expression using entities from the last Bulk[Action] or ThenBulk[Action] used.
connection.BulkInsert(orders)
.AlsoInsert(order => order.Items)
.AlsoInsert(order => order.Invoice)
.AlsoInsert(order => order.Invoice.Items);
Then Bulk Actions is similar to Also Bulk Actions but modify entities used for the next bulk action using a lambda expression.
connection.BulkInsert(orders)
.AlsoInsert(order => order.Items)
.ThenInsert(order => order.Invoice)
.ThenInsert(invoice => invoice.Items);
The Dapper Plus Include method allow resolving issues with multiple "ThenBulk[Action]" method.
connection.BulkInsert(orders)
.Include(x => x.ThenInsert(order => order.Items)
.ThenInsert(orderItem => orderItem.Metas))
.Include(x => x.ThenInsert(order => order.Invoice)
.ThenInsert(Invoice => invoice.Items));
All Dapper Plus extension methods are also available on the IDbTransaction
interface
transaction.BulkInsert(orders)
.Include(x => x.ThenInsert(order => order.Items)
.ThenInsert(orderItem => orderItem.Metas))
.Include(x => x.ThenInsert(order => order.Invoice)
.ThenInsert(Invoice => invoice.Items));
All major database provider are supported or under development.
- SQL Server 2008+
- SQL Azure
- SQL Compact
- SQLite
- MySQL
- PostgreSQL
- Oracle
Contact our outstanding customer support for any request. We usually answer within the next business day, hour, or minutes!
PRO Version unlocked for the current month
Features | PRO Version |
---|---|
Bulk Insert | Yes |
Bulk Update | Yes |
Bulk Delete | Yes |
Bulk Merge | Yes |
Bulk Action Async | Yes |
Bulk Also Action | Yes |
Bulk Then Action | Yes |
Commercial License | Yes |
Royalty-Free | Yes |
Support & Upgrades (1 year) | Yes |
Learn more about the PRO Version
The best way to contribute is by spreading the word about the library:
- Blog it
- Comment it
- Fork it
- Star it
- Share it
A HUGE THANKS for your help.
Entity Framework
Bulk Operations
Expression Evaluator
Utilities
Need more info? info@zzzprojects.com
Contact our outstanding customer support for any request. We usually answer within the next business day, hour, or minutes!