mongodb c# $regex

Question

I'm creating mongodb queries dynamically but when I use $regex it throws an exception. The query works if I use it directly in the shell!

Any suggestions? I really need to use dynamic queries.

method: this.Collection.Find(query).Limit(limit).ToListAsync(cancellationToken);

query: { $and: [ { Name: { '$regex': /batman/i } } ] }

exception:'BsonSerializer.Deserialize<BsonDocument>("{ $and: [ { Name: { '$regex': /batman/i } } ] }")' threw an exception of type 'System.FormatException'
Data: {System.Collections.ListDictionaryInternal}
HResult: -2146233033
HelpLink: null
InnerException: null
Message: "JSON reader expected a string but found '/batman/i'."
Source: "MongoDB.Bson"

4J41 · Accepted Answer · 2016-10-03 11:54:00Z

1

You can try separating the options from the search value.

{ $and: [ { Name: { '$regex': 'batman', '$options' : 'i' } } ] }

answered Oct 3, 2016 at 11:54

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

mongodb c# $regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related