CSharp · Console
// Dapper Plus
// Doc: https://dapper-tutorial.net/bulk-delete
// @nuget: Dapper -Version 1.60.6
// @nuget: Z.Dapper.Plus
// @nuget: System.Data.SqlClient
using Dapper;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using Z.Dapper.Plus;
using System.Linq;
public class Program
{
public class Customer
{
public int CustomerID {get;set;}
public string CustomerName {get;set;}
public string ContactName {get;set;}
public string Address {get;set;}
public string City {get;set;}
public string PostalCode {get;set;}
public string Country {get;set;}
}
public static void Main()
{
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
var customer = connection.Query<Customer>("Select * FROM CUSTOMERS WHERE CustomerID in (53,57)").ToList();
Console.WriteLine("Row : " + customer.Count());
}
DapperPlusManager.Entity<Customer>().Table("Customers").Key("CustomerID");
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
connection.BulkDelete(connection.Query<Customer>("Select * FROM CUSTOMERS WHERE CustomerID in (53) ").ToList());
}
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
var customer = connection.Query<Customer>("Select * FROM CUSTOMERS WHERE CustomerID in (53)").ToList();
Console.WriteLine("Row count after delete: " + customer.Count());
}
}
}