How do I query MongoDB using the C# driver with a query in string format?

Question

I need to query MongoDB with a standard query like the following:

{"$and":[{"Name":"Accelero JKT M Tun XL "}]}

I typically build queries using the Query object in C# and then do something like this:

MongoCollection<BsonDocument> col = _database.GetCollection<BsonDocument>("SourceItem");
var query = Query.And(Query.EQ("AccountID", BsonValue.Create(Convert.ToInt32(_accountID))), Query.EQ("SKU", sku));
var docs = col.Find(query);

Since I already have the query, I do not want to use the Query object to build a query. How do I simply use the query that I already have?

Have you looked at this? stackoverflow.com/questions/6120629/… — Matt
– Matt, Commented Oct 22, 2014 at 15:51

Brian Rogers · Accepted Answer · 2014-10-22 18:53:59Z

5

There is a slightly simpler way to do this (you should just replace " with '):

var el = BsonDocument.Parse("{'$and':[{'Name':'Accelero JKT M Tun XL '}]}");
var doc = new QueryDocument(el);
var result = coll.Find(doc);

edited Oct 22, 2014 at 18:53

Brian Rogers

130k31 gold badges315 silver badges315 bronze badges

answered Oct 22, 2014 at 16:40

Disposer

6,3915 gold badges34 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How do I query MongoDB using the C# driver with a query in string format?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related