Using multiple databases within one application

Posted by Alex on Stack Overflow See other posts from Stack Overflow or by Alex
Published on 2010-04-12T17:52:50Z Indexed on 2010/04/12 18:32 UTC
Read the original article Hit count: 233

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about asp.net-mvc

Related posts about linq-to-sql