Saturday, June 2, 2018

關於 SQL server connectionstring

1. select "manage user secrets" option from project file.
2.  found such kind of string
{
  "ConnectionStrings:DefaultConnection": "Data Source=TERENCELIU_HP_N;Initial Catalog=RetailStuff;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
}



3. in red, you can copy such kind of string from SQL Server Explorer directly,
4. see this picture


you could see a connectionstring field, just copy and paste it.

No comments:

Post a Comment