Mongo C# driver - Contains Filter

c# mongodb mongodb-.net-driver mongodb-csharp-2.0
Mr767267 picture Mr767267 · Aug 21, 2015 · Viewed 26.7k times · Source

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

Ofir picture Ofir · Apr 6, 2016

In order to achieve that in V2 API, use the `Filter.Regex':

var collection = db.GetCollection<BsonDocument>("collection");

var filter = Builders<BsonDocument>.Filter.Regex("fieldName", new BsonRegularExpression(".*fieldValue.*"));

var data = await (await coll.FindAsync<BsonDocument>(filter).ConfigureAwait(false)).ToListAsync();

//continue process data

Related questions

Get All 'documents' from MongoDB 'collection'

I need to retrieve all the documents that are in my collection in MongoDB, but I cannot figure out how. I have declared my 'collection' like this- private static IMongoCollection<Project> SpeCollection = db.GetCollection<Project>("collection_…

Read More
MongoDB C# Driver 2.0 - Update document

I'm currently upgrading my code to MongoDB C# driver 2.0 and I'm having issues upgrading the code to update documents. using the old version I was able to do something like this: MyType myObject; // passed in var collection = _database.GetCollection<…

Read More
MongoDb c# driver find item in array by field value

i found the way to check is the value contains in simple array : var filter = Builders<Post>.Filter.AnyEq(x => x.Tags, "mongodb"); But how to find a complex item with many fields by a concrete field ? …

Read More