My Web.config points to an external connectionString file.
<?xml version="1.0"?>
<configuration>
<connectionStrings configSource="connectionStrings.config"/>
</configuration>
So far without news. The problem is that I use Web.Config File Transformation and my deploy process is in File System. I do not use Web Deploy.
In the publish screen I have the information that DataBase Publish is not supported in this Publish method. In summary, it does not work with File System.
TosolveIthoughtaboutcreatingaconnectionStringfilefortesting,homologationandproduction.InmyprojectthenIwouldhaveaconnectionString.configfile,anothercalledconnectionStringProducao.config,anotherconnectionStringHomologa.configandsoon.
Andchangeinthetransformationasbelow:
<configurationxmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<connectionStrings configSource="connectionStringsProducao.config" xdt:Transform="Replace"/>
<system.web>
//...
</system.web>
</configuration>
I think it will work, but I think it is a gambiarra. Does anyone have a better solution?