[API Proposal]: Add left join

[Mr0N]

Background and motivation

I suggest adding the LeftJoin method to Linq JObject, it is useful if you need to find elements that were not joined

API Proposal

API Usage

var en = Enumerable.Range(1, 10).Select(a=>a.ToString());
var en2 = Enumerable.Range(1, 5).Select(a => a.ToString());



var result = en2.LeftJoin(en, a => a, x => x, (en2, en) =>
{
    return new { joinResultEn = en,joinResultEn2=en2};
})
    .Where(a=>a.joinResultEn is null)
    .ToList();//

Alternative Designs

No response

Risks

No response

[ghost]

Tagging subscribers to this area: @dotnet/area-system-linq
See info in area-owners.md if you want to be subscribed.

Issue Details

---

Background and motivation

I suggest adding the LeftJoin method to Linq JObject, it is useful if you need to find elements that were not joined

API Proposal

API Usage

var en = Enumerable.Range(1, 10).Select(a=>a.ToString());
var en2 = Enumerable.Range(1, 5).Select(a => a.ToString());



var result = en2.LeftJoin(en, a => a, x => x, (en2, en) =>
{
    return new { joinResultEn = en,joinResultEn2=en2};
})
    .Where(a=>a.joinResultEn is null)
    .ToList();//select element is not find left join

Alternative Designs

No response

Risks

No response

Author:	Mr0N
Assignees:	-
Labels:	api-suggestion, area-System.Linq
Milestone:	-

[Abdragiz]

https://learn.microsoft.com/en-us/dotnet/csharp/linq/perform-left-outer-joins

As far as I understand, it's possible to perform a left join with the existing API.

[roji]

Closing in favor of #110292, which is a full API proposal.

[roji]

Duplicate of #110292