Login multiple db
I have made a web application where I have multiple user databases. On my Default page I have a Dropdownlist and each selection presents a user database. I have a custom membership provider and I could load the Login user control with the appropriate membership provider set. But the ting is: I don't want to set multiple connectionstrings i my web.config, and I don't want to create an application for each db.
I want to get the db name, pwd etc. from a database and then create the connectionstring when the selection has been made or in the LoggingIn event handler. I guess the only solution is to write a class that gets the db name and pwd from the database, decrypt it in some way and create the connectionstring.
I just wonder if anyone has any thoughts on how to do this in a way that doesn't create any security issues.