A feature requires adding a new connection string. Which should be the way to do this in Helix?


You would need to use an XmlTransform to do this. If you look at the Habitat demo site you can see examples of how to do this.

Creating the transform file

You would add your connection string to a ConnectionStrings.config.transform file - this can live in your project in the App_Config folder.

The file is a standard config transform file. Example:

<?xml version="1.0"?>
<connectionStrings xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
    <add name="MyDB" 
        connectionString="value for the deployed Web.config file" 
        xdt:Transform="Insert" />

Merging the transform

If you are using the gulp file from the Habitat example, there is already a task that will apply the transforms in the solution:


If you are not using that script, you can do the same thing. It calls MSBuild with an applytransform.targets file.

The targets file contains:

<Project ToolsVersion="14.0" DefaultTargets="ApplyTransform" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <UsingTask TaskName="TransformXml" AssemblyFile="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(MSBuildToolsVersion)\Web\Microsoft.Web.Publishing.Tasks.dll" />
  <Target Name="ApplyTransform">
      <Transform Include="$(TransformFile)" />

      <ConfigsToTransform Include="$(FileToTransform)" Condition="Exists(@(Transform))">
    <Message Text="@(ConfigsToTransform)"></Message>
    <Message Text="@(Transform)"></Message>

    <TransformXml Source="$(WebConfigToTransform)\%(ConfigsToTransform.Identity)"

So you can use the MSBuild command line to use that:

msbuild applytransforms.xml /t:ApplyTransforms

More information about how to set this up is here:

  • Beat me to it! ;) – Zachary Kniebel Oct 31 '16 at 16:48
  • Note that for connection strings the <configuration> node must be removed. Thanks :) – JGonDev Nov 1 '16 at 8:52
  • Yes - that is because the ConnectionStrings.config lives outside the main web.config. I'll update the answer. – Richard Seal Nov 1 '16 at 12:19

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.