Hi I have two sql server instances, one is normal and the other is backup mode that is the replication of the normal.
I have a portal in the web site. For a specific group in database and users in AD can login in backup mode. For others, they can login normal one.
Now I am using configuration file to swith the connection strings manully.
How to do it automatelly with code?