.𝗡𝗘𝗧 𝟭𝟬 𝗠𝗮𝗸𝗲𝘀 𝗟𝗘𝗙𝗧 & 𝗥𝗜𝗚𝗛𝗧 𝗝𝗼𝗶𝗻𝘀 𝗘𝗮𝘀𝗶𝗲𝗿 𝗧𝗵𝗮𝗻 𝗘𝘃𝗲𝗿!

If you’ve ever struggled to write complex LEFT JOINs in LINQ, you’ll love what’s coming in .NET 10.

No more juggling SelectMany, GroupJoin, and DefaultIfEmpty — Microsoft just made it clean, readable, and developer-friendly!

In .NET 10, LINQ gets first-class support for LeftJoin() and RightJoin() operators.

These new methods simplify your EF Core queries, letting you write cleaner and more intuitive joins — just like SQL, but in pure C#.

And yes — EF 10 also supports RightJoin(), which keeps all records from the second collection while joining matching data from the first.

This is a huge win for developers working with Entity Framework Core and complex relationships!

How do you think the new LeftJoin() and RightJoin() methods will change the way you write LINQ queries in your .NET projects?