MongoDB C# Query for 'Like' on string
c# query will looks like:
Query.Matches("name", BsonRegularExpression.Create(new Regex("Joe")));Update:
As per @RoberStam suggestion, there is more simple way to do this:
Query.Matches("name", "Joe")
For the c# driver 2.1 (MongoDB 3.0)
var collection = database.GetCollection<BsonDocument>("<<name of the collection>>");var filter = Builders<BsonDocument>.Filter.Regex("name", new BsonRegularExpression("Joe"));var result = await collection.Find(filter).ToListAsync();For the c# driver 2.2 (MongoDB 3.0)
var filter = new BsonDocument { { parameterName, new BsonDocument { { "$regex", value }, { "$options", "i"} } } }var result = collection.Find(filter).ToList();
MongoDB C# driver has a BsonRegex type that you can use.
Regex is the closest you will get to the SQL LIKE statement.
Note that prefixed Regexes can use indexes: /^Joe/ will use an index, /Joe/ will not.