CSharp · Console
// Dapper Plus
// Doc: https://dapper-plus.net/bulk-delete
// @nuget: Dapper
// @nuget: Microsoft.Data.SqlClient
// @nuget: Z.Dapper.Plus
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using Microsoft.Data.SqlClient;
using Dapper;
using Z.Dapper.Plus;
using Z.BulkOperations;
public class Program
{
public static void Main()
{
// Map your entity
DapperPlusManager.Entity<Product>()
.Table("Product")
.Identity(x => x.ProductID)
.UseBulkOptions(x => {
x.DeleteMatchedAndConditionExpression = y => new { y.Version };
});
var products = new List<Product>();
products.Add(new Product() { Name = "Dapper Plus", Description = @"Use <a href=""https://dapper-plus.net/"" target=""_blank"">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.", Version = "2" });
products.Add(new Product() { Name = "C# Eval Expression", Description = @"Use <a href=""https://eval-expression.net/"" target=""_blank"">C# Eval Expression</a> to compile and execute C# code at runtime.", Version = "2" });
products.Add(new Product() { Name = "Entity Framework Extensions", Description = @"Use <a href=""https://entityframework-extensions.net/"" target=""_blank"">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.", Version = "2" });
var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
connection.CreateTable<Product>();
// Seed
connection.BulkInsert(products);
FiddleHelper.WriteTable("1 - Product (Before)", connection.Query<Product>("SELECT * FROM Product"));
// Change one version (this rows will not be deleted as the version is different)
products.Last().Version = "3";
// Delete
connection.BulkDelete(products);
// Query data with Dapper
FiddleHelper.WriteTable("3 - Product (After)", connection.Query<Product>("SELECT * FROM Product"));
}
[Table("Product")]
public class Product
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int ProductID { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public string Version { get; set; }
}
}