Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gopalchettri
Starting Member
1 Post |
 Posted - 2012-01-30 : 01:43:45
|
| I have multiple databases say DB1, DB2, DB3 and MembershipDB. Every Database has GUID column named ApplicationID & set of Users having MembershipID as GUID. Each User of every Database is Isolated (have no relationship) with User of other Database. Membership Database contains the Users MembershipID and Database’s ApplicationID , password, username, email etc.I need to create a common login system like When a user provides his login credential authentication is to be done from MembershipDB and his data is to be fetched from the database he is registered to.Eg: a user from DB1 provides his login details, authentication is done from membershipDB. Now rest of his data is to be fetched from DB1(as he is registered to DB1) to his dashboard. I am bit confuse how to build this login system.Authentication part is no problem. But how to connect to the correct DB to get the correct data for the user.All the valuable comments and suggestions are welcome.I am using Microsoft SQL SERVER 2008, Entity Framework 4.2 (database ist approach), WCF, asp.net MVC 4gopalchettri |
|
|
|
|
|
Fetching data from multiple database