title: Is it possible to override both appSettings and connectionStrings in a Local.config file?
body: <p>We presently override <code>appSettings</code> from our web.config in a Local.config file for each developer.  However we also need to override connection strings, so we access our local copy on our machine while the web.config might reference the production server.  I know that you can override appSettings by specifying <code>file="Local.config"</code>, but is this possible for the connectionStrings as well?  We already make use of an external file for the connection strings but this file has all three connection strings (local developer, dev, and production).</p>
  
  <p>What I'd like to do is have the connectionString defaulted to production, but overridden on a developer's machine and on the development server.  However, this doesn't seem to be possible as unlike appSettings, you can't specify a value for connectionStrings when you tell it to use an external file.</p>
  
  <p>Is this possible to achieve without having to add additional code?</p>
  
  <p>I should note that I <strong>cannot</strong> use the Config Transformations at the moment as we are on ASP.NET 3.5.</p>