title: Invalid operation.The connection is closed error while reading from SQL server
body: <p>I like to read from database using Linq to SQL. However in this method throw exception</p>
  
  <pre><code>  public string[] readFromAbbrevationsPerson()
  {
      string[] resultAbbrevationsPerson = new string[10000];
  
  
      DataClassesDataContext db = new DataClassesDataContext("NERMacedonianConnectionString");
  
      var query = from abb in db.abbrevationsPersons
                  select abb.abbrevationsPerson1;
      int i = 0;
  
      foreach (string noun in query)
          resultAbbrevationsPerson[i++] = noun;
  
      return resultAbbrevationsPerson;
  }
  </code></pre>
  
  <p>in the foreach statement.The exception is Invalid operation the connection is closed.
  I made refresh in VS 2010 to the server and I made refresh in SQL Management studio.Ichecked the status of the server is running.</p>