title: Select entity connection string at runtime
body: <p>I have an application that connects to a MYSQL database. I use Entity Framework to do all the job. 
  Now When I first Installed, I set up entity, and resulted in a connection string like this:  </p>
  
  <pre><code>&lt;connectionStrings&gt;
  &lt;add name="networkingEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=MySql.Data.MySqlClient;provider connection string="server=localhost;user id=root;password=lucian;persist security info=True;database=networking"" providerName="System.Data.EntityClient"/&gt;
  &lt;/connectionStrings&gt;  
  </code></pre>
  
  <p>Now, my application has 2 users: an admin and a student.</p>
  
  <p>Form1 => updates information from database and from server</p>
  
  <p>Login form=> the users authentificate</p>
  
  <p>MainForm => where all the action takes part. If the admin is logged in he can modify contents in the database</p>
  
  <p>The database:
  has 2 users: root and lucian.</p>
  
  <p>"lucian" is a limited user...</p>
  
  <p>Now, my problem is:</p>
  
  <p><strong>How can I add a second connection string to the already existing one, and select that one at runtime? I mean, when Form1 is running, put the thread to sleep, select the second connections string and then, go to Login form, login as admin and make the cnahge sin the database?</strong></p>
  
  <p>And how can I get tho login information from the connection string, from an external file?</p>