Web.Config Debug/Release

by

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:

<connectionStrings>
      <add name="EAF" connectionString="[Test Connection String]" />
</connectionString>

And here’s the web.config.release section doing the proper transform:

<connectionStrings>
      <add name="EAF" connectionString="[Prod Connection String]"
           xdt:Transform="SetAttributes"
           xdt:Locator="Match(name)" />
</connectionStrings>

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

More Related Contents:

  1. Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’
  2. How to force HTTPS using a web.config file
  3. Read connection string from web.config
  4. IIS Server & ASP.Net Core – 500.19 with error code 0x8007000d on httpplatformhandler tag
  5. How to set web.config file to show full error message
  6. How can I secure passwords stored inside web.config?
  7. Encrypting Web.Config
  8. How can I add an ampersand for a value in a ASP.net/C# app config file value
  9. ConfigurationManager.AppSettings getting null?
  10. How to read appSettings section in the web.config file?
  11. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
  12. How to use __doPostBack()
  13. Can’t get Czech characters while generating a PDF
  14. HttpContext.Current.Session is null when routing requests
  15. Proper JSON serialization in MVC 4
  16. Foreach loop, determine which is the last iteration of the loop
  17. Create thumbnail image
  18. How to recognize if a string contains unicode chars?
  19. IIS Express Immediately shutting-down running site after stopping web application
  20. Opening password-protected pdf file with iTextSharp
  21. Comparing Object properties using reflection
  22. No IUserTokenProvider is registered
  23. how safe is it to use session variables – asp.net / c#
  24. ASP.Net double-click problem
  25. Making an entire row clickable in a gridview
  26. Explicit construction of entity type [MyClass] in query is not allowed
  27. Web Service without adding a reference?
  28. How to maintain the value of label after postback in Asp.net? [closed]
  29. difference between http.context.user and thread.currentprincipal and when to use them?
  30. How do I call a method in a Master Page from a content’s code-behind page?

Leave a Comment