CODEWITHSUNDEEP
c#mongodbmongodb-.net-driver
atbebtg
atbebtg

Reputation: 4083

How do I get the _id of the rcently inserted document after an insert using mongo csharp?

I was able to successfully insert a new document using the following code but I was not able to get the _id of the newly inserted document.

After the insert, user is null. Thank you!

MongoServer server = MongoServer.Create();
MongoDatabase test = server.GetDatabase("Test");

MongoCollection<BsonDocument> users = test.GetCollection("Users");
BsonDocument user = new BsonDocument();
user.Add("FirstName", "John");
user.Add("LastName", "Michael");
user.Add("Address", "123 Main Street");
user.Add("City", "Newport Beach");
user.Add("State", "CA");
user.Add("ZipCode", "92660");
user.Add("Email", "[email protected]");
user.Add("CreatedDate", DateTime.Now);
user.Add("IPAddress", "10.1.1.1");

user = users.Save(user);

string idSTring = user["_id"].ToString().Replace("\"", "");

Upvotes: 4

Views: 8542

Answers (2)

Edward83
Edward83

Reputation: 6686

I made some tests with the official driver and found that method MongoCollection.Save returns null; So do not assign result to your constructed user:

//user = users.Save(user);
users.Save(user);

string idStr = user["_id"].ToString();

Console.WriteLine("_id == {0}", idStr);

About drivers check this and this

Upvotes: 8

Edward83
Edward83

Reputation: 6686

Use this C# driver and your code will be like this:

        var refMongo = new Mongo();

        refMongo.Connect();

        var test = refMongo.GetDatabase("Test");

        var users = test.GetCollection("Users");

        var user = new MongoDB.Document();

        user.Add("FirstName", "John");
        user.Add("LastName", "Michael");
        user.Add("Address", "123 Main Street");
        user.Add("City", "Newport Beach");
        user.Add("State", "CA");
        user.Add("ZipCode", "92660");
        user.Add("Email", "[email protected]");
        user.Add("CreatedDate", DateTime.Now);
        user.Add("IPAddress", "10.1.1.1");

        users.Save(user);

        string idSTring = user["_id"].ToString();

        Console.WriteLine(idSTring);

I got _id == 4cd9e240df53ca112c000001

Good luck!;)

Upvotes: 3

Related Questions