LeftJoin and RightJoin are being introduced into .NET 10 (dotnet/runtime#110292); support for the new LeftJoin operator in EF is tracked by #12793. For RightJoin, we should eventually implement actual support for it (i.e. translate LINQ RightJoin to SQL RIGHT JOIN). However, until that's done, we can provide a default implementation that simply transforms RightJoin to LeftJoin (that would be #35452).
LeftJoin and RightJoin are being introduced into .NET 10 (dotnet/runtime#110292); support for the new LeftJoin operator in EF is tracked by #12793. For RightJoin, we should eventually implement actual support for it (i.e. translate LINQ RightJoin to SQL RIGHT JOIN). However, until that's done, we can provide a default implementation that simply transforms RightJoin to LeftJoin (that would be #35452).