title: "The operation is not valid for the state of the transaction" error and transaction scope
body: <p>I am getting the following error when I try to call a stored procedure that contains a SELECT Statement:</p>
  
  <blockquote>
    <p>The operation is not valid for the state of the transaction</p>
  </blockquote>
  
  <p>Here is the structure of my calls:</p>
  
  <pre><code>public void MyAddUpdateMethod()
  {
  
      using (TransactionScope Scope = new TransactionScope(TransactionScopeOption.RequiresNew))
      {
          using(SQLServer Sql = new SQLServer(this.m_connstring))
          {
              //do my first add update statement
  
              //do my call to the select statement sp
              bool DoesRecordExist = this.SelectStatementCall(id)
          }
      }
  }
  
  public bool SelectStatementCall(System.Guid id)
  {
      using(SQLServer Sql = new SQLServer(this.m_connstring)) //breaks on this line
      {
          //create parameters
          //
      }
  }
  </code></pre>
  
  <p>Is the problem with me creating another connection to the same database within the transaction?</p>