C#使用SqlBulkCopy将IList<string>插入表中

DataTable dataTable = new DataTable();
dataTable.Columns.Add("ColumnName1", typeof(string));
dataTable.Columns.Add("ColumnName2", typeof(string));
// 添加更多列...

foreach (string item in yourList)
{
    DataRow row = dataTable.NewRow();
    row["ColumnName1"] = item;
    row["ColumnName2"] = item;
    // 设置更多列的值...
    dataTable.Rows.Add(row);
}

string connectionString = "YourConnectionString";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // 创建一个SqlBulkCopy对象，并设置目标表名和连接对象
    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = "YourTableName";

        // 设置列映射关系，将DataTable的列与目标表的列对应起来
        bulkCopy.ColumnMappings.Add("ColumnName1", "ColumnName1");
        bulkCopy.ColumnMappings.Add("ColumnName2", "ColumnName2");
        // 添加更多列的映射...

        // 执行批量插入操作
        bulkCopy.WriteToServer(dataTable);
    }
}