JSON Parsing to LINQ with JSON.Net
<p>Need to transform the following JSON string to LINQ using NewtonSoft library. It is an array of "issues".
The LINQ should be able to provide the data as table with status,count(Key) grouped by status</p>

<pre><code>{
"expand":"schema,names",
"startAt":0,
"maxResults":50,
"total":10,
"issues":[{
    "expand":"editmeta,renderedFields,transitions,changelog,operations",
    "id":"31720",
    "self":"TEST",
    "key":"12107",
    "fields":{
            "progress":{"progress":0,"total":0},
            "summary":"Screen blinking",
            "customfield_13001":null,
            "issuetype":{"name":"Bug","subtask":false},
            "resolution":null,
            "fixVersions":[{"name":"Backlog","archived":false,"released":false}],
            "updated":"2013-03-12T10:10:17.000-0500",
            "created":"2013-03-07T17:34:46.000-0600",
            "customfield_10606":{"value":"Sev-2 (Critical/High)","id":"10925"},
            "status":{"name":"Postponed","id":"10000"},

         }
                  },
                 {..
               ..}]}
</code></pre>

<p>Have tried the following </p>

<pre><code>               Newtonsoft.Json.Linq.JObject jObject = Newtonsoft.Json.Linq.JObject.Parse(result);

                var allPaths = from p in jObject["issues"].Children()
                              select new
                               {
                                   Res = (string)p["resolution"],
                                   Key = (string)p["Key"].ToString()
                               };
</code></pre>

<p>Table should look like:</p>

<pre><code>           Status        Count(Key)
           --------------------------------
            Postponed     2
            Resolved     1
</code></pre>
