asp.net数据库并发

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlTransaction transaction = connection.BeginTransaction();

    try
    {
        SqlCommand command1 = new SqlCommand("UPDATE Table1 SET Column1 = @Value1 WHERE Id = @Id1", connection, transaction);
        command1.Parameters.AddWithValue("@Value1", value1);
        command1.Parameters.AddWithValue("@Id1", id1);
        command1.ExecuteNonQuery();

        SqlCommand command2 = new SqlCommand("UPDATE Table2 SET Column2 = @Value2 WHERE Id = @Id2", connection, transaction);
        command2.Parameters.AddWithValue("@Value2", value2);
        command2.Parameters.AddWithValue("@Id2", id2);
        command2.ExecuteNonQuery();

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

// 乐观并发示例
public void UpdateData(int id, string newValue, int expectedVersion)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        SqlCommand command = new SqlCommand("UPDATE Table SET Column = @Value, Version = Version + 1 WHERE Id = @Id AND Version = @ExpectedVersion", connection);
        command.Parameters.AddWithValue("@Value", newValue);
        command.Parameters.AddWithValue("@Id", id);
        command.Parameters.AddWithValue("@ExpectedVersion", expectedVersion);

        int rowsAffected = command.ExecuteNonQuery();
        if (rowsAffected == 0)
        {
            throw new Exception("数据已被其他用户修改，请刷新后重试。");
        }
    }
}