Dapper 引入到项目

?

1 2 3

Install-Package Dapper Install-Package Microsoft.Extensions.Configuration Install-Package Microsoft.Extensions.DependencyInjection.Abstractions

通过NuGet，在数据库项目引用以上程序包

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using Aps.Core.Interfaces.IBasicData; using Dapper; using Microsoft.Data.SqlClient; using Microsoft.Extensions.Configuration;   namespace Aps.Infrastructure.Services; public class CustomerService : ICustomerService {   private readonly IConfiguration _configuration;   public CustomerService(IConfiguration configuration)   {     _configuration = configuration;   }   public async Task<int> BatchDelete(int id)   {     using var sqlConn = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));     sqlConn.Open();     string sql = @"Delete Customers Where Id in (@ids)";     int result = await sqlConn.ExecuteAsync(sql,new {id= id });     return result;   } }