Setting connection string with username and password in ASP.Core MVC

Question

I am working on my first ASP.NET Core MVC application.What is the right way to specify the connection string in a ASP.NET Core MVC application with a sql server backend requiring sql authentication?

ArgumentException: Keyword not supported: 'userid'.\

In the code below is my appsettings.json file.When I run the application it throws an error

{   "ApplicationInsights": {     "InstrumentationKey": ""   },   "ConnectionStrings": {       "DefaultConnection": "Server=myserver;Database=mydatabase;userid=id;password=mypwd"   },     "Logging": {       "IncludeScopes": false,       "LogLevel": {         "Default": "Debug",         "System": "Information",         "Microsoft": "Information"       }     }   } 

Answer 1

user<space>id 

Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword;

https://www.connectionstrings.com/sql-server/

Answer 2

That's because the correct keyword is User Id, as shown in the following example:

"ConnectionStrings": {     "DefaultConnection": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;password=myPassword;Trusted_Connection=False;MultipleActiveResultSets=true;"   }