c#事务处理

public void TransactionTest()
        ...{
            string connectionString = "";
            SqlConnectionconnection = new SqlConnection(connectionString);
            connection.Open();
            SqlCommandcommand = new SqlCommand();
            command.Connection = connection;
            SqlTransaction transaction;
            transaction = connection.BeginTransaction(); 
            command.Transaction = transaction;
            try
            ...{
                //代码
        myCommand.CommandText = "SQL语句";
        myCommand.ExecuteNonQuery();
                transaction.Commit();
            }
            catch
            ...{
                transaction.Rollback(); 
            }
            finally
            ...{
                connection.Close();
            }
        }