参数异常：不支持关键字："持久安全信息".NET Core MVC 2.0

Question

我得到了异常

参数exception：不支持关键字：'persistSecurity info'

尝试读取从.NET CORE 1.1升级到.NET Core 2.0后尝试阅读到数据库时。项目使用的.NET Core MVC框架与EF Core。

AppSettings.json

"ConnectionStrings": {
    "DBConnection": "Server=tcp: server.address, 1433;Initial Catalog=SmartDB;PersistSecurity Info=False;User ID=username;Password=password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  }

startup.cs

  services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("SmartDBConnection")));

Answer 1

我认为该参数应该是Persist Security Info或PersistSecurityInfo，而不是一个空间的PersistSecurity Info。

Answer 2

应该是 Persist Security Info，因此更新的连接字符串是

 "DBConnection": "Server=tcp: server.address, 1433;Initial Catalog=SmartDB;Persist Security Info=False;User ID=username;Password=password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

`