C#中如何执行批量更新操作？高效方式是什么？

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    
    // 1. 准备数据
    var dataTable = new DataTable();
    dataTable.Columns.Add("Id", typeof(int));
    dataTable.Columns.Add("Name", typeof(string));
    dataTable.Rows.Add(1, "Alice");
    dataTable.Rows.Add(2, "Bob");

    // 2. 批量导入到临时表
    using (var bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = "#TempUpdates";
        bulkCopy.WriteToServer(dataTable);
    }

    // 3. 执行合并更新
    var sql = @"
        MERGE dbo.Users AS target
        USING #TempUpdates AS source ON target.Id = source.Id
        WHEN MATCHED THEN
            UPDATE SET Name = source.Name;";
    
    using (var cmd = new SqlCommand(sql, connection))
    {
        cmd.ExecuteNonQuery();
    }
}

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();

    var sql = "UPDATE Users SET Name = @Name WHERE Id = @Id";
    connection.Execute(sql, updatesList); // updatesList 是对象集合
}

context.BulkUpdate(updatesList); // 一行代码完成批量更新