語法如下
降冪-1升冪 1
1.單一欄位
db.collectionName.createIndex({"age":1})
2.多重欄位
db.collectionName.createIndex({"name":-1,"age":1})
也可以使用Robo 3T > Collection上右鍵 > Add Index
var builders = Builders但通常條件不會這麼簡單.Filter;//建立查詢 var filter = builders.Eq("age", 20);//過濾條件 var query = collection.Find(filter).ToList();//抓資料 條件如下 Eq等於 Ne不等於 Gt大於 Gte大於等於 Lt小於 Lte小於等於 Regex Like In 存在裡面的 Nin 不存在裡面的
情境1.找年齡20～30歲
var filter = builders.Gte("age",20) & builders.Lte("age", 30);
情境2.找年齡20～30歲或年齡50～60歲
var filter = builders.Gte("age",20) & builders.Lte("age", 30);
filter = filter | builders.Gte("age", 50) & builders.Lte("age", 60);
情境3.找年齡20～30歲或年齡50～60歲且名字有林的
var filter = builders.Gte("age",20) & builders.Lte("age", 30);
filter = filter | builders.Gte("age", 50) & builders.Lte("age", 60);
filter = filter & builders.Regex("Name", "林");
情境4.找年齡50、60、70歲
int[] agelist = new[] { 50, 60, 70 };
var filter = builders.In(x => x.age, agelist);
參考來源
mongodump mongorestore mongoexport mongoimport在命令提示字元中照貼語法都出現在列錯誤
'mongodump' 不是內部或外部命令、可執行的程式或批次檔。後來檢查才發現根本沒這些執行檔阿
Starting with MongoDB 4.4, mongodump is now released separately from the MongoDB Server and uses its own versioning, with an initial version of 100.0.0. Previously, mongodump was released alongside the MongoDB Server and used matching versioning.至官網下載MongoDB Database Tools
-h: MongoDB連線IP或資訊
-port: Port
-d: 資料庫名稱
-o: 備份路徑資料夾
-u: 登入帳號
-p: 登入密碼
mongodump -h {host} -port {port} -d {yourdbname} -o {outputfloder} -u {username}-p {password}
mongodump -h localhost -port 27017 -d Happen -o d:\mongodb\bak -u Happen -p 7533967
完成後會在d:\mongodb\bak\Happen裡找到備份
-d: 資料庫名稱
-u: 登入帳號
-p: 登入密碼
--drop: 以存在資料庫刪除原有的(注意)
mongorestore -d {yourdbname} --drop -o {outputfloder} -u {username}-p {password}
mongorestore -d Happen --droup d:/mongodb/bak/happen -u Happen -p 7533967
參考來源
mongo
>use yourdbname
>switched to db yourdbname
>db.createUser(
{
user: "username",
pwd: "password",
roles: [ { role: "readWrite", db: "yourdbname" } ]
})
>Successfully added....
>db.auth('username','password')
1完成代表可以登入
0登入失敗
登入成功表示帳密無誤
3.設定mongod.cfg
找到
#security:改成
security:
authorization: enabled
4.啟用MongoDB Server服務，寫程式即可使用上面的帳密登入，記得readWrite權限要開才能讀寫資料庫mongodb://username:password@localhost:27017/dbnamePS也可直接使用工具建立帳密
public class StaffInfo
{
[BsonId]
[BsonRepresentation(BsonType.ObjectId)]
public string Id { get; set; }
public string Name { get; set; }
public int age { get; set; }
[BsonDateTimeOptions(Kind = DateTimeKind.Local)]
public DateTime birthday { get; set; }
public string remark { get; set; }
public int likenumber { get; set; }
}
b.宣告Interface
public interface IStaffInfoService
{
List Get();
void Insert( StaffInfo model);
void Update( StaffInfo model);
void Delete(StaffInfo model);
}
c.建立Service寫CURD
public class StaffInfoService : IStaffInfoService
{
private readonly IMongoCollection _staffinfo;
public StaffInfoService()
{
var client = new MongoClient("mongodb://localhost:27017");
//var client = new MongoClient("mongodb://{username}:{password}@{host}:{port}/{Database}")
var database = client.GetDatabase("dbname");
_staffinfo = database.GetCollection("tablename");
}
public void Delete(StaffInfo model)
{
_staffinfo.DeleteOne(x => x.Id == model.Id);
}
public List Get()
{
return _staffinfo.Find(StaffInfo => true).ToList();
}
public void Insert(StaffInfo model)
{
_staffinfo.InsertOne(model);
}
public void Update(StaffInfo model)
{
_staffinfo.ReplaceOne(x => x.Id == model.Id, model);
}
}
d.DI注入即可使用
# network interfaces net: port: 27017 bindIp: 127.0.0.1修改為以下為不限制
# network interfaces net: port: 27017 bindIp: 0.0.0.0修改為以下為開放本機及192.168.1.100
# network interfaces net: port: 27017 bindIp: 127.0.0.1 ,192.168.1.100以上步驟修改完成後記得至服務重起MongoDB Server才會有效
cd C:\Program Files\MongoDB\Server\4.4\bin輸入以下
mongod --version有出現就安裝成功
db version v4.4.1
Build Info: {
"version": "4.4.1",
"gitVersion": "xxxx",
"modules": [],
"allocator": "tcmalloc",
"environment": {
"distmod": "windows",
"distarch": "x86_64",
"target_arch": "x86_64"
}
}
5.4.4.1需Windows 10 or server 2016 所以如果下以下的可以使用4.2.10版