Change app.config connection string depending on PC

Question

Hi guys I'm doing a c# course at university, and now I'm beginning linQ to xml, linQ to Sql-Server, etc. I work with the example projects in two PCs (university PC and office PC) Is there an easy way to change connection string (from app.config) at runtime, or designtime (using a constant in main.cs) so I can use a connection string at university, and a connection string at the office easily?

Thanks a lot in advance,

Answer 1

You could try something like:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="Environment" value="Home"/>
  </appSettings>
  <connectionStrings>
    <add name="Work" connectionString="..."/>
    <add name="Home" connectionString="..."/>
  </connectionStrings>
</configuration>

and, later:

string environment = ConfigurationManager.AppSettings["Environment"];
ConfigurationManager.ConnectionStrings[environment].ConnectionString;