Dapper.Plus A Getting Started Tutorial for Bulk CRUD Operations

Overview

Dapper.Plus is a small library that you can add to your project which will extend your IDbConnection and IDbTransaction interfaces with highly efficient Bulk operations methods.

• Bulk Insert
• Bulk Update
• Bulk Delete
• Bulk Merge

Using this library, you can perform saving operations in the fastest way. It can be used with or without Dapper, and it is also compatible with all other Dapper packages.

NuGet Installation

Dapper.Plus is only available through NuGet: https://www.nuget.org/packages/Z.Dapper.Plus/

You can easily install this library by running the following command:

PM> Install-Package Z.Dapper.Plus

PRO Version

Every month, a FREE trial of the PRO version is available to let you evaluate all its features without limitations.

More information can be found at: https://dapper-plus.net/

APIs

Once you installed this library then the following extension methods will automatically add to DbConnection:

• Bulk Insert
• Bulk Update
• Bulk Delete
• Bulk Merge

There is no configuration required and no need for extra coding. You can easily use these extension methods in your code.

// STEP MAPPING
DapperPlusManager.Entity<Supplier>().Table("Suppliers").Identity(x => x.SupplierID);
DapperPlusManager.Entity<Product>().Table("Products").Identity(x => x.ProductID);

// STEP BULKINSERT
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
	connection.BulkInsert(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID =  x.SupplierID)).ThenBulkInsert(x => x.Products);
}

// STEP BULKUPDATE
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
	connection.BulkUpdate(suppliers, x => x.Products);
}

// STEP BULKMERGE
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
	connection.BulkMerge(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID =  x.SupplierID)).ThenBulkMerge(x => x.Products);
}

// STEP BULKDELETE
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
	connection.BulkDelete(suppliers.SelectMany(x => x.Products)).BulkDelete(suppliers);
}

Try it online

You can find the detailed documentation here: https://dapper-plus.net/overview

DB Provider Supported

Dapper.Plus is compatible with all major database providers:

• SQL Server 2008+
• SQL Azure
• SQL Compact
• Oracle
• MySQL
• MariaDB
• SQLite
• PostgreSQL

Support

If you have any further queries, contact the outstanding customer support for any request, and you will get your answer within the next business day, hour, or minute!

• info@zzzprojects.com