Is there anyway to do config file transforms for the situation where a particular section might be sourced?
For example, if I have a web.config.transform like:
<add name="Metadata" connectionString="Data Source=<My Connection String>;MultipleActiveResultSets=True;Application Name=Origin" providerName="System.Data.SqlClient"/>
and I run that on a web project that has the connection strings sourced, I'll get:
<add name="Metadata" connectionString="<Connection Info>" />
However, this is an invalid web config file.
Additionally, if I did a transform to make the ConnectionStrings sourced in webconfig, I'd break anyone that wasn't using sourced connection strings.
Is there any way that I can write a transform that will add the data to the right spot?