c# 简单事务的使用方法

            SqlConnection myConnection = new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;");
            myConnection.Open();

            SqlTransaction myTrans = myConnection.BeginTransaction(); //使用New新生成一个事务
            SqlCommand myCommand = new SqlCommand();
            myCommand.Transaction = myTrans;

            try
            {
                myCommand.CommandText = "Update Address set location='23 rain street' where userid='0001'";
                myCommand.ExecuteNonQuery();
                myTrans.Commit();
                Console.WriteLine("Record is udated.");
            }
            catch (Exception ex)
            {
                myTrans.Rollback();
                Console.WriteLine(ex.ToString());
                Console.WriteLine("Sorry, Record can not be updated.");
            }
            finally
            {
                myConnection.Close();
            }