title: c# to query a json file
body: <p>I have a json file as such:</p>
  
  <pre><code> {
    "rowId": "39",
    "refNumber": "19",
    "title": "Mobile",
    "date": "10/29/2015",
    "status": "saved"
   }{
    "rowId": "10",
    "refNumber": "478",
    "title": "Completion",
    "date": "10/30/2015",
    "status": "saved"
   }{
     "rowId": "11",
     "refNumber": "604",
     "title": "Online Order",
     "date": "10/30/2015",
     "status": "failed"
    }
  </code></pre>
  
  <p>What I'd like to do is query the json file in c# like as such with a winforms app:</p>
  
  <pre><code>string qrySaved = "select count(*) as total from file where status = 'saved'";
  string qryFailed = "select count(*) as total from file where status = 'failed'";
  </code></pre>
  
  <p>Then place the results in two variables.</p>
  
  <p>I did the following:</p>
  
  <pre><code> logFolder = Directory.GetCurrentDirectory();
   logFolder = logFolder.Replace("\\bin\\Debug", "\\metrics");
   logFile = logFolder + @"\log.json";
  </code></pre>
  
  <p>I'm using the Newtonsoft.Json nuget resource and know how to read the first object but can't figure out how to query the file to return total counts based on a given element.</p>