Monday, May 24, 2004

Single application, multiple users with their own databases?

For no special reason I've been kicking around thoughts about the best way to manage connection string in an ASP .NET application where users each have their own database.

IE we have user A whose database is database A.
user B is in database B.

One solution is to have them log in with a domain user name, then parse the domain to a configuration key to snag their connection string on data access pages.

This seems kind of clunky to me though, any better ideas?


Post a Comment

<< Home