Dapper Plus

What’s Dapper Plus?

Dapper Plus extends the IDbConnection interface with Bulk Operations methods:

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

This library is the fastest way to perform saving operations in a database.

Official Website: http://dapper-plus.net/

Installation

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

This library is NOT FREE, but a monthly trial is available at the start of every month.

Requirement

Dapper Plus is compatible with all major database provider:

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

Methods

Dapper Plus extend your IDbConnection interface with multiple methods:

  1. // STEP MAPPING
  2. DapperPlusManager.Entity<Supplier>().Table("Suppliers").Identity(x => x.SupplierID);
  3. DapperPlusManager.Entity<Product>().Table("Products").Identity(x => x.ProductID);
  5. // STEP BULKINSERT
  6. using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
  7. {
  8.     connection.BulkInsert(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID =  x.SupplierID)).ThenBulkInsert(x => x.Products);
  9. }
  11. // STEP BULKUPDATE
  12. using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
  13. {
  14.     connection.BulkUpdate(suppliers, x => x.Products);
  15. }
  17. // STEP BULKMERGE
  18. using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
  19. {
  20.     connection.BulkMerge(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID =  x.SupplierID)).ThenBulkMerge(x => x.Products);
  21. }
  23. // STEP BULKDELETE
  24. using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
  25. {
  26.     connection.BulkDelete(suppliers.SelectMany(x => x.Products)).BulkDelete(suppliers);
  27. }

Try it: .NET Core | .NET Framework