一，数据库先行方案

1.引用Entity Framework Core

在NuGet命令行下安装引用：

Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Tools

2.生成实体类

Scaffold-DbContext -Connection "Data Source=10.8.59.xxx;Initial Catalog=Dagdb;uid=sa;pwd=gis1a6b7c!Z" Microsoft.EntityFrameworkCore.SqlServer -OutputDir "Models"

3.项目使用

打开Startup.cs，在ConfigureServices添加数据库连接

  public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<DataContext>(config =>
            {
                config.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
            });
            services.AddControllers();
        }

在appsettings.json配置数据库链接

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=10.8.59.251;Initial Catalog=Dagdb;uid=sa;pwd=gis1a6b7c!Z"
  }
}

4.项目使用