How can I join datasets from multiple tables with only certain columns in EF Core?

Entity Framework left join on multiple tables creates inner join instead

Only one of the four tables in the query I'm trying to build will be guaranteed to exist. Creating left joins in EF has always worked for me, but never with more than one join. This is the problem:... var details = (from planInfo in context.PlanInfo join templateRec in context.ProductTemplates on planInfo.Temp...

EF Core multiple left joins

ZZZ_tmp

EF Core Left Join and then Inner Join

ZZZ_tmp

EF Core Linq join on multiple columns throws NullReference Exception

ZZZ_tmp

How to call Stored Procedure with join on multiple tables in Entity Framework Core?

ZZZ_tmp

How to implement a left join with some condition on second table in EF / EF Core?

ZZZ_tmp

EF Core Join using Include but ForeignKey is not Primary Key on the other table

ZZZ_tmp

INNER Join and LEFT OUTER JOIN in EF-Core with Linq

ZZZ_tmp

EF Core - How to group by a nullable column through multiple joins

ZZZ_tmp

EF Core Navigation Property Include uses Left Join instead of Inner Join

ZZZ_tmp