zzzprojects / Dapper Plus
Programming Languages
Projects that are alternatives of or similar to Dapper Plus
What's Dapper Plus?
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 other Dapper packages.
Example
// 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);
Download
PM> Install-Package Z.Dapper.Plus
* PRO Version unlocked for the current month
Stay updated with latest changes
Wiki
Dapper Plus - Actions
- Introduction
- Bulk Actions
- Also Bulk Actions
- Then Bulk Actions
- Include Actions
- Transaction
Dapper Plus - Mapper
Dapper Plus - Manager
Mapper
Dapper Plus Mapper allows 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
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
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
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);
Include Actions
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));
Transaction
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));
DB Provider Supported
All major database providers are supported or under development.
- SQL Server 2008+
- SQL Azure
- SQL Compact
- SQLite
- MySQL
- PostgreSQL
- Oracle
Support
Contact our outstanding customer support for any request. We usually answer within the next business day, hour, or minutes!
PRO
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
Contribute
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.
More Projects
- EntityFramework Extensions
- Bulk Operations
- C# Eval Expression
- Entity Framework Classic
- SQL Eval Function
- LINQ To SQL Plus
- and much more! To view all our free and paid librariries visit our website.
Contact our outstanding customer support for any request. We usually answer within the next business day, hour, or minutes!