Add item to nested array of nested object using MongoDB C# Driver

Question

I am trying to use the MongoDB C# Driver to add an item to a nested array inside of a BSON document. I have searched SO, but none of the examples I have found so far match what I am trying to do.

I have a top-level "Organizations" collection in Mongo. This contains multiple Organization objects with the following structure:

{
   "id":"Org1",
   "Name":"First Org",
   "Divisions":[
      {
         "id":"Div1",
         "Name":"First Division",
         "UsersInDivision":[
            "User1",
            "User2"
         ]
      }
   ]
}

I have the following POCO classes

public class Organization
{
    public string Id { get; set; }
    public string Name { get; set; }
    public IList<Division> Divisions { get; set; }
}

public class Division
{
    public string Id { get; set; }
    public string Name { get; set; }
    public IList<string> UsersInDivision { get; set; }
}

I would like to add the string "User3" to the UsersInDivision collection, of Division "Div1" or Organization "Org1". What is the optimal way to achieve this? I am trying to use the strongly typed versions of MongoDB data access classes where possible.

Disposer · Accepted Answer · 2015-01-13 20:24:32Z

5

There is no typed version query for do such a thing, you have to use string based query

var query = Query.And(Query.EQ("id", "Org1"), Query.EQ("Divisions.id", "Div1"));
collection.Update(query, Update.AddToSet("Divisions.$.UsersInDivision", "User3"));

The reason you cant use strongly typed version is $ operator.

There is no $ in current version of mongodb c# driver. check here

edited Jan 13, 2015 at 20:24

answered Jan 13, 2015 at 20:05

Disposer

6,3915 gold badges34 silver badges39 bronze badges

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

2 Comments

Kalanamith Over a year ago

collection.Update This is no longer available in current driver

Eyal Perry Over a year ago

@Kalanamith Use Builders<TDocument>.Update.AddToSet

Collectives™ on Stack Overflow

Add item to nested array of nested object using MongoDB C# Driver

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related