New (2.6) $cond Aggregation Framework with c#?

Question

I'm going crazy with this one...

I have this aggregation framework expression working like a charm in mongo shell:

{ $group : 
    {
    _id : '$Code' , 
    'Special' : { $sum : { $cond: [{ $eq: [ '$Special', 'Success']},1,0]}}
    }
}

I need to do it in c#, I tried a lot of combinations but without success.

Has anyone any clue?

Thx

Answer 1

Give this a try:

var group = new BsonDocument
{
    {
        "$group",
        new BsonDocument
        {
            {
                "_id", "$Code"
            },
            {
                "Special", new BsonDocument
                {
                    { "$sum", new BsonDocument
                        {
                            {"$cond", new BsonArray
                                {
                                    new BsonDocument
                                    {
                                        {
                                            "$eq", new BsonArray {"$Special", "Success"}
                                        }
                                    },
                                    1,
                                    0
                                }
                            }
                        }
                    }
                }
            }
        }
    }
};