c# mongodb BsonDocument array

Question

the below code seems to work except that the values are not actually saved to the existing document.

    MongoServer mongo = MongoServer.Create();
    mongo.Connect();
    var db = mongo.GetDatabase("forms"); 
    mongo.RequestStart(db);
    var collection = db.GetCollection("forms");
    var query = new QueryDocument("_id",ObjectId.Parse(Id));
    var resultsCursor = collection.Find(query);

    foreach (BsonDocument item in resultsCursor)
    {   
    var formFields = new BsonArray();
    formFields.Add(new BsonDocument
    {
        {"ID", ObjectId.GenerateNewId()},
        {"NAME",name},
        {"TYPE",type}
    }
    );
    collection.Save(item.Add("fields",formFields));

I say it works because this the result of getlasterror run immediately after the save:

db.GetLastError()
{MongoDB.Driver.GetLastErrorResult}
base {MongoDB.Driver.CommandResult}: {MongoDB.Driver.GetLastErrorResult}
DocumentsAffected: 1
HasLastErrorMessage: false
LastErrorMessage: null
UpdatedExisting: true

I'm missing something (probably something simple...). Thanks for any assistance.

WiredPrairie · Accepted Answer · 2013-08-08 13:36:47Z

1

The code works fine (well, with a few tweaks to make it compile standalone and to fit my test environment):

MongoServer mongo = MongoServer.Create();
mongo.Connect();
var db = mongo.GetDatabase("test"); 
//  mongo.RequestStart(db);  // removed as it's not correct
var collection = db.GetCollection("so");
var query = new QueryDocument("_id", "12345"); // hard-coded an ID for test
var resultsCursor = collection.Find(query);

foreach (BsonDocument item in resultsCursor)
{
    var formFields = new BsonArray();
    formFields.Add(new BsonDocument
    {
        {"ID", ObjectId.GenerateNewId()},
        {"NAME", item["Name"].AsString},   // grabbed a few values from doc
        {"TYPE", item["Type"].AsString}    // to move into an array
    });
    collection.Save(item.Add("fields", formFields));
}

Test:

> db.so.remove()
> db.so.insert({_id: "12345", Name: "Jon Smith", Type: "Employee"})
> db.so.find()
{ "_id" : "12345", "Name" : "Jon Smith", "Type" : "Employee" }
> // Ran application here
> db.so.find()    
{ "_id" : "12345", "Name" : "Jon Smith", "Type" : "Employee", 
    "fields" : [{"ID" : ObjectId("52039e395bddbf23f8cc0888"),    
                 "NAME" : "Jon Smith",
                 "TYPE" : "Employee" } ] }

FYI: RequestStart returns an IDisposable object. I'm not sure why you're trying to use it, but you're using it incorrectly.

answered Aug 8, 2013 at 13:36

WiredPrairie

59.9k18 gold badges120 silver badges149 bronze badges

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

2 Comments

user2167261 Over a year ago

Thanks. If I comment out the RequestStart, I get an error when calling getLastError,{"GetLastError can only be called if RequestStart has been called first."}.. and the new values still do not actually save.

WiredPrairie Over a year ago

OK, (As I said, you're calling it incorrectly) but why are you calling GetLastError? As I said and showed above, the code works as I demonstrated. You'll need to provide something showing the data isn't in fact saving.

Collectives™ on Stack Overflow

c# mongodb BsonDocument array

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