title: SQL server connection to ASP.NET Core website
body: <p>I making a ASP.NET CORE 2.1 website. The database in Visual studio works fine, but when i deployed to the IIS which on another computer, the database not work.
  In log, the error:</p>
  
  <pre><code>fail: Microsoft.EntityFrameworkCore.Query[10100]
    An exception occurred in the database while iterating the results of a query for context type 'WebApplication3.Data.ApplicationDbContext'.
    System.ArgumentException: Keyword not supported: 'id'.
  .................
  </code></pre>
  
  <p>The connectionstring in the web.config:</p>
  
  <pre><code> "ConnectionStrings": {
  "DefaultConnection": "Server=.\\SQLEXPRESS;Database=XXXX;Trusted_Connection=True;ID=XXXXXXX;pwd=XXXXXXXXX;MultipleActiveResultSets=true "
  </code></pre>
  
  <p>},</p>
  
  <p>I read lot of articles for this, but i cant add any plus tags for the connection string, wil be error, the connection string is bad? 
  When i run the project the in Visual Studio i can use database and i see the database in the SQL Server Managment Studio.</p>
  
  <p>For the database i use the "stock database" when  created a the project in visual studio.
  Because i use Entity Framework i need another format connection string?
  <a href="https://i.stack.imgur.com/r6B46.png" rel="nofollow noreferrer">Stock Databse</a></p>