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 — i3arnon
– i3arnon, Commented Sep 8, 2014 at 20:02

Larry Battle · Accepted Answer · 2014-09-08 20:35:25Z

1

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

answered Sep 8, 2014 at 20:35

Larry Battle

9,1985 gold badges43 silver badges55 bronze badges

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

Comments

Bhushan Firake · Accepted Answer · 2015-05-16 05:29:18Z

0

I succeed with something not very biutifull :

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

edited May 16, 2015 at 5:29

Bhushan Firake

9,4825 gold badges47 silver badges79 bronze badges

answered Sep 23, 2014 at 13:30

Drobfr

113 bronze badges

1 Comment

Misi Over a year ago

How can query the Keys array if it was an object array instead of an string array ?

Collectives™ on Stack Overflow

Querying an array of arrays with the MongoDB C# driver

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related