Mongo C# driver - Contains Filter

Question

I am using the latest version of Mongo C# driver which uses a lot of Async and builder pattern. Which is nice. I am trying to convert SQL where clauses into Mongo FilterDefinition object.

Any idea how to handle "contains"?
like:

where x contains 'ABC'

Answer 1

I was able to get this working using Filter.AnyIn like so

var filter = Builders<BsonDocument>.Filter.AnyIn("x", new List<string> { "ABC" });

This works if you're looking for multiple values too, just add them to the list.