Querying an array of arrays with the MongoDB C# driver

Question

My document look like :

"ID" : "fruit1",
"Keys" : [
           ["apple", "carrot"]
           ["banana"]
         ]

How do I query for Keys = "carrot" using MongoDB C# driver?

I can do it in shell :

db.multiArr.find({'Keys':{$elemMatch:{$elemMatch:{$in:['carrot']}}}})

I Found it from here : Querying an array of arrays in MongoDB

But I don't have succeed written it using c# driver.

possible duplicate of [Using both $in and $elemMatch using the C# Driver](http://stackoverflow.com/questions/22176263/using-both-in-and-elemmatch-using-the-c-sharp-driver) — i3arnon, Sep 08 '14 at 20:02

score 1 · Answer 1 · answered Sep 08 '14 at 20:35

Try something like this.

Note: I didn't test this.

MongoClient client = new MongoClient(); // connect to localhost
MongoServer server = client.GetServer();
var db = server.GetDatabase("foo");
var col = db.GetCollection<RawBsonDocument>("multiArr");

// Query = {'Keys':{$elemMatch:{$elemMatch:{$in:['carrot']}}}}
BsonDocument query = new BsonDocument{ 
    "Keys", new BsonDocument {
      "$elemMatch", new BsonDocument {
          "$elemMatch", new BsonDocument {
              "$in", new BsonArray().Add("carrot")
          }
      }
    }
};
col.Find(query);

More info: http://docs.mongodb.org/ecosystem/tutorial/use-csharp-driver/#csharp-driver-tutorial

score 0 · Accepted Answer · edited May 16 '15 at 05:29

0

I succeed with something not very biutifull :

var q = Query.ElemMatch("Keys", Query.In("$elemMatch", new List<BsonValue> { "carrot" }));

edited May 16 '15 at 05:29

Bhushan Firake

9,338
5
44
79

answered Sep 23 '14 at 13:30

Drobfr

11
3

How can query the Keys array if it was an object array instead of an string array ? – Misi Sep 27 '17 at 08:29

Querying an array of arrays with the MongoDB C# driver

2 Answers2