title: 'MultipleActiveResultsSets' Keyword Not Supported
body: <p>I am trying to read from an SQL Server database which is hosted on MS Azure, through an ASP.NET WebForms website created in Visual Studio 2013.</p>
  
  <p>I've stored the Connection String in Web.Config, and have referenced it in my Code-Behind.</p>
  
  <p>However, when I try to run Default.aspx locally, <a href="https://i.stack.imgur.com/uVcZ1.png" rel="noreferrer">this</a> error is displayed.</p>
  
  <p>Here is my Web.Config:</p>
  
  <pre><code>  &lt;connectionStrings&gt;
       &lt;add name="FYPConnectionString1" 
       connectionString="Data Source=damo.database.windows.net‌​;Initial Catalog=Ballinora_db;         
       Persist Security Info=True; User ID={Username};Password={Password};" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I removed "MultipleActiveResultsSets=False" from the Connection String to see if the error stopped, but instead, the error now displays for "Encrypt".</p>
  
  <p>So the error is appearing for the next item after the Password part of the connection string.
  Would the password have anything to do with the problem?</p>
  
  <p>Also, this username and password which are required, are they the Server Admin Login details which appear in the Azure portal?</p>
  
  <p>Here is the Code-Behind also:</p>
  
  <pre><code>private void bindRepeater()
  {
      string constr = ConfigurationManager.ConnectionStrings["FYPConnectionString1"].ConnectionString;  
      //-- assuming Azure connection string stored in ConnectionString config in Web.Config as YourConnString 
      using (SqlConnection con = new SqlConnection(constr))
      {
          using (SqlCommand cmd = new SqlCommand("SELECT Name FROM Users", con))
          {
              cmd.CommandType = CommandType.Text;
              con.Open();
              SqlDataAdapter sda = new SqlDataAdapter(cmd);
              DataTable dt = new DataTable();
              sda.Fill(dt);
              repTest.DataSource = dt;
              repTest.DataBind();
              con.Close();
          }
      }
  }
  
  protected void btnDisplay_Click(object sender, EventArgs e)
  {
      this.bindRepeater();
  }
  </code></pre>