ASP.NET Core .NET 5 打造WebAPI入門教學(2_1) - 資料庫連線設定 Database First,Scaffold-DbContext Build Failed解決方式

需要安裝以下套件
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.Design

指令

Scaffold-DbContext "Server=伺服器位置;Database=資料表;Trusted_Connection=True;User ID=帳號;Password=密碼" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Force

appsettings.json

{
  "ConnectionStrings": {
    "TodoDatabase": "Server=伺服器位置;Database=資料表;Trusted_Connection=True;UserID=帳號;Password=密碼"
  },
}

Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<TodoContext>(options =>
        options.UseSqlServer(Configuration.GetConnectionString("TodoDatabase")));
}

參考文章：

教學課程：使用 MVC 5 開始使用 Entity Framework 6 Code First
Install Entity Framework Core
Creatinga Model for an Existing Database in Entity Framework Core

連接字串-EF Core