将csv文件/ excel导入sql数据库asp.net

using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using CsvHelper;

public void ImportCsvToSql(string csvFilePath, string connectionString)
{
    using (var reader = new StreamReader(csvFilePath))
    using (var csv = new CsvReader(reader))
    using (var connection = new SqlConnection(connectionString))
    {
        connection.Open();
        var transaction = connection.BeginTransaction();

        try
        {
            var records = csv.GetRecords<dynamic>();
            var command = connection.CreateCommand();
            command.Transaction = transaction;

            foreach (var record in records)
            {
                command.CommandText = "INSERT INTO MyTable (Column1, Column2, Column3) VALUES (@Column1, @Column2, @Column3)";
                command.Parameters.AddWithValue("@Column1", record.Column1);
                command.Parameters.AddWithValue("@Column2", record.Column2);
                command.Parameters.AddWithValue("@Column3", record.Column3);
                command.ExecuteNonQuery();
                command.Parameters.Clear();
            }

            transaction.Commit();
        }
        catch (Exception ex)
        {
            transaction.Rollback();
            throw ex;
        }
    }
}