[ Entity Framework Core ] 1. 使用 Entity Framework Core

1. 加入 EF package

dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.EntityFrameworkCore.SqlServer  

dotnet add package Microsoft.EntityFrameworkCore.Sqlite.Core  

2. 從資料庫建立模型

dotnet ef dbcontext scaffold "Server=192.168.XXX.XXX;Database=[dbname];User ID=[db_account];Password=[db_pw];Trusted_Connection=True;Integrated Security=False;" Microsoft.EntityFrameworkCore.SqlServer -o Models

3. 從資料庫更新模型

dotnet ef dbcontext scaffold "Server=192.168.XXX.XXX;Database=[dbname];User ID=[db_account];Password=[db_pw];Trusted_Connection=True;Integrated Security=False;" Microsoft.EntityFrameworkCore.SqlServer -o Models -f

4. [DB]Context.cs 移除 ConnectionString 設定

5. StartUp.cs 註冊 Db ConnectionString

參考資料：

[EF Core] 在 ASP.NET Core MVC 使用 EF Core

ASP.NET Core 2 系列 - 依賴注入 (Dependency Injection)