title: C# Linq: Can you merge DataContexts?
body: <p>Say I have one database, and this database has a set of tables that are general to all Clients and some tables that are specific to certain clients.</p>
  
  <p>Now what I have in mind is creating a primary <code>DataContext</code> that includes only the tables that are general to all the clients, and then create separate <code>DataContext</code>s that contain only the tables that are specific to the client.</p>
  
  <hr>
  
  <p><strong>Is there a way to kind of "merge" <code>DataContext</code>s so that it becomes one context?</strong>  So for Client A, I need one DataContext that includes both the general tables and also the tables for that specific client (retrieved from two different <code>DataContext</code>s) ? </p>
  
  <hr>
  
  <p><strong>[Update]</strong></p>
  
  <p>What I think I can do is, from the Partial Class of the DataContext instead of letting my DataContext inherit from <code>DataContext</code> I make it inherit from <code>MyDataContext</code>; that way, the  tables from <code>MyDataContext</code> and the other DataContext will be available in one <code>DataContext</code> class.</p>
  
  <p>What do you think about this approach?  Of course with something like this you can only merge two datacontexts at once though...</p>