How to convert string into ObjectId

Question

I am getting data from MongoDB and binding to a WPF datagrid.

My code selects multiple rows, retrieves IDs and updates the selected records:

var server = MongoServer.Create(this.connectionString);
var db = server.GetDatabase(DATABASE);
var viewTrue = db.GetCollection(RISKALERT_TBL);
var count = viewTrue.Count();
foreach (RiskSettings row in grdRiskAlerts.SelectedItems)
{
    viewTrue.Update(Query.EQ("ID",row.ID), Update.Set("View", "False"));
    LoadandBindData();
}

But it does not update the record.

I thought maybe row.id is returning string and ID datatype is objectId.

This query is working for other datatype except the above case.

Zaid Masud · Accepted Answer · 2016-08-26 13:18:06Z

26

To convert a string to an ObjectId, use the ObjectId.Parse(string) method.

Also try to match on "_id" rather than "ID".

So something like:

viewTrue.Update(Query.EQ("_id", ObjectId.Parse(row.ID)), Update.Set("View", "False"));

edited Aug 26, 2016 at 13:18

answered Dec 16, 2011 at 18:15

Zaid Masud

13.5k9 gold badges70 silver badges89 bronze badges

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

2 Comments

user1726343 Over a year ago

This only seems to work if the string is already an ObjectId. It doesn't seem to work for arbitrary strings.

Zaid Masud Over a year ago

@AsadSaeeduddin yes, it's like int.Parse. If the string can't be converted to an ObjectId, of course we can't expect it to work.

Brian Var · Accepted Answer · 2015-11-22 14:27:02Z

9

I came across the same issue when setting up a public property for the ObjectID.

My property converted the ObjectID to a string, and back to an ObjectID using the following code snippet.

The ObjectID wasn't coming up as an option so I had to use the complete namespace, to access the .Parse() like this MongoDB.Bson.ObjectId.Parse

    public string Id
    {
        get { return Convert.ToString(_id); }
        set { _id = MongoDB.Bson.ObjectId.Parse(value); }
    }

Hope this helps!

edited Nov 22, 2015 at 14:27

answered Nov 15, 2015 at 19:38

Brian Var

6,26728 gold badges127 silver badges218 bronze badges

Comments

SaltySub2 · Accepted Answer · 2017-03-14 06:34:33Z

4

The easiest way I found was to use: new ObjectId(yourString) ...This will give you a MongoDB ObjectId from a string and should work with any of your queries.

answered Mar 14, 2017 at 6:34

SaltySub2

3092 silver badges6 bronze badges

Comments

julien bouteloup · Accepted Answer · 2016-01-14 11:22:01Z

2

You just need to require the ObjectId function from your mongo.

ObjectId = require('mongodb').ObjectID;

Then you can use it like that:

ObjectId(row.ID)

So you can change your line of code to:

viewTrue.Update(Query.EQ("ID",ObjectId(row.ID)), Update.Set("View", "False"));

answered Jan 14, 2016 at 11:22

julien bouteloup

3,09224 silver badges16 bronze badges

Comments

Amin Shojaei · Accepted Answer · 2020-09-02 06:42:49Z

1

Another way is:

myString := "5f4f321d7125461260ad9d74"

objectId, err := primitive.ObjectIDFromHex(myString)

if err != nil {
    panic("Invalid id")
}

answered Sep 2, 2020 at 6:42

Amin Shojaei

6,7882 gold badges44 silver badges51 bronze badges

1 Comment

Carlo Nyte Over a year ago

This is the proper of doing it now. Thank you for the update

muazharin alfan · Accepted Answer · 2021-03-03 11:04:01Z

0

if you use mgo, you can try this one

id := "603f4d6415177136d0583d4d"
_id := bson.ObjectIdHex(id)

answered Mar 3, 2021 at 11:04

muazharin alfan

1,9511 gold badge11 silver badges3 bronze badges

Collectives™ on Stack Overflow

How to convert string into ObjectId

6 Answers 6

2 Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related