title: Multiple SQL Server connection strings in app.config file
body: <p>I'm interested in displaying in a Windows Forms app a list of N radio buttons for the user to choose a target database server. I would like to add the SQL Server connection strings in the app.config file, so they are read by the app at runtime and rendered in the windows form as radio buttons. </p>
  
  <p>At first I thought of using a delimiter to separate the connections</p>
  
  <pre><code>  &lt;appSettings&gt;
      &lt;add key="ConnectionString" value="connection1|user id=user;password=123;server=10.0.0.1;database=myDatabase;connection timeout=30|connection2|user id=user;password=123;server=10.0.0.2;database=myDatabase;connection timeout=30"/&gt;
  &lt;/appSettings&gt;
  </code></pre>
  
  <p>And then split the key value pairs.</p>
  
  <p>Is it possible to do this in a different way?</p>