c# – 将SqlTransaction与SqlDataReader一起使用

This SqlTransaction has completed; it is no longer usable.

这是代码

using (SqlConnection locationConnection = new SqlConnection(connectionString))
        {
            locationConnection.Open();
            SqlTransaction transaction = locationConnection.BeginTransaction();
            SqlCommand cmd = new SqlCommand("
 Select stuff from table A
 Insert stuff into table B
 Delete stuff from table A",locationConnection,transaction); 

            using(SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            //Doesn't matter
                        }                            
                    }

            //Exception happens here
            transaction.Commit();       
        }

任何人都可以阐明为什么会这样吗？如果我在SqlDataReader的范围内移动提交,我会得到一个例外,即datareader需要先关闭.

编辑：我已经回答了我的问题,并会在我被允许的情况下尝试记住接受它.