How to build a query in mongodb and execute like sql

Question

I am using mongodb driver in c#. I can create query for CRUD operations sqlserver in c# . But i need to Create query for mongodb and execute it . For an sample i attached Delete Delete Query

string query = string.Format("DELETE FROM {0} WHERE {1}"

ExecuteNonquery method i can execute it in sqlConnection

How i do this in mongodb?

MongoDB CRUD Operations. Read it. Also don't spam tags just to get attention. — Neil Lunn
– Neil Lunn, Commented Nov 7, 2017 at 5:58

Wan B. · Accepted Answer · 2017-11-08 06:41:38Z

1

You should see FilterDefinitionBuilder TDocument which provides a type-safe API for building up both simple and complex MongoDB queries.

For example to build up the filter { x: 10, y: { $lt: 20 } }, you can use below:

var builder = Builders<BsonDocument>.Filter;
var filter = builder.Eq("x", 10) & builder.Lt("y", 20);

You can see more examples on mongo-csharp-driver tests for FilterDefinitionBuilder class.

answered Nov 8, 2017 at 6:41

Wan B.

18.9k4 gold badges60 silver badges73 bronze badges

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

Collectives™ on Stack Overflow

How to build a query in mongodb and execute like sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related