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 valuethat 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>