C# mongo queries with json strings

LoveMeSomeCode picture LoveMeSomeCode · Jun 20, 2013 · Viewed 12.1k times · Source

This seems so basic that I'm sure I've just overlooked a class or a method somewhere, but for the life of me, I can't find it.

I've got a json string like so:

{ SendId: 4, "Events.Code" : { $all : [2], $nin : [3] } }

I can run this in the mongo shell against a find() or a count() and get what I'm looking for. What is the easiest way to deal with this in C#? Here's what I've found:

  • The methods I'm finding are all wanting an IMongoQuery, which is just a marker interface
  • BsonDocument has a nice Parse method, but it doesn't implement IMongoQuery
  • QueryDocument inherits from BsonDocument, and it does implement IMongoQuery, but it does not have it's own Parse method, and I can't convert the QueryDocument to BsonDocument
  • The Aggregation framework takes a BsonDocument[], but sometimes I just want a simple Find or Count operation
  • Some of these queries are large and gross, and I don't want to build them a line a time with the Query builder class

If the database deals with json documents, and I can run this stuff in the shell, isn't there some way to run it through the driver?

Answer

Shaun McCarthy picture Shaun McCarthy · Jun 20, 2013

It's ugly, but you can do this by deserializing the string in to a BsonDocument and then wrapping in a QueryDocument

BsonDocument query = MongoDB.Bson.Serialization.BsonSerializer.Deserialize<BsonDocument>("{ SendId: 4, 'Events.Code' : { $all : [2], $nin : [3] } }");
QueryDocument queryDoc = new QueryDocument(query);
var result = collection.FindAs<TypeOfResultExpected>(queryDoc); // or just use Find

If it's something you plan on doing frequently, you could always wrap it in a method, or create a JSQueryDocument class like the following:

public class JSQueryDocument : QueryDocument
{
    public JSQueryDocument(string query) : base(MongoDB.Bson.Serialization.BsonSerializer.Deserialize<BsonDocument>(query))
    {
        // Probably better to do this as a method rather than constructor as it
        // could be hard to debug queries that are not formatted correctly
    }
}

/// ...

var result = collection.Find(new JSQueryDocument("{ SendId: 4, 'Events.Code' : { $all : [2], $nin : [3] } }"));