.NET 6.0 and EF Core: How do I unit test EF Core LINQ Queries with a LEFT JOIN? I have a LINQ query which performs a LEFT JOIN on two tables:
