Web Config Debug Release

Question

I know that web config in Visual Studio 2010 provides the ability to switch from databases from Debug mode to Release mode    Here is my Web Release config    lt  xml version  1 0   gt    lt  -- For more information on using web config transformation visit http   go microsoft com fwlink  LinkId 125889 -- gt    lt configuration xmlns xdt  http   schemas microsoft com XML-Document-Transform  gt      lt connectionStrings gt       lt add name  ApplicationServices  connectionString  data source   SQLEXPRESS Integrated Security SSPI AttachDBFilename  DataDirectory  aspnetdb mdf User Instance true        providerName  System Data SqlClient    gt       lt add name  Testing1  connectionString  Data Source test Initial Catalog TestDatabase Integrated Security True        providerName  System Data SqlClient    gt     lt  connectionStrings gt      lt system web gt       lt compilation xdt Transform  RemoveAttributes debug     gt     lt  system web gt    lt  configuration gt    Here is my Web Debug config code    lt  xml version  1 0   gt    lt  -- For more information on using web config transformation visit http   go microsoft com fwlink  LinkId 125889 -- gt    lt configuration xmlns xdt  http   schemas microsoft com XML-Document-Transform  gt      lt connectionStrings gt       lt add name  ApplicationServices  connectionString  data source   SQLEXPRESS Integrated Security SSPI AttachDBFilename  DataDirectory  aspnetdb mdf User Instance true        providerName  System Data SqlClient    gt       lt add name  Live1  connectionString  Data Source Live Initial Catalog LiveDatabase Integrated Security True        providerName  System Data SqlClient    gt     lt  connectionStrings gt      lt system web gt       lt compilation xdt Transform  RemoveAttributes debug     gt     lt  system web gt    lt  configuration gt    And this is my Web config code    lt  xml version  1 0   gt    lt  -- For more information on how to configure your ASP NET application  please visit http   go microsoft com fwlink  LinkId 169433 -- gt   lt configuration gt      lt system web gt       lt compilation debug  true  targetFramework  4 0    gt        lt authentication mode  Forms  gt          lt forms loginUrl    Account Login aspx  timeout  2880    gt       lt  authentication gt        lt membership gt          lt providers gt             lt clear  gt             lt add name  AspNetSqlMembershipProvider  type  System Web Security SqlMembershipProvider  connectionStringName  ApplicationServices           enablePasswordRetrieval  false  enablePasswordReset  true  requiresQuestionAndAnswer  false  requiresUniqueEmail  false           maxInvalidPasswordAttempts  5  minRequiredPasswordLength  6  minRequiredNonalphanumericCharacters  0  passwordAttemptWindow  10           applicationName       gt          lt  providers gt       lt  membership gt        lt profile gt          lt providers gt             lt clear  gt             lt add name  AspNetSqlProfileProvider  type  System Web Profile SqlProfileProvider  connectionStringName  ApplicationServices  applicationName      gt          lt  providers gt       lt  profile gt        lt roleManager enabled  false  gt          lt providers gt             lt clear  gt             lt add name  AspNetSqlRoleProvider  type  System Web Security SqlRoleProvider  connectionStringName  ApplicationServices  applicationName       gt       lt add name  AspNetWindowsTokenRoleProvider  type  System Web Security WindowsTokenRoleProvider  applicationName       gt          lt  providers gt       lt  roleManager gt      lt  system web gt      lt system webServer gt       lt modules runAllManagedModulesForAllRequests  true   gt     lt  system webServer gt   lt  configuration gt    When I publish my project there is nothing showing in my Web config file it Is not showing my Live Database connection string

User · Answer

It is possible using ConfigTransform build target available as a Nuget package - https   www nuget org packages CodeAssassin ConfigTransform      All  web   config  transform files will be transformed and output as a   series of  web   config transformed  files in the build output   directory regardless of the chosen build configuration       The same applies to  app   config  transform files in non-web   projects    and then adding the following target to your   csproj     lt Target Name  TransformActiveConfiguration  Condition  Exists    ProjectDir  Web   Configuration  config    BeforeTargets  Compile   gt       lt TransformXml Source    ProjectDir  Web Config  Transform    ProjectDir  Web   Configuration  config  Destination    TargetDir  Web config    gt   lt  Target gt    Posting an answer as this is the first Stackoverflow post that appears in Google on the subject

User · Answer

The web config transforms that are part of Visual Studio 2010 use XSLT in order to  transform  the current web config file into its  Debug or  Release version   In your  Debug  Release files  you need to add the following parameter in your connection string fields   xdt Transform  SetAttributes  xdt Locator  Match name     This will cause each connection string line to find the matching name and update the attributes accordingly   Note  You won t have to worry about updating your providerName parameter in the transform files  since they don t change   Here s an example from one of my apps  Here s the web config file section    lt connectionStrings gt         lt add name  EAF  connectionString   Test Connection String     gt   lt  connectionString gt    And here s the web config release section doing the proper transform    lt connectionStrings gt         lt add name  EAF  connectionString   Prod Connection String              xdt Transform  SetAttributes             xdt Locator  Match name     gt   lt  connectionStrings gt    One added note  Transforms only occur when you publish the site  not when you simply run it with F5 or CTRL F5  If you need to run an update against a given config locally  you will have to manually change your Web config file for this   For more details you can see the MSDN documentation   https   msdn microsoft com en-us library dd465326 VS 100  aspx

User · Answer

To make the transform work in development  using F5 or CTRL   F5  I drop ctt exe  https   ctt codeplex com   in the packages folder  packages ConfigTransform ctt exe    Then I register a pre- or post-build event in Visual Studio       SolutionDir packages ConfigTransform ctt exe source    ProjectDir connectionStrings config  transform    ProjectDir connectionStrings   ConfigurationName  config  destination    ProjectDir connectionStrings config    SolutionDir packages ConfigTransform ctt exe source    ProjectDir web config  transform    ProjectDir web   ConfigurationName  config  destination    ProjectDir web config    For the transforms I use SlowCheeta VS extension  https   visualstudiogallery msdn microsoft com 69023d00-a4f9-4a34-a6cd-7e854ba318b5

User · Answer

If your are going to replace all of the connection strings with news ones for production environment  you can simply replace all connection strings with production ones using this syntax    lt configuration xmlns xdt  http   schemas microsoft com XML-Document-Transform  gt    lt connectionStrings xdt Transform  Replace  gt       lt  -- production environment config --- gt       lt add name  ApplicationServices  connectionString  data source   SQLEXPRESS Integrated Security SSPI AttachDBFilename  DataDirectory  aspnetdb mdf User Instance true        providerName  System Data SqlClient    gt       lt add name  Testing1  connectionString  Data Source test Initial Catalog TestDatabase Integrated Security True        providerName  System Data SqlClient    gt   lt  connectionStrings gt         Information for this answer are brought from this answer and this blog post   notice  As others explained already  this setting will apply only when application publishes not when running debugging it  by hitting F5

[c#] Web.Config Debug/Release

Examples related to c#

Examples related to asp.net

Examples related to web-config