Querying object's field array values in MongoDB

Question

If I have a class like this:

public class Car {
 public string Model { get; set; }
 public List<string> Types { get; set; }
}

and do:

Car _car = new Car();
_car.Model = "1992";
List<string> _types = new List<string>() { "New", "Old" };
_car.Types = _types

and save these kinds of objects in MongoDB, how do I get all cars that have type == "New" in C# MongoDB? I need to query Car.Type == "New" I'm going to visit the class and look in its "Types" array and find the matching object in the array and return the whole class.

Philipp · Accepted Answer · 2012-09-29 17:23:26Z

2

The MongoDB query language can access arrays transparently. So you can just do:

db.cars.find({Types:"New"})

and it will return all documents which have an entry in the Types array which is equal to the string "New". Check the documentation for more information.

answered Sep 29, 2012 at 17:23

Philipp

70.1k10 gold badges121 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying object's field array values in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related