title: EF Core Table does not exist when joining from multiple DbContext
body: <p>I am facing an issue when trying to join 2 tables from 2 DbContext which represents different databases.</p>
  
  <p>I am using Fluent API to create foreign key relationship between 2 tables.
  Here are the Dbcontext configuration and models.</p>
  
  <pre><code>public class DbContextDemo1: DbContext
  {
     public DbSet&lt;Agency&gt; Agencies { get; set; }
  
     public DbContextDemo1(DbContextOptions&lt;DbContextDemo1&gt; options)
          : base(options)
     {
     }
  
     protected override void OnModelCreating(ModelBuilder modelBuilder)
     {
          modelBuilder.HasDefaultSchema("db1")
                      .Entity&lt;Agency&gt;()
                      .ToTable("agencies")
                      .HasKey(agency =&gt; agency.Id)
                      .HasOne(agency =&gt; agency.AgencyApp)
                      .WithOne(app =&gt; app.Agency)
                      .HasForeignKey&lt;Agency&gt;(agency =&gt; agency.Id);
  
      }
  }
  
  public class DbContextDemo2: DbContext
  {
     public DbSet&lt;AgencyApp&gt; AgencyApps { get; set; }
  
     public DbContextDemo2(DbContextOptions&lt;DbContextDemo2&gt; options)
          : base(options)
     {
     }
     protected override void OnModelCreating(ModelBuilder modelBuilder)
     {
          modelBuilder.HasDefaultSchema("db2")
                      .Entity&lt;AgencyApp&gt;()
                      .ToTable("agenciesapps")
                      .HasKey(app =&gt; app .Id)
                      .HasOne(app=&gt; app.Agency)
                      .WithOne(agency =&gt; agency.AgencyApp)
                      .HasForeignKey&lt;AgencyApp&gt;(app=&gt; app.AgencyId);         
  
      }
  }
  </code></pre>
  
  <p>Here are the Models:</p>
  
  <pre><code>public class Agency
  {
      public Guid Id { get; set; }
  
      public AgencyApp AgencyApp { get; set; }
  }
  
  public class AgencyApp
  {
      public Guid Id { get; set; }
  
      public Guid AgencyId { get; set; }
  
      public Agency Agency { get; set; }
  }
  </code></pre>
  
  <p>Now, When I try to get Agencies data along with AgencyApp. </p>
  
  <pre><code>var result = _dbContextDemo1.Agencies.Include(agency =&gt; agency.AgencyApplication)
  </code></pre>
  
  <p>It throws an error </p>
  
  <blockquote>
    <p>"Table 'db2.agenciesapps' doesn't exist". </p>
  </blockquote>
  
  <p>I can see in server console it is doing inner join between these two tables.</p>
  
  <p>Help would be hightly appreciated. Thanks</p>