參考網頁:

1. Using Dapper In ASP.NET Core Web API https://www.c-sharpcorner.com/article/using-dapper-in-asp-net-core-web-api/

2. SQL Server connection strings https://www.connectionstrings.com/sql-server/

3. [.NET] 如何取得 Enum 的 Description 描述字串 https://marcus116.blogspot.com/2018/12/how-to-get-enum-description-attribute.html

4. 如何執行和呼叫自訂擴充方法 (c # 程式設計手冊) https://docs.microsoft.com/zh-tw/dotnet/csharp/programming-guide/classes-and-structs/how-to-implement-and-call-a-custom-extension-method

5. [ASP.NET] 輕量級ORM - Dapper 使用說明 https://dotblogs.com.tw/OldNick/2018/01/15/Dapper

6. 使用Dapper.Contrib 開發.net core程式，相容多種資料庫 https://www.itread01.com/content/1542110421.html

7. C# 資料操作系列 - 18 讓Dapper更強的外掛 https://www.mdeditor.tw/pl/pIvr/zh-tw

8. 如何進行Database First式開發？ https://ithelp.ithome.com.tw/articles/10201333

9. ASP.NET Core 2 系列 - 跨域請求 (Cross-Origin Requests) https://ithelp.ithome.com.tw/articles/10196870

10. 安裝Swagger https://ithelp.ithome.com.tw/articles/10241544

11. .Net Core Project 從零開始 — NLog https://medium.com/@WilliamWhetstone/net-core-project-%E5%BE%9E%E9%9B%B6%E9%96%8B%E5%A7%8B-nlog-b8effb9561f9 https://medium.com/@WilliamWhetstone/net-core-project-%E5%BE%9E%E9%9B%B6%E9%96%8B%E5%A7%8B-use-nlog-wite-log-to-database-table-711b4c00f00d

12. 透過 JWT 實作驗證機制 https://medium.com/%E9%BA%A5%E5%85%8B%E7%9A%84%E5%8D%8A%E8%B7%AF%E5%87%BA%E5%AE%B6%E7%AD%86%E8%A8%98/%E7%AD%86%E8%A8%98-%E9%80%8F%E9%81%8E-jwt-%E5%AF%A6%E4%BD%9C%E9%A9%97%E8%AD%89%E6%A9%9F%E5%88%B6-2e64d72594f8

13. Asp.Net Core 3.1 學習4、Web Api 中基於JWT的token驗證及Swagger使用 https://iter01.com/503160.html

14.JSON Web Tokens https://jwt.io/

安裝Nuget:

1. Dapper v2.0.78
2. Microsoft.EntityFrameworkCore v5.0.2
3. Microsoft.EntityFrameworkCore.sqlServer v5.0.2
4. System.Data.SqlClient v4.8.2
5. Dapper.Contrib v2.0.78
6. Microsoft.EntityFrameworkCore.Tools v5.0.2
7. Microsoft.Extensions.Configuration.Binder v5.0.0
8. Microsoft.AspNetCore.Cors v2.2.0
9. Microsoft.AspNetCore.Authentication.JwtBearer v3.1.10
10. Swashbuckle.AspNetCore.SwaggerGen v6.0.7
11. Swashbuckle.AspNetCore.SwaggerUI v6.0.7
12. NLog v4.7.7
13. NLog.Web.AspNetCore v4.10.0