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

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

• Bulk Actions
  • Bulk Insert
  • Bulk Update
  • Bulk Delete
  • Bulk Merge
• Also Bulk Actions
  • Also Bulk Insert
  • Also Bulk Update
  • Also Bulk Delete
  • Also Bulk Merge
• Then Bulk Actions
  • Then Bulk Insert
  • Then Bulk Update
  • Then Bulk Delete
  • Then Bulk Merge
• Include Actions
• Transaction

Dapper Plus - Mapper

• Map
• Options
  • Action
  • Batch
  • SQL Server
  • Temporary Table
  • Transient Error

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.

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 modifies 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 allows resolving issues with multiple "ThenBulk[Action]" methods.

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

PRO

PRO Version unlocked for the current month

Learn more about the PRO Version.

Contribute

The best way to contribute is by spreading the word about the library:

• Blog it
• Comment it
• Star it
• Share it

A HUGE THANKS for your help.

More Projects

• Projects:
  • EntityFramework Extensions
  • Dapper Plus
  • C# Eval Expression
• Learn Websites
  • Learn EF Core
  • Learn Dapper
• Online Tools:
  • .NET Fiddle
  • SQL Fiddle
  • ZZZ Code AI
• and much more!

To view all our free and paid projects, visit our website ZZZ Projects.