I'm working on a developing a web application which is having several databases with the same schema. Depends on the logged in user the database to execute queries may differ.

I'm planning to have connection string for each DB and when executing the query in the repository level change the connection string when the DB context is creating.

My problem is that I've tried to pass the connection string name to the DB context dynamically before executing the linq query, but failed. 

Would be grate if someone can help me on doing this and also let me know any pros and cons in this approach.