- 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 :
1 |
db.KLSite.find({"Area":"INDONESIA MOBILE TELKOMSEL"}) |
- *** 怎么模糊filter ?
in command line : it is :
1 |
db.KLSite.find({"Area":/DONESI/}) |
in c# program , should be :
1 2 3 4 5 6 7 8 9 10 11 |
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