The stock web.config contains this entry:
<configBuilders>
<builders>
<add name="SitecoreAppSettingsBuilder" mode="Strict" prefix="SITECORE_APPSETTINGS_" stripPrefix="true"
type="Sitecore.Configuration.FlexibleEnvironmentConfigBuilder, Sitecore.Kernel"/>
<add name="SitecoreConnectionStringsBuilder" mode="Strict" prefix="SITECORE_CONNECTIONSTRINGS_" stripPrefix="true"
type="Microsoft.Configuration.ConfigurationBuilders.EnvironmentConfigBuilder, Microsoft.Configuration.ConfigurationBuilders.Environment, Version=1.0.0.0, Culture=neutral"/>
</builders>
</configBuilders>
However, if you add a connection string to an app service configuration setting, as documented here, the connection strings will in fact be prefixed with a value like SQLCONNSTR_
or SQLAZURECONNSTR_
, depending on a user selection when entering the value. This is documented here. Is there a reason why SItecore ships with the non-standard value in Web.config, and is there an approved or standard way of setting this in Azure?
I'm inclined to simply update the <builders>
prefix value, but curious if there are other standard approaches here.