How to run mongodb shell query from c# using mongodb driver

Question

I want to run below mongo query from C#. Currently I am using mongodb C# driver 2.7

db.changelog.find({}).forEach(function(doc){
//make javascript object dynimacally 
var newDoc = {
    "key": "value",
    "doc": doc
}
db.changelog_log.insertOne(newDoc); })

This is successfully run into mongo shell, now I want to execute that script from c# application with modify object value dynamically. I was hoping it would be able to parse those queries and pass them off to database.RunCommand but I have not been able to make any progress.

var bsonDoc = MongoDB.Bson.Serialization.BsonSerializer.Deserialize<BsonDocument>("query");

database.RunCommand(command);

That code fails on the call to Deserialize with this error message: [Additional information: JSON reader was expecting a value but found 'db'.] which makes perfect sense because the script is not valid JSON.

After mongo 3.0 eval function has been depreciated.

So I'm having trouble parsing the script into something that can be executed.

Hitesh Anshani · Accepted Answer · 2018-09-26 11:58:01Z

0

VehicleModel is a model which I am using for inserting and same for retrieving,

so it replaces with your model

        var collection = database.GetCollection<VehicleModel>("VehicleModel");

        var Data = await collection.Find(Builders<VehicleModel>.Filter.Empty).ToListAsync();


        foreach(VehicleModel vm in Data)
        {
            var newDoc =
            {
            "key": "value",
            "doc": vm
            collection.InsertOneAsync(value);
            }
        }

7 Comments

Adnan Ahmed Ansari Over a year ago

This utility will be used in whole application on all insert, update and delete operation on any collection so through c# foreach loop insert one document at a time have performance issue. So I want to use mongo foreach which will be used on mongo server so application only communicate one time with db server on one request

Hitesh Anshani Over a year ago

whenever you add data in mongo they need to go to mongo server always @AdnanAhmedAnsari

Adnan Ahmed Ansari Over a year ago

Yes you are right, but during loop every time application will be open new connection and application communicate multiple time with database which will be impact on application performance. But on a single request it will perform faster than that logic

Hitesh Anshani Over a year ago

ok, you added a c# tag so I thought you need same code in c# but actually, you need code which we can run on mongo shell right?? @AdnanAhmedAnsari

Hitesh Anshani Over a year ago

you need to run shell script for that find the link in my updated answer @AdnanAhmedAnsari

|

Collectives™ on Stack Overflow

How to run mongodb shell query from c# using mongodb driver

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related