Join on tables from different DbContext - model first

Solutions with one EF6 model (db first) and one code first

Okay, let's resolve this. In essence, this is impossible if a relationship is shared between the two contexts. However, it functions if you use a different connection for both....I appreciate Ben Robinson's help in directing me in the proper way.

Entity Framework left join on multiple tables creates inner join instead

ZZZ_tmp

Entity Framework 6 - Missing table with only primary keys referencing different tables

ZZZ_tmp

Joining multiple tables from different databases

ZZZ_tmp

Scaffold-DbContext creating model for table without a primary key

ZZZ_tmp

How to map Table Valued Functions in EF6 Code First with different column names?

ZZZ_tmp

One to One Relationship with Different Primary Key in EF 6.1 Code First

one-to-one... a connection with an explicit FK attribute (such as your...PayGroup.SupervisorId... () is not accepted....Take that property out of the model, then:...public class PayGroup { public int Id { get; set; } public virtual Employee Supervisor { get; set; } } ...and use the following fluent mapping:...modelBuilder.Entity<PayGroup>()...

Entity Framework Core 2 one to one relationship "on one table"

ZZZ_tmp

Different between DbContext.Find() and DbContext.SingleOrDefault() Entity Framework Core

ZZZ_tmp

How do process form data and extract properties for two different models/tables using Entity Framework

ZZZ_tmp