VS2017 EF本地数据库链接

VS2017 EF本地数据库链接

1. 本地数据库连接

server name可以从链接字符串中取: (localdb)MSSQLLocalDB

注意少写一个.

{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Microsoft.EntityFrameworkCore": "Warning",
      "Microsoft.AspNetCore.NodeServices": "Warning",
      "Default": "Warning"
    },
    "Data": {
      "Products": {
        "ConnectionString": "Server=(localdb)\MSSQLLocalDB;Database=SportsStoreAngular;Trusted_Connection=True;MultipleActiveResultSets=true"
      },
      "Identity": {
        "ConnectionString": "Server=(localdb)\MSSQLLocalDB;Database=Identity;Trusted_Connection=True;MultipleActiveResultSets=true"
      }
    }
  }
}

2.新增连接

(localdb)mssqllocaldb

VS2017 EF本地数据库链接

3.修改连接

修改数据库名称,可以连接到具体的数据库里

VS2017 EF本地数据库链接