How to combine multiple left outer joins?

[kldevg]

It's unclear from the article how should this work for a combination of left outer joins.

I'm trying to do something like: var query = (from person in people join pet in pets on person equals pet.Owner into gj from subpet in gj.DefaultIfEmpty() join toy in toys on subpet.person.Name equals toy.Owner into gj2 from subtoy in gj2.DefaultIfEmpty() select /* stuff... */).ToList();

But this gives the exception: System.InvalidCastException: 'Unable to cast object of type 'Remotion.Linq.Clauses.JoinClause' to type 'Remotion.Linq.Clauses.FromClauseBase'.'

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: d433265d-15f4-bd2e-a3d1-8148a3968783
• Version Independent ID: 75d2c893-1d07-f836-62f1-e767edfcebac
• Content: Perform left outer joins (LINQ in C#)
• Content Source: docs/csharp/linq/perform-left-outer-joins.md
• Product: dotnet-csharp
• GitHub Login: @BillWagner
• Microsoft Alias: wiwagn

[svick]

@kldevg That exception looks like a bug in the LINQ provider you're using. Have you considered reporting it to the maintainer of that LINQ provider? Or have you tried it with a different LINQ provider?

[BillWagner]

closing due to lack of response.

[VineST]

I experienced this as well, with NHibernate.