title: Entity Framework Core - error: keyword not supported: '"server'
body: <p>I am using Entity Framework Core 2.1. I scaffold my entity classes aka database first. When I try to get the data from one of the db tables, I get an error "keyword not supported for 'server'."</p>
  
  <p>I googled and it looks like my connection string is not correct. Here it is setting in my json file</p>
  
  <pre><code>"DefaultConnection": "\"Server=myDb.com;Database=MyDb;user id=admin;Password=Password;MultipleActiveResultSets=true;Provider=System.Data.SqlClient"
  </code></pre>
  
  <p>I have seen other type of EF connection like</p>
  
  <pre><code>connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=(local);initial catalog=test;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&amp;quot;"
  </code></pre>
  
  <p>I am not sure about the .csdl, ssdl and msl. </p>
  
  <p>Any help is appreciated. Thanks.</p>
  
  <p>Error:</p>
  
  <blockquote>
    <p>System.ArgumentException: Keyword not supported: '"server'. </p>
    
    <p>at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary<code>2 parsetable, String connectionString, Boolean buildChain, Dictionary</code>2 synonyms, Boolean firstKey)<br>
    at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary<code>2 synonyms)<br>
    at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)<br>
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)<br>
    at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions&amp; userConnectionOptions)<br>
    at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
       at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
       at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
       at Microsoft.EntityFrameworkCore.Internal.LazyRef</code>1.get_Value()
       at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
       at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable<code>1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
       at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func</code>3 operation, Func<code>3 verifySucceeded)
       at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable</code>1.Enumerator.MoveNext()
       at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable<code>1 results, QueryContext queryContext, IList</code>1 entityTrackingInfos, IList<code>1 entityAccessors)+MoveNext()
       at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor</code>1.EnumeratorExceptionInterceptor.MoveNext()
    Exception thrown: 'System.ArgumentException' in Microsoft.EntityFrameworkCore.dll
    'dotnet.exe' (CoreCLR: clrhost): Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\2.1.2\System.IO.MemoryMappedFiles.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
    The program '[3112] dotnet.exe' has exited with code -1 (0xffffffff).</p>
  </blockquote>