hi,
For my client, having 5 different branches(Retail Shop) in 5 different locations. Hence i thought of maintain "Five different SQL databases(C1,C2...C5) and One Master database(M)". This Master Database is for Maintaining "user Accounts" and "Login Details". Because only ADMIN can create userID and Password for Users, Which is stored here in Master DB.
My Problem is now, i can create an ASP.NET application with one "Connection String" which refer my "Master DB". Which check for Valid User and Logging in. But after Logging in, i would have different connection with different database which is "ClientDB"(branch database, C1 or C2 or...C5).
Now, Where should i maintain these ClientDB's connection String ???
In SESSION ?? (or) In master DB itself ? (or) Is there any other way to do it with high security ??
Please help me out...