C# 中的批量更新

C#中的批量更新是一种非常常见的操作，它允许我们在数据库中同时更新多行数据，而不是逐行进行更新。这种方法可以大大提高更新数据的效率，尤其是当需要更新大量数据时。在本文中，我们将详细讨论C#中的批量更新，并提供一个实际的案例代码来说明其用法。

string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=MyDatabase;Integrated Security=True";
string tableName = "MyTable";
DataTable dataTable = new DataTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
    using (SqlCommand command = new SqlCommand($"SELECT * FROM {tableName}", connection))
    {
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        dataTable.Load(reader);
    }
}
// 修改DataTable中的数据
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = tableName;
        bulkCopy.WriteToServer(dataTable);
    }
}

string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=MyDatabase;Integrated Security=True";
string tableName = "MyTable";
DataTable dataTable = new DataTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
    using (SqlCommand command = new SqlCommand($"SELECT * FROM {tableName}", connection))
    {
        connection.Open();
        SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
        dataAdapter.Fill(dataTable);
    }
}
// 修改DataTable中的数据
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlDataAdapter dataAdapter = new SqlDataAdapter($"SELECT * FROM {tableName}", connection))
    {
        SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
        dataAdapter.Update(dataTable);
    }
}