You are preparing to deploy an ASP.NET application to a production server by publishing the application in Release configuration.
You need to ensure that the connection string value that is stored in the web.config file is updated to the production server’s connection string value during publishing.
What should you do?
A.
Add the following code to the web.config file.
<connectionStrings>
<add name=”DB” connectionString=”Server=ProdServer;Database=ProdDB;Integrated Security=SSPI;” providerName=”Release” />
</connectionStrings>
B.
Add the following code to the web.config file.
<connectionStrings>
<add name=”DB” connectionString=”Server=ProdServer;Database=ProdDB;Integrated Security=SSPI;” xdt:Transform=”Replace” xdt:Locator=”Match(name)” />
</connectionStrings>
C.
Add the following code to the web.release.config file.
<connectionStrings>
<add name=”DB” connectionString=”Server=ProdServer;Database=ProdDB;Integrated Security=SSPI;” providerName=”Release” />
</connectionStrings>
D.
Add the following code to the web.release.config file.
<connectionStrings>
<add name=”DB” connectionString=”Server=ProdServer;Database=ProdDB;Integrated Security=SSPI;” xdt:Transform=”Replace” xdt:Locator=”Match(name)” />
</connectionStrings>