mongo DB

command line 进入 C:\Program Files\MongoDB\Server\3.4\bin , 打： mongo
显示所有 database : show dbs
use database : use dbname
显示 table , in mango , table 叫做 collection : show collections
table filter :

db.KLSite.find({"Area":"INDONESIA MOBILE TELKOMSEL"})

1	db.KLSite.find({"Area":"INDONESIA MOBILE TELKOMSEL"})

*** 怎么模糊filter ?

in command line : it is :

db.KLSite.find({"Area":/DONESI/})

1	db.KLSite.find({"Area":/DONESI/})

in c# program , should be :

            var collection = MyMongoHelper._database.GetCollection<BsonDocument>(sCollection);
            //var filter = new BsonDocument();
            //filter.Add("Area", @"/" + sArea + @"/");
            //filter.Add("Area",@"/INDONESIA/");
            //filter.Add("Enabled", 1);

            var filter = Builders<BsonDocument>.Filter.Regex("Area", new BsonRegularExpression(sArea));
            

            //var filter = "{ FirstName: 'Peter'}";
            using (var cursor = await collection.FindAsync(filter))

var collection = MyMongoHelper._database.GetCollection<BsonDocument>(sCollection);

//var filter = new BsonDocument();

//filter.Add("Area", @"/" + sArea + @"/");

//filter.Add("Area",@"/INDONESIA/");

//filter.Add("Enabled", 1);

var filter = Builders<BsonDocument>.Filter.Regex("Area", new BsonRegularExpression(sArea));

//var filter = "{ FirstName: 'Peter'}";

using (var cursor = await collection.FindAsync(filter))

来源于：

https://stackoverflow.com/questions/8382307/mongodb-c-sharp-query-for-like-on-string

Category: mongo DB