title: How to update Entity Framework Connection String
body: <p>I have modified the web.config connection string. However, during debug, I still see the old connection string.</p>
  
  <p>So, I have commented (and deleted) out the old connection string but, and added a new connection resource via server explorer. On <em>testing</em> the connection via wizard on the left panel in server explorer- it says connected.</p>
  
  <p>After following this wizard, when I visit the web.config I dont see the new connection string.</p>
  
  <p><strong>Question</strong>: I suspect, I am not following the steps to add a connection string - 
  <strong>how can I add or update the connection string from the designer</strong> (<em>in the designer properties panel, edit is greyed out, output type is build to assembly, and right clicking only gives me options to add entities etc, deleting the string and running the app, doesn't prompt for connection string wizard</em>)</p>
  
  <p>Below is the string - </p>
  
  <pre><code>&lt;connectionStrings&gt;&lt;add name="MaintRecordsDB_v1" connectionString="metadata=res://*/Models.DB.Model.csdl|res://*/Models.DB.Model.ssdl|res://*/Models.DB.Model.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=xxx.sample.net;initial catalog=MainDB;user id=maintRoot;password=hidden;multipleactiveresultsets=True;application name=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;&lt;add name="MainDBentities" connectionString="metadata=res://*/Models.DB.Model.csdl|res://*/Models.DB.Model.ssdl|res://*/Models.DB.Model.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=windflower.arvixe.com;initial catalog=MX_Dashboard;user id=maintRoot;password=hidden;multipleactiveresultsets=True;application name=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;&lt;/connectionStrings&gt;
  </code></pre>
  
  <p><strong>Edit Question 2:</strong> How can I add another EF connection string for e.g. <code>MaintDB2</code> using designer, and where do I update to this manually.</p>