Mongo C# driver - Building filter dynamically with nesting

Question

Assume something like a nested expression

where a = 1 AND ( b = 4 OR b = 5 )

How to use multiple Builders objects and build a complete filter out of such an expression?

Answer 1

Builders is really flexible class, it also has overridden operators "& = AND" and "| = OR"

Your example will be

var filter = Builders<User>.Filter.Eq(x => x.A, "1"); filter &= (Builders<User>.Filter.Eq(x => x.B, "4") | Builders<User>.Filter.Eq(x => x.B, "5"));