MongoDB C# Query for 'NotLike' on string

Question

I'm using official Mongo C# driver. As suggested in answer to one question I'm using the following for the 'like' operator -

Query.Matches("name", "Joe");

My question is how can I achieve the 'NotLike' functionality ?

Robert Stam · Accepted Answer · 2012-07-24 17:19:24Z

4

Assuming you are using the new Query builder in version 1.5, you would do it this way:

var query = Query.Not(Query.Matches("name", "Joe"));

In version 1.5 we also introduced a new typed Query builder, which you could use this way:

var query = Query.Not(Query<C>.Matches(x => x.Name, "Joe"));

Finally, you could also write a LINQ query:

var query = collection.AsQueryable<C>().Where(x => !Regex.IsMatch(x.Name, "Joe"));

answered Jul 24, 2012 at 17:19

Robert Stam

12.2k2 gold badges41 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Robert for always helping out so quickly