How to find records based on matching string content in Mongodb using C#

Question

I have a BsonDocument like

{

"Code" : "123ACThe three $#^",

. . . . 

}

I want to find the records which is having 3AC anywhere in the string in the field Code

note :- the characers AC should be case insensitive

I am new to mongoDb.How to achieve this ? Thanks in Advance for replies.

UPDATE

I tried this code db.session.find({ "Code": { "$regex": '^(.?(\b3AC\b)[^$])$' } } );

Got this working

db.session.find({ "Code": { "$regex": '3AC.*'} } );

Is this the only way ? and how to achieve in C# using native driver ?

Added an answer that shows how to do this in C#.

WiredPrairie
– WiredPrairie

2013-11-07 19:15:21 +00:00
Commented Nov 7, 2013 at 19:15 — WiredPrairie
– WiredPrairie, Commented Nov 7, 2013 at 19:15

Tom Swifty · Accepted Answer · 2013-11-07 18:04:28Z

1

This should do the trick:

db.session.find({Code: /3AC/ })

or if you want to ignore case:

db.session.find({Code: /3AC/i })

answered Nov 7, 2013 at 18:04

Tom Swifty

2,9922 gold badges19 silver badges25 bronze badges

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

Comments

WiredPrairie · Accepted Answer · 2013-11-07 19:13:54Z

1

While doing a search like that is not generally recommended as an index cannot be used (as your expression is not anchored to the start of the string), in C# you can use the Query classes' Matches method:

Query.Matches("Code", "3AC.*")

where "3AC.*" represents the regular expression string you're using.

MongoCollection<ExampleType> exampleCollection;
var query = Query.Matches("Code", "3AC.*");
foreach (var example in exampleCollection.Find(query)) {
    //
}

answered Nov 7, 2013 at 19:13

WiredPrairie

59.9k18 gold badges120 silver badges149 bronze badges

Comments

JohnnyHK · Accepted Answer · 2013-11-07 19:34:55Z

1

You can also use the driver's LINQ interface and the driver will build the regular expression for you:

var query = sessionCollection.AsQueryable<Session>()
    .Where(s => s.Code.Contains("3AC"));
foreach (var session in query) { ... }

answered Nov 7, 2013 at 19:34

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Collectives™ on Stack Overflow

How to find records based on matching string content in Mongodb using C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related