title: Setting connection string with username and password in ASP.Core MVC
body: <p>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?</p>
  
  <blockquote>
    <p>ArgumentException: Keyword not supported: 'userid'.\</p>
  </blockquote>
  
  <p>In the code below is my appsettings.json file.When I run the application it throws an error </p>
  
  <pre><code>{
    "ApplicationInsights": {
      "InstrumentationKey": ""
    },
    "ConnectionStrings": {
        "DefaultConnection": "Server=myserver;Database=mydatabase;userid=id;password=mypwd"
    },
      "Logging": {
        "IncludeScopes": false,
        "LogLevel": {
          "Default": "Debug",
          "System": "Information",
          "Microsoft": "Information"
        }
      }
    }
  </code></pre>