如果使用sqlbulkcopy.writetoserver，则控制台应用程序退出速度较慢

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlTransaction transaction = connection.BeginTransaction())
    {
        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.UseInternalTransaction, transaction))
        {
            // 设置列映射等相关配置
            bulkCopy.WriteToServer(dataTable);
        }
        transaction.Commit();
    }
}

using (SqlConnection connection = new SqlConnection(connectionString))
{
    await connection.OpenAsync();
    using (SqlTransaction transaction = connection.BeginTransaction())
    {
        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.Default, transaction))
        {
            // 设置列映射等相关配置
            await bulkCopy.WriteToServerAsync(dataTable);
        }
        transaction.Commit();
    }
}