title: Firebase/firesharp query
body: <p>I have some firebase data structured like this <a href="http://www.pcl.dk/firebase.png" rel="nofollow">http://www.pcl.dk/firebase.png</a>.
  I am trying to return a list of items as specified below.</p>
  
  <p>I am trying to get all the the 'choose1' and 'choose2' for the parent node called '49'. The unique IDs comes from my app, but are not relevant in this query.</p>
  
  <p>I have some code i used before, where i knew the path to the nodes, but since the unique IDs are sort random generated i dont know them in tis setup.</p>
  
  <p>In the code below i am stuck at linq 'Where' clause on how to get the choose1 and choose2 nodes.
  Can anyone help?</p>
  
  <pre><code>  public class ResultsEntity
      {     
          public string choose1;
          public string choose2;
      }
      public class ResultsFireBaseEntity
      { 
          public string choose1 { get; set; }
          public string choose2 { get; set; }
      }
  
      public static List&lt;ResultsEntity&gt; GetResults(string weekno)
      {
          List&lt;ResultsEntity&gt; sList = new List&lt;ResultsEntity&gt; { };
          FireSharp.Interfaces.IFirebaseClient _client = new FireSharp.FirebaseClient(firebaseConfig());
          FireSharp.Response.FirebaseResponse responseResults = _client.Get(weekno);
          var sChoose1 = "";
          var sChoose2 = "";
  
          try
          {
              List&lt;ResultsFireBaseEntity&gt; listOrderResult = responseResults.ResultAs&lt;List&lt;ResultsFireBaseEntity&gt;&gt;().ToList();
              sChoose1 = listOrderResult.Where(x =&gt; x.choose1 != null).Select(x =&gt; x.choose1).First();
              sChoose2 = listOrderResult.Where(x =&gt; x.choose2 != null).Select(x =&gt; x.choose2).First();
              sList.Add(new ResultsEntity { choose1 = sChoose1, choose2 = sChoose2 });
          }
          catch 
          { }
          return sList;
      }
  </code></pre>