asp.net mvc multiple connection strings

Question

I am creating asp.net MVC Application using MVC 3.0. I have 2 users but the DataBase is the same. So, Is it possible to setup two connection strings or even more in web.config? when user login, I redirect it to his database, so then he can use his DataBase.

So major issue here is to find out which user is logged in and use connection string for that user.

I am using default mvc account controller and for example when i want to display welcome message for user in my view i type: if (@User.Identity.Name == "UserName") then some message So where is the best place to find out which user is logged in and set his connection string in controller or in a view?

Answer 1

Yes, you can have as many connection strings in your web.config file as you want.

But, if you're designing a multi-tenant application than there are better ways of doing it than adding a connection string to web.config file every time a new user signs up.

Probably the best way for you is to have a single database where user-related tables have foreign keys to Users table.

You can learn more about multi-tenant architectures from this Microsoft article.