title: linq to sql query with 2 dbml files
body: <p>I have a object of <code>MyFriendFollowStatus</code> , for each friend I need information from 2 different databases, so I wrote something like this</p>
  
  <pre><code>db1Context FFdb = new db1Context();
  db2Context EEdb = new db2Context();
  
  foreach (fbFriendsFollowStatus a in fbids)
  {
      long ffID = FFdb.FFUsers.Where(x =&gt; x.FacebookID == a.fbid).FirstOrDefault().FFUserID;
      a.ffID = ffID;
      int status = EEdb.StatusTable(x =&gt; x.ffID == ffid).FirstOrDefault().Status;
      a.Status = status;
  }
  </code></pre>
  
  <p>this works, but it doesnt really seem right calling 2 databases - once each for each user , is there something built in LinqToSql that helps with something like this?  or sometype of join I can use using 2 different databases?</p>