title: asp.net mvc multiple connection strings
body: <p>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.</p>
  
  <p>So major issue here is to find out which user is logged in and use connection string for that user.</p>
  
  <p>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? </p>