title: C# Mongodb. Find item in array and select only this item
body: <p>I have User object:  </p>
  
  <pre><code>{ 
      "_id" : ObjectId("599e670f2720317af451db9e"),
      "Cars" : [
          {
              "Name" : "Car 1",
              "Labels" : [
                  {
                      "Label" : "Main", 
                      "Color" : "#F49973"
                  }
              ]
          }, 
          {
              "Name" : "Car 2",               
              "Labels" : [    
                  {
                      "Label" : "Main", 
                      "Color" : "#F49973"
                  },
                  {
                      "Label" : "Secondary", 
                      "Color" : "#E2E2E2"
                  }
  
              ]
          }
      ]
  }
  </code></pre>
  
  <p>I want to find document by user id and car name, then select this car. I am trying to do this:</p>
  
  <pre><code> await _collection.AsQueryable().Where(u =&gt; u.Id == someId &amp;&amp; u.Cars.Any(s =&gt; s.Name == someName))
                  .Select(u =&gt; u.Cars[-1])
                  .SingleOrDefaultAsync();
  </code></pre>
  
  <p>In result, I want to get single <code>Car</code> object, but, I get <code>null</code>. How to properly to do it?</p>