How to sum specific item in json arrray object, linq prefer on C#

Question

Hi I'm working on Json Deserialize Object on C# using json newton. Below is my code.

 transactions = JsonConvert.DeserializeObject<List<TransactionClass>>(response.Content);

And returned results.

      [
        {
         "id":1,
         "school_uuid":"d17eab20-a442-11e9-928b-cb6a3dc8f7ea",
         "student_id":1,
         "actiontype":"1",
         "total":100,
         "created_at":"2019-07-12 01:54:45",
         "updated_at":"2019-07-12 01:54:45"
        },

        {
         "id":2,
         "school_uuid":"d17eab20-a442-11e9-928b-cb6a3dc8f7ea",
         "student_id":1,
         "actiontype":"1",
         "total":100,
         "created_at":"2019-07-12 01:55:28",
         "updated_at":"2019-07-12 01:55:28"
        }
     ]

I would like to sum for item total, In this case sum = 100 + 100 = 200. It work fine on looping method. But I prefer shorter like linq instead. Any advice or guidance on this would be greatly appreciated, Thanks.

[Are](https://stackoverflow.com/questions/14561312/) [you](https://stackoverflow.com/questions/29325589/) [too](https://stackoverflow.com/questions/1554926/) [lazy](https://stackoverflow.com/questions/641682/) [to](https://stackoverflow.com/questions/13230268/) [do](https://stackoverflow.com/questions/2978736/) [some](https://stackoverflow.com/questions/15417623/) [google](https://stackoverflow.com/questions/17717858/) [search](https://stackoverflow.com/questions/16250991/)? — vasily.sib, Jul 12 '19 at 02:53
@joenpcnpcsolution - Don't forget to use the `@` notification system so that your recipient gets notified. — Enigmativity, Jul 12 '19 at 03:15

score 2 · Accepted Answer · answered Jul 12 '19 at 02:42

2

using System.Linq;

int sumOfTotals = transactions.Sum(transaction => transaction.total);

Read this:

https://learn.microsoft.com/en-us/dotnet/api/system.linq.enumerable.sum?view=netframework-4.8

answered Jul 12 '19 at 02:42

cdev

5,043
2
33
32

Dear cdev, Thank you very much. – joenpc npcsolution Jul 12 '19 at 02:56
@cdev - Is there something in your "Read this" that you think is important for your answer? – Enigmativity Jul 12 '19 at 03:16
Dear Enigmativity, Thanks for more info. – joenpc npcsolution Jul 12 '19 at 08:03

How to sum specific item in json arrray object, linq prefer on C#

1 Answers1