Like Dapper,

Dapper Plus is a NuGet library that you can add to your project that will extend your IDbConnection 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)
                                 .AsloMerge(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

Introduction

Dapper Plus - Actions

• 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

Dapper Plus - Mapper

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

Dapper Plus - Manager

• Entity
• MapperFactory

PRO License

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 major database provider are supported or under development.

• SQL Server 2008+
• SQL Azure
• SQL Compact
• SQLite
• MySQL
• PostgreSQL (Under Development)
• Oracle (Under Development)

Contact our outstanding customer support for any request. We usually answer within the next business day, hour, or minutes!

• info@zzzprojects.com
• Documentation
• Issues / Questions

PRO Version unlocked for the current month

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

• EntityFramework Extensions
• EntityFramework Plus

Bulk Operations

• Bulk Operations
• Dapper Plus

Expression Evaluator

• Eval-SQL.NET
• Eval-Expression.NET

Others

• Extension Methods Library
• LINQ Async

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!