title: Is it possible to perform one query linking to tables on 2 databases with Dapper?
body: <p>I have 2 databases, a master and a company. Both databases are on the same server currently but will eventually be on different servers. Is it possible to perform a query that joins tables across databases in dapper? My application is Asp.NET Core and the databases are MariaDB (so basically MySQL).</p>
  
  <p>Here is an example of a query I'm trying to perform:</p>
  
  <pre><code>select a.username, b.name from company.user a join master.lookup_user_type b on a.user_type_id = b.id
  </code></pre>
  
  <p>Maybe I'm confused what my actual question is, maybe I just need to figure out how to have one conncetion string that references multiple databases.</p>