Insert in to a nested array Using C# Official Driver MongoDB

Question

Here is my exact schema:

{
  "_id" : ObjectId("4fb4fd04b748611ca8da0d48"),
  "Name" : "Categories",
  "categories" : [{
      "_id" : ObjectId("4fb4fd04b748611ca8da0d46"),
      "name" : "Naming_Conventions",
      "sub-categories" : [{
          "_id" : ObjectId("4fb4fd04b748611ca8da0d47"),
          "name" : "Namespace_Naming",
          "standards" : []
        }]
    }]
}

As you can see I have an array named "standards" nested way down in there. How would I programmatically insert in to that using the C# driver? I have tried all of the examples I have found online but none of them are working.

Craig Wilson · Accepted Answer · 2012-05-17 15:18:12Z

2

Something like the below. Obviously, if any of these are not present on the way down to it, you're going to get a null reference exception.

var doc = collection.FindOne(Query.EQ("_id", new ObjectId("4fb4fd04b748611ca8da0d48")));

var standards = doc["categories"]
    .AsBsonArray[0]
    .AsBsonDocument["sub-categories"]
    .AsBsonArray;

standards.Add(new BsonDocument());

collection.Save(doc);

edited May 17, 2012 at 15:18

answered May 17, 2012 at 14:52

Craig Wilson

12.7k3 gold badges45 silver badges45 bronze badges

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

3 Comments

user1060248 Over a year ago

When I tried this I got several issues. var tstandards = doc["categories"] gives an cannot apply indexing to an expressions of type MongoDb.Driver.MongoCursor<MongoDB.Bson.BsonDocument> and there is no Add method available on any of the variables.

user1060248 Over a year ago

I think the issue is in var tstandards = doc["categories"], I think I understand what you are doing but I can't figure out how to do it

Craig Wilson Over a year ago

Do a FindOne instead. I've changed my example.

Collectives™ on Stack Overflow

Insert in to a nested array Using C# Official Driver MongoDB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related