title: how to close command connection with LINQ / EF
body: <p>working with Azure and EF I get the error message:</p>
  
  <pre><code> DataReader associated with this Command which must be closed first. 
  </code></pre>
  
  <p>It because my queries are nested:</p>
  
  <pre><code>foreach (Element s in ElementSet.All()) {
     if (somecondition) {  
       ElementSet.Add() 
     }
  }
  </code></pre>
  
  <p>How can I load all the Elements from ElementSet and close the connection before I cycle through them with foreach?</p>
  
  <p>P.S.: Apprently with SQL azure I can not set MARS in the connection string which would make the server accept multiple connections.</p>