How to change connection string based on subdomain in ASP.Net

Question

Consider that I want to create 10 websites in IIS each of them pointing to the same website on local hard drive each one running the same code but on different subdomainsubdomain1domaincom subdomain2domaincom  subdomain10domaincomHow can I add multiple connection strings in my webconfig file and bind each connection string to a different subdomain

dharmendr · Accepted Answer

Hi rohanpSince the webconfig file is common for all the subdomains you can add multiple connection string in the webconfig file like below for each sub domainltconnectionStringsgt    ltadd name 34subdomain134 connectionString34ServerDataBaseTestUIDsaPWDsa34 providerName34SystemDataSqlClient34 gt    ltadd name 34subdomain234 connectionString34ServerDataBaseTestUIDsaPWDsa34 providerName34SystemDataSqlClient34 gt    ltadd name 34subdomain334 connectionString34ServerDataBaseTestUIDsaPWDsa34 providerName34SystemDataSqlClient34 gtltconnectionStringsgtThen you can check for the current url using the below codestring url  HttpContextCurrentRequestUrlAbsoluteUriThen retrive the subdomain from the url Then use the proper connection string as per the subdomain

dharmendr · Answer

Hi rohanpRefer the below articleChange Modify connection string in WebConfig at Runtime in ASPNet using C and VBNet

How to change connection string based on subdomain in ASP.Net

Change (Modify) connection string in Web.Config at Runtime in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us