title: Linq to Json using Like Clause
body: <p>I've got an MVC 3 web app and am returning a JSON object which I would like to use Linq against to limit the result returned to the client jquery.</p>
  
  <p>The Json response takes the following structure:</p>
  
  <pre><code>{
    "Data": {
  "Items": [
    {
      "Result": {
        "Id": "e2ba4912-c387-4f54-b55e-06742a6858db",
        "Name": "SomeOtherSetting",
        "Value": "500",
        "Archived": false
       },
      "Result": {
        "Id": "17c27584-cea8-42c2-b6c4-0b30625ac3ce",
        "Name": "Setting2",
        "Value": "600",
        "Archived": false
      },
      "Result": {
        "Id": "17c27584-cea8-42c2-b6c4-0b30625ac3ce",
        "Name": "Setting3",
        "Value": "700",
        "Archived": false
      }
     }]
  }
  }
  </code></pre>
  
  <p>....</p>
  
  <p>I need to return or grab just the json items that have a Name like 'Setting' for example. In the example, this would return just the 2 Json nodes.</p>
  
  <p>My Linq is very limited and what I have is: Settings is where the Json response is stored.</p>
  
  <pre><code>NewtonSoft.Json.Linq.JObject data = NewtonSoft.Json.Linq.JObject.Parse(Settings);
  
  var result = from p in data["Data"]["Items"].Children()
      where (p["Result"]["Name"].Contains("Expenses.Help.Tip"))
       select new { Name = (string)p["Result"]["Name"], Value = (string)p["Result"]["Value"] };
  </code></pre>
  
  <p>When I run this I get nothing in my result. Can anyone help and tell me what I'm doing wrong?</p>
  
  <p>Thanks.</p>