Insert new document in nested documents in MongoDB

Question

I am a beginner in MongoDB. Please see my models below.

public class Technology
{
    public Technology()
    {
        ProductGroups = new List<ProductGroup>();
    }

    [BsonRepresentation(BsonType.ObjectId)]
    public ObjectId _id { get; set; }

    public string Name { get; set; }

    public IEnumerable<ProductGroup> ProductGroups { get; set; }
}

public class ProductGroup
{

    [BsonRepresentation(BsonType.ObjectId)]
    public ObjectId _id { get; set; }

    public string Name { get; set; }

}

Now the data shows like below.

enter image description here

I am try to add the ProductGroup ( it's a BsonDocument Collection) collection in Technology.

rnofenko · Accepted Answer · 2015-06-19 15:28:19Z

3

Use generic types where you can. Because this code parent["ProductGroups"] is dangerous place for any refactoring.
Your task can be done in one query

var productGroup = new ProductGroup { Id = ObjectId.GenerateNewId(), Name = model.Name };
var collection = database.GetCollection<Technology>("Technology");
var update = Builders<Technology>.Update.AddToSet(x => x.ProductGroups, productGroup);
await collection.FindOneAndUpdateAsync(x => x.Id == model._id, update);

edited Jun 19, 2015 at 15:28

answered Jun 19, 2015 at 15:22

rnofenko

9,5932 gold badges55 silver badges61 bronze badges

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

2 Comments

Ragesh Puthiyedath Raju Over a year ago

Thank you for your valuable reply. But i can't get this (FindOneAndUpdateAsync) method in C# intellisence

rnofenko Over a year ago

How do you get collection?

CodingDefined · Accepted Answer · 2015-06-19 06:39:43Z

2

Change your Model of Technology as

[BsonElementAttribute("productgroups")]
public IList<ProductGroup> ProductGroups{ get; set; }

Then,

var productGroup = new BsonDocument().Add("_id", productGroup_id).Add("Name", name);

var technologies = database.GetCollection("technology");
var technology = technologies.FindOneById(ObjectId.Parse(technology_id));

technology["productgroups"] = new BsonArray().Add(BsonValue.Create(productGroup));

technologies.Save(technology);

answered Jun 19, 2015 at 6:39

CodingDefined

2,1621 gold badge17 silver badges13 bronze badges

2 Comments

Ragesh Puthiyedath Raju Over a year ago

Thank you for your valuable reply. I try to do this method. But '.FindOneById' is not getting visual studio intellisence. I am using v2.0.1.27

CodingDefined Over a year ago

@RageshPuthiyedath If you have MongoDB.Driver.dll referenced, then check api.mongodb.org/csharp/1.0/html/…. If this doesn't work you can check any other option using VS intellisense.

Ragesh Puthiyedath Raju · Accepted Answer · 2015-06-19 11:12:27Z

1

@CodingDefined I change my code as per the v2.0.1.27

Please see my code below. Thank you very much for your help.

var productGroup = new BsonDocument()
                      .Add("_id", ObjectId.GenerateNewId())
                      .Add("Name", model.Name);

BsonDocument parent = null;

var _parent = Collection.FindOneByIdAs(typeof(BsonDocument), model._id);

if (_parent != null)
{

   parent = _parent.ToBsonDocument();

   parent["ProductGroups"] = new BsonArray().Add(BsonValue.Create(productGroup));

   Collection.Save(parent);

}

Please make sure, the new child record is not clearing the existing records

parent["ProductGroups"] = parent["ProductGroups"].AsBsonArray.Add(productGroup);

edited Jun 19, 2015 at 11:12

answered Jun 19, 2015 at 8:38

Ragesh Puthiyedath Raju

3,93514 gold badges107 silver badges139 bronze badges

Collectives™ on Stack Overflow

Insert new document in nested documents in MongoDB

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related