Dapper Plus
What's Dapper Plus?
Dapper Plus extend 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:
// 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 SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{
connection.BulkInsert(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID = x.SupplierID)).ThenBulkInsert(x => x.Products);
}
// STEP BULKUPDATE
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{
connection.BulkUpdate(suppliers, x => x.Products);
}
// STEP BULKMERGE
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{
connection.BulkMerge(suppliers).ThenForEach(x => x.Products.ForEach(y => y.SupplierID = x.SupplierID)).ThenBulkMerge(x => x.Products);
}
// STEP BULKDELETE
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{
connection.BulkDelete(suppliers.SelectMany(x => x.Products)).BulkDelete(suppliers);
}