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

Question

I need to query MongoDB with a standard query as follows:

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

I usually build queries using a 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 a query, I don’t want to use the Query object to build the query. How easy is it to use a query that I already have?

Answer 1

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);