How can I update mongodb document for adding a new item to array?

Question

I couldn't figure out insert to a sub array...

_id
MyArray
--Item
----ArrayItemId
----Name

I want to insert items to MyArray...

How my update document should be?

MyCollection.Update( 
 new QueryDocument { { "_id", MyObject.Id } },
 new UpdateDocument { { "$set", new BsonDocument { { "MyArray", 
       new BsonArray { new BsonDocument {{ "ArrayItemId", myArrayField.Id }},
                       new BsonDocument {{ "Name", myArrayField.Name }} }}}}}, 
 UpdateFlags.None);

Ofir · Accepted Answer · 2015-12-26 09:29:38Z

32

Syntax for new MongoDB c# async adapter:

var filter = Builders<myObject>
             .Filter.Eq(e => e.Name, "name");

var update = Builders<myObject>.Update
        .Push<String>(e => e.MyArray, myArrayField);

await collection.FindOneAndUpdateAsync(filter, update);

answered Dec 26, 2015 at 9:29

Ofir

5,3495 gold badges40 silver badges64 bronze badges

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

2 Comments

Chitra Nandpal Over a year ago

what should i write behalf of string

Sunny Sharma Over a year ago

you can skip the "String" in Push<String> as it can be inferred from the specified datatype in update field (e.MyArray)

mnemosyn · Accepted Answer · 2011-12-02 10:35:08Z

18

Inserting in an array is done using the $push operator.

As a side note, you don't need to use QueryDocument and UpdateDocument. There's a much easier helper syntax:

MyCollection.Update(Query.EQ("_id", MyObject.Id), 
                    Update.PushWrapped("MyArray", myArrayField)

Note that PushWrapped<T> allows to push documents, while Push accepts only such types that can be represented by a simple field in MongoDB.

answered Dec 2, 2011 at 10:35

mnemosyn

46.4k6 gold badges80 silver badges84 bronze badges

2 Comments

Serdar Over a year ago

thanks. But for Update.PushWrapped what should I reference... Intellicense is not seeing it...

Serdar Over a year ago

I think it is now ... new UpdateBuilder().PushWrapped in the new version

Collectives™ on Stack Overflow

How can I update mongodb document for adding a new item to array?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related