How to write linq query from JSON file

Question

I have a JSON file. I want to get all Guid lists from validation. I tried to get options of validation. Then iterate this list and all Guid lists using id. items.FirstOrDefault(x => x.Key == "validate").Value.Options; How to write LINQ query for this. Below is the sample JSON.

{
"validation": {
          "options": [
            "Fail",
            "Success",
            "Resume"
          ],
          "extras": {
            "Fail" : {
            "id": "892DB3B6-BE0D-49F8-995A-50E921C2B778"
            },
             "Success" : {
            "id": "BC0EDB51-8317-4AFB-915F-B0579FADB500"
            },
             "Resume" : {
            "id": "59786216-FF4A-4E5C-ACB2-1BCE0A6E8D7d"
            }
          }
        }
        
        "vm": {
          "options": [
            "vm1",
            "vm2",
            "vm3"
          ],
          "extras": {
            "vm1" : {
            "id": "433DB3B6-BE0D-49F8-9D5A-50E921C2B999"
            },
             "Success" : {
            "id": "RT0EDB51-8317-4AFB-915F-B0579FADB888"
            },
             "Resume" : {
            "id": "44C86216-FF4A-4E5C-ACB2-1BCE0A6E9675"
            }
          }
        }
    }

There is no such a built-in functionality in C#. What library do you use to work with Json? — Serg, May 03 '23 at 19:52
Also may be helpful https://stackoverflow.com/a/71018559/2011071 — Serg, May 03 '23 at 19:53

score 0 · Accepted Answer · answered May 03 '23 at 22:04

First, the option list is received and then the id based on that option is received and use "Newtonsoft.Json"

string RootName = "validation";
string extrasName = "extras";
string optionsName = "options";

JObject sample = (JObject)JsonConvert.DeserializeObject(jsonString);
IJEnumerable<JToken> items = sample[RootName][optionsName].Values();


List<Guid> result = new List<Guid>();

foreach (var content in items)
{
    var typeoptions = content.Value<string>();
    string valueitem = sample[RootName][extrasName][typeoptions]["id"].Value<string>();
        result.Add(Guid.Parse(valueitem));
}

How to write linq query from JSON file

1 Answers1