NeonRant
8/22/2019 - 4:00 AM

Connection string config in seeprate file

In order to be able to have different configs for different environments, you can split the connection string part of the config out to point to another config file dedicated to the connection string.

This can be used to replace any part of the config file with its own config that is referenced by the main config. This allows the main config to be smaller.

web.config
content_copyfile_download
Remove this
 <connectionStrings>
    <clear />    
    <add name="CMSConnectionString" connectionString="Data Source=CREATE-PC-04\SQLSERVER2016;Initial Catalog=alliancecommunity_com_au;Integrated Security=False;Persist Security Info=False;User ID=sa;Password=createnet;Connect Timeout=60;Encrypt=False;Current Language=English;"/>
 </connectionStrings>
  
  And replace it with this
  
<connectionStrings configSource="ConnectionStrings.config" />
  
  Create a new file in the same folder. Name it the same name as the reference i.e. ConnectionStrings.config
  
  Add this to it.
  
<?xml version="1.0"?>
<connectionStrings>
	<clear />
	<add name="CMSConnectionString" connectionString="Data Source=CREATE-PC-04\SQLSERVER2016;Initial Catalog=alliancecommunity_com_au;Integrated Security=False;Persist Security Info=False;User ID=sa;Password=createnet;Connect Timeout=60;Encrypt=False;Current Language=English;" />
</connectionStrings>