Extract a JSON property using LINQ

Question

I have a json object as the following:

{
    "search-results": {
        "results-count": "2"
        "entry": [
            {
                "id": "0",
                "count": "10",
            },
            {
                "id": "1",
                "count": "22",
            }
        ]
    }
}

I would like to get the sum of counts; 32 in this example. I am looking into doing this using LINQ, but any more "readable" alternative would be appreciate.

Just like a simple linq query like searchresults.entry.Sum(i => i.count); ? — Selim Yildiz
– Selim Yildiz, Commented Sep 15, 2019 at 18:52
What have you tried so far? Please add your LINQ as well to question. — Selim Yildiz
– Selim Yildiz, Commented Sep 15, 2019 at 19:00

Selim Yildiz · Accepted Answer · 2019-09-15 19:15:28Z

1

Try this:

var json = @"{
        'search-results': {
                    'results-count': '2',
                    'entry': [
                    {
                        'id': 0,
                        'count': 10,
                    },
                    {
                        'id': 1,
                        'count': 22,
                    }
            ]
        }
    }";


JObject searchResult = JObject.Parse(json);
int sum = (from entry in searchResult["search-results"]["entry"]
            select (int)entry["count"]).Sum();

answered Sep 15, 2019 at 19:15

Selim Yildiz

5,3906 gold badges22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anu Viswan · Accepted Answer · 2019-09-16 00:13:16Z

1

You could do it with Linq. For example,

var jobject = JObject.Parse(jsonString);
var result = jobject["search-results"]["entry"].Sum(x=>Convert.ToInt32(x["count"]));

answered Sep 16, 2019 at 0:13

Anu Viswan

18.2k4 gold badges27 silver badges53 bronze badges

Collectives™ on Stack Overflow

Extract a JSON property using LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related