Cross-DbContext LINQ queries for Entity Framework Core: join entities from different DbContexts (even different databases or providers) in a single LINQ query, with per-context SQL pushdown and semi-join optimization.