在.NET内核中使用dapper大容量插入到PostgreSQL中

using Dapper;
using Npgsql;

string connectionString = "Server=<服务器地址>;Port=<端口号>;Database=<数据库名>;User Id=<用户名>;Password=<密码>;";

List<MyEntity> entities = new List<MyEntity>();
// 添加要插入的数据到集合中

using (var connection = new NpgsqlConnection(connectionString))
{
    connection.Open();
    using (var transaction = connection.BeginTransaction())
    {
        try
        {
            string sql = "INSERT INTO MyTable (Column1, Column2, Column3) VALUES (@Column1, @Column2, @Column3)";
            connection.Execute(sql, entities, transaction);
            transaction.Commit();
        }
        catch (Exception ex)
        {
            transaction.Rollback();
            // 处理异常
        }
    }
}