What's Dapper Plus?

Like Dapper, Dapper Plus is a NuGet library where 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

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

// 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

Wiki

Introduction

Dapper Plus - Mapper

Map
Options

PRO License

Mapper

Dapper Plus Mapper allows to map the conceptual model (Entity) with the storage model (Database) and configure options to perform Bulk Actions.

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

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.

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

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.

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

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 modifies entities used for the next bulk action using a lambda expression.

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

connection.BulkInsert(orders)
          .AlsoInsert(order => order.Items)
          .ThenInsert(order => order.Invoice)
          .ThenInsert(invoice => invoice.Items);

Include Actions

The Dapper Plus Include method allows resolving issues with multiple "ThenBulk[Action]" methods.

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

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

csharp
// @nuget: Z.Dapper.Plus
using Z.Dapper.Plus;

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

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