語法如下
降冪-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版
using System;
using System.ComponentModel;
using System.Runtime.InteropServices;
using System.Security.Principal;
namespace Company.Security
{
public class ImpersonateUser : IDisposable
{
[DllImport("advapi32.dll", SetLastError=true)]
private static extern bool LogonUser(string lpszUsername, string lpszDomain, string lpszPassword, int dwLogonType, int dwLogonProvider, out IntPtr phToken);
[DllImport( "kernel32", SetLastError = true )]
private static extern bool CloseHandle(IntPtr hObject);
private IntPtr userHandle = IntPtr.Zero;
private WindowsImpersonationContext impersonationContext;
public ImpersonateUser( string user, string domain, string password )
{
if ( ! string.IsNullOrEmpty( user ) )
{
// Call LogonUser to get a token for the user
bool loggedOn = LogonUser( user, domain, password,
9 /*(int)LogonType.LOGON32_LOGON_NEW_CREDENTIALS*/,
3 /*(int)LogonProvider.LOGON32_PROVIDER_WINNT50*/,
out userHandle );
if ( !loggedOn )
throw new Win32Exception( Marshal.GetLastWin32Error() );
// Begin impersonating the user
impersonationContext = WindowsIdentity.Impersonate( userHandle );
}
}
public void Dispose()
{
if ( userHandle != IntPtr.Zero )
CloseHandle( userHandle );
if ( impersonationContext != null )
impersonationContext.Undo();
}
}
}
使用方法
using ( new ImpersonateUser( "UserID", "Domain", "Password" ) )
{
// Any IO code within this block will be able to access the remote server.
}
.net Core(20240219更新) Only windows server
[DllImport("advapi32.dll", SetLastError = true, CharSet = CharSet.Unicode)]
public static extern bool LogonUser(String lpszUsername, String lpszDomain, String lpszPassword,
int dwLogonType, int dwLogonProvider, out SafeAccessTokenHandle phToken);
const int LOGON32_PROVIDER_DEFAULT = 0;
//This parameter causes LogonUser to create a primary token.
const int LOGON32_LOGON_INTERACTIVE = 2;
// Call LogonUser to obtain a handle to an access token.
SafeAccessTokenHandle safeAccessTokenHandle;
public IActionResult X()
{
try
{
bool returnValue = LogonUser("test", "mydomain", "test123", LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT, out safeAccessTokenHandle);
if (!returnValue)
throw new Exception("登入unc路徑錯誤!!");
WindowsIdentity.RunImpersonated(safeAccessTokenHandle, () =>
{
var basepath = @"\\192.168.0.1\testFiles";
if (!Directory.Exists(basepath))
{
throw new Exception("無資料夾-" + basepath);
}
DirectoryInfo root = new DirectoryInfo(basepath);
FileInfo[] files = root.GetFiles();
foreach (var item in files)
{
try
{
// item.Delete();
}
catch (Exception ex)
{
throw new Exception( ex.Message);
}
}
});
}
catch (Exception ex)
{
sb.Append($"error:{ex.Message}");
}
}
參考來源
ffmpeg -protocol_whitelist "file,http,https,tcp,tls" ^ -i "https://xxx.m3u8" ^ -c copy "D:\test.mp4"
-i來源 -c存放點2021-02-19補充下載azure
youtube-dl.exe --merge-output-format mp4 "https://xxxx.azure.net/xxxxxx/manifest(format=mpd-time-csf)"參考來源
<input type="number" asp-for="@Model[i].Field" class="form-control text-right" required step="1" asp-format="{0:0.#}" >
<form data-ajax-begin="OnBegin" data-ajax-complete="OnComplete" data-ajax-method="post" data-ajax-success="OnSuccess" data-ajax="true" id="from1" method="post">
<div class="form-group">
<button class="btn btn-primary" id="Edit" type="submit">編輯</button>
<button class="btn btn-danger" id="Delete" type="submit">刪除</button>
</div>
</form>
javascript部分使用jquery在按鈕點擊後加上data-ajax-url的url
<script src="~/lib/Microsoft.jQuery.Unobtrusive.Ajax/jquery.unobtrusive-ajax.min.js"></script>
<script>
$("#Edit").on("click", function () {
$("#from1").attr("data-ajax-url", "@Url.Action("自訂Action", "自訂Controller")" );
});
$("#Delete").on("click", function () {
if (!confirm("確定刪除！！"))
return false;
$("#from1").attr("data-ajax-url", "@Url.Action("自訂Action", "自訂Controller")" );
});
</script>
後端部分宣告兩個ActionResult來接收即可
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Edit()
{
ResultViewModel result = new ResultViewModel();
return Json(result);
}
[HttpPost,ActionName("Delete")]
[ValidateAntiForgeryToken]
public IActionResult DeleteConfirmed()
{
ResultViewModel result = new ResultViewModel();
return Json(result);
}
個人覺得這樣寫程式有點不好看
ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;<=加入 ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;<=加入參考來源
stafflist = await this._staffService.GetAll().Skip(1).Take(1).ToListAsync();
SqlException: 接近 'OFFSET' 之處的語法不正確。 FETCH 陳述式中的選項 NEXT 使用方式無效。 context後來找到一堆方法
services.AddDbContext<CoreSampleContext>(options => options.UseSqlServer(ConnectionString));改成
services.AddDbContext<CoreSampleContext>(options => options.UseSqlServer(ConnectionString,build =>build.UseRowNumberForPaging()));很好一樣出錯，後來找到了原因，目前使用的資料庫是SQL Server 2008R2
Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 3.1.0 Install-Package Microsoft.EntityFrameworkCore.SqlServer.Design -Version 1.1.6 Install-Package Microsoft.EntityFrameworkCore.Tools -Version 3.1.0
Install-Package Microsoft.EntityFrameworkCore.SqlServer Install-Package Microsoft.EntityFrameworkCore.SqlServer.Design Install-Package Microsoft.EntityFrameworkCore.Tools//第一次乾淨時
Scaffold-DbContext "Server=192.168.0.1;Database=Sample;user id=sa;password=1234567;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Project sample.model//有更新時
Scaffold-DbContext "Server=192.168.0.1;Database=Sample;user id=sa;password=1234567;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Project sample.model -Force//需與原資料庫同檔名時
Scaffold-DbContext "Server=192.168.0.1;Database=Sample;user id=sa;password=1234567;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Project sample.model -UseDatabaseNames常遇到Build failed或是直接沒反應