Hi
No need Multiple webconfig this scenario becos we can use one webconfig just change connection block like this
<connectionStrings>
<add name="StagingConnection" providerName="System.Data.SqlClient"
connectionString="Data Source=PCNAME;Initial Catalog=DBNAME;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=myPassword;" />
<add name="TestingConnection" providerName="System.Data.SqlClient"
connectionString="Data Source=PCNAME;Initial Catalog=DBNAME;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;" />
<add name="DevelopmentConnection" providerName="System.Data.SqlClient"
connectionString="Data Source=PCNAME;Initial Catalog=DBNAME;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;" />
<add name="ProductionConnection" providerName="System.Data.SqlClient"
connectionString="Data Source=PCNAME;Initial Catalog=DBNAME;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;" />
</connectionStrings>
refer this url for connectionstrings
http://www.connectionstrings.com/
https://www.connectionstrings.com/sql-server/
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com
Souravagar, if this helps please login to Mark As Answer. | Alert Moderator