how deployment asp.net with 2 different Connections

Question

Hi Guys Please Help Me I need to deploys app in the sever but in fact the system on the localhost contains with 2 ConnectionString in webconfig , at the same time when we install the database on the new server surely need to new connectionstring. In your opinion what is the most appropriate solution to this problem ?? Thanks

Abdalla Elawad · Answer

The following is connectionstring use on localhost / 2 conn sometimes Cash_PlanConn and sometimes Cash_PlanConne . when i make deployement surely path of database in new server change .

Abdalla Elawad · Answer

Hi Rajneesh Chaubey thank you for answer , but that mean i will modify all new connection to on reports and datasets , gridview , webform etc.. modify app as whole

Rajneesh Chaubey · Answer

In the end, we call a particular connection by add name(specified in connectionString url) "Sales" providerName= "System.Data.SqlClient" connectionString= "server=myserver;database=Products;uid= ;pwd= " /> "NorthWind" providerName= "System.Data.SqlClient" connectionString= "server=.;database=NorthWind;Integrated Security=SSPI" /> In your code: var conn1 = ConfigurationManager.ConnectionStrings[ "Sales" ].ConnectionString; var conn2 = ConfigurationManager.ConnectionStrings[ "NorthWind" ].ConnectionString;

how deployment asp.net with 2 different Connections

Answers (3)