EF配置

1.nuget添加Microsoft.EntityFrameworkCore.SqlServer

2.

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Data Source = .;Initial Catalog = thinkasp;User Id = sa;Password = 123456;"
  }
}

  services.AddMvc();
            var connectionString = configuration["ConnectionStrings:DefaultConnection"];
            services.AddDbContext<DataContext>(options => options.UseSqlServer(connectionString, providerOptions => providerOptions.CommandTimeout(60)));

3.VS执行报错

Add-Migration InitialDB

Get-ExecutionPolicy -List

Set-ExecutionPolicy RemoteSigned -Scope CurrentUser

依然不行->

Install-Package Microsoft.EntityFrameworkCore.Tools -Version 3.1.0 参考自https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Tools

Update-Database -Verbose

根据数据库生成model->

Install-Package Microsoft.EntityFrameworkCore.Tools
Install-package Microsoft.EntityFrameworkCore.SqlServer

Scaffold-DbContext "Server=.;Database=dbname;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models