Redirecting to another db.

  • Thread starter Thread starter MA
  • Start date Start date
M

MA

Hi all!

I´m building an asp.net application and want to use a login for this.

I was thinking about using a separate database for user identification and
then redirect to a different database, depending on the user information.

Lets say that user1 shoul be redirected to company1 database and user2 to
company2 database, still using the same application.

How to do this in an easy way?
Any ideas and comments are welcome.

/Marre
 
If the database connection strings are fairly static, maybe you could store
them (encrypted) in the user identification database and when the user logs
on, you extract their specific connection string and use that throughout
their session.
You don't really need to 'redirect' databases, just change the connection
string to access them.
 
Back
Top