title: Does EF Code First support querying multiple databases?
body: <p>We are using Entity Framework Code First for the first time in our org. One of our queries must span two databases. Here's a SQL query:</p>
  
  <p>SELECT t1.col, t2.col
    FROM DB1..table1 t1
    INNER JOIN DB2..table2 t2 ON t1.key = t2.key</p>
  
  <p>From all of my searching, I don't believe that Code First can support this query. The two workarounds I've read about are creating a view in DB1 that reads DB2.table2, and then do all the queries against DB1 only. The other option is to do separate reads against DB1 and DB2, then merge the data in code.</p>
  
  <p>We're concerned about setting up a bunch of views because it just clutters the DB, and we are worried about performance when merging data.</p>
  
  <p>Is it possible to support the above query through Code First?</p>
  
  <p>Thanks all.</p>
  
  <p>-Troy </p>