MS Access

 連接字串為檔案位置，例如C://xx/xx/xx

表格轉逗號隔開字串

    rtrim(xmlagg(XMLELEMENT(e, lot || ':' || sample,',').EXTRACT('//text()')).GetClobVal(),',') "sample"

how to code copy file to build or release folder

 1.

專案 

屬性

 建置事件 

鑑識後事件命列輸入

 if not exist "$(ProjectDir)$(OutDir)configs" mkdir "$(ProjectDir)$(OutDir)configs"

 copy "$(ProjectDir)configs\"  "$(ProjectDir)$(OutDir)configs\"

2.

按下檔案

屬性

properties 

copy to output directory 

選擇copy always

v 參數

 asp-append-version="true"

[.net core] F5更新

1.Install the Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation
2.
public void ConfigureServices(IServiceCollection services)
{ services.AddRazorPages() .AddRazorRuntimeCompilation(); // code omitted for brevity }

reference:
https://docs.microsoft.com/en-us/aspnet/core/mvc/views/view-compilation?view=aspnetcore-3.1&tabs=visual-studio#enable-runtime-compilation-in-an-existing-project

[asp.net core] swagger 注意事項

1.
要有裝
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
再裝
dotnet add TodoApi.csproj package Swashbuckle.AspNetCore -v 5.0.0-rc4

不然會一直出錯

[Xamarin]Incompatible HAX module version 3,requires minimum version 4 No accelerator found. failed to initialize HAX: Invalid argument 2019

原因:Incompatible HAX module version 3,requires minimum version 4 No accelerator found. failed to initialize HAX: Invalid argument 2019

方法:因為下載 HAXM is installed in the Android SDK Manager，但是沒有安裝，找到安裝檔案位置，手動安裝