How to use List<JObject>to complete multiple joins through strings, and how to implement multiple connection conditions?

[liuzhaolei107]

Description

Creates two Lists:

List<JObject> list1 = new List<JObject>
{
    new JObject { {"id", 1}, {"name", "John" } },
    new JObject { {"id", 2}, {"name", "Jane" } }
};

List<JObject> list2 = new List<JObject>
{
    new JObject { {"id", 1}, {"age", 25 } },
    new JObject { {"id", 2}, {"age", 30 } },
    new JObject { {"id", 3}, {"age", 35 } }
};

var joinedResult = list1.AsQueryable()
                         .Join(list2.AsQueryable(),
                               j1 => j1.Value<int>("id"),
                               j2 => j2.Value<int>("id"),
                               (j1, j2) => new JObject
                               {
                               { "id", j1["id"] },
                               { "name", j1["name"] },
                               { "age", j2["age"] }
                               });

If there is no question, ask how to describe it in a plain way. How to write if there are many linked conditions?

[liuzhaolei107]

[StefH]

@liuzhaolei107
Sorry, I do not understand your question.

Please rephrase or create a https://dotnetfiddle.net/ to show to error.

[liuzhaolei107]

这是来自QQ邮箱的假期自动回复邮件。您好，我最近正在休假中，无法亲自回复您的邮件。我将在假期结束后，尽快给您回复。 ``` This is a holiday automatic reply email from QQ mailbox. Hello, I am currently on vacation and cannot reply to your email personally. I will reply to you as soon as possible after the vacation. ```

[StefH]

@liuzhaolei107
Sorry, I do not understand your question.

Please rephrase or create a https://dotnetfiddle.net/ to show to error.

[liuzhaolei107]

这是来自QQ邮箱的假期自动回复邮件。您好，我最近正在休假中，无法亲自回复您的邮件。我将在假期结束后，尽快给您回复。