title: Best way to do cross database union query in EF code first
body: <p>i'm working on an ASP.NET MVC project with EF code first as database modelling. 
  It's a multi user application in which everyone has it's own database, what i need now is the ability to list all Posts of all the user using the platform, so i search for cross database querying.
  It seem EF doesn't support this type of query because the dbcontext is linked to a fixed connection string, then i ask you which method i can develop to achive my goal?</p>
  
  <p>I was thinking on using two dbcontext, one for the database of the user and another database containing the data of all users, trying to duplicate CRUD operation both in personal and global database, but it seem very odd to do.</p>
  
  <p>Any suggestion? Thanks in advance.</p>