How to use to use pipeline within a $lookup in mongo aggregation in C#

Working with Data Drivers
, ,
1

I got 3 collections “batches”, “buildAggregations”, “builds”

A batch object got an array with related buildAggregations id
A buildAggregation object got an array with related builds id

I want to fetch all batches with all sublevel objects so I wrote a $lookup command

db.getCollection("batches").aggregate([
{
    $lookup:
    {
        from: "buildAggregations",
        localField: "AggregationBuildIdList",
        foreignField: "BuildAggregationModelId",
        pipeline:[
            {
                $lookup: {
                    from: "builds",
                    localField: "BuildIdList",
                    foreignField: "_id",
                    as: "Builds"
                }
            }
        ],
        as: "AggregationBuilds"
    }
}
])

I can’t figure out how I should add a pipeline condition in lookup in C#
MongoDB Compass won’t export this in C# so I’m kind of stuck here

2

I found some working code

var pipeline = new BsonDocument[]
        {
            new BsonDocument("$lookup",
                new BsonDocument
                {
                    { "from", "buildAggregations" },
                    { "localField", "AggregationBuildIdList" },
                    { "foreignField", "BuildAggregationModelId" },
                    {
                        "pipeline",
                        new BsonArray
                        {
                            new BsonDocument("$lookup",
                                new BsonDocument
                                {
                                    { "from", "builds" },
                                    { "localField", "BuildIdList" },
                                    { "foreignField", "_id" },
                                    { "as", "Builds" }
                                })
                        }
                    },
                    { "as", "AggregationBuilds" }
                })
        };

        var result = _batchCollection.Aggregate<BsonDocument>(pipeline).ToList();

But I don’t really like all those magic string. It would be great to use lamba expression to specify object properties.

I also would like to get a strongly typed result. How shoul I do that?