Suraj Dubey

Suraj Dubey

  • 885
  • 794
  • 39.3k

How to manage connection string dynamically

Dec 6 2021 9:18 AM

Hi,

I have a requirement like, developed an ASP.net web application. I want to host this application for different companies with seperate database, but website shall be hosted only one copy in IIS. so, based on user login, the application should connect different database server.

For Ex: if user "xxx" login with credential and belogs to "ABC" company and the database is "ABC", then ABC data need to display on the web page.

if user "XYZ" login with credential and belogs to "HGJ" company and the database is "HGJ", then HGJ data need to display on the web page.

Can any one give good solution for the same.
 


Answers (4)