Using multiple databases within one application (ASP.NET MVC, LINQ to SQL)
- by Alex
I have a web application made for several groups of people not connected with each other. Instead of using one database for all of them, I'm thinking about making separate databases.
This will improve the speed of the queries and make me free from checking to what group the user belongs.
But since I'm working with LINQ to SQL, my classes are explicitly connected with the databases, so I will have to make separate DataContexts for all of the databases.
So how can I solve this problem? Or should I just not bother and use one database only?