ASP.NET Entity Framwork Connection String Keyword not supported: 'initial catalog'

Question

Hey getting the following error when running my MVP Entity Framework App :

Keyword not supported: 'initial catalog'.

My Config is as follows :

    <add name="StevenTestEntities" 
connectionString="metadata=res://*/Model.TestModel.csdl|res://*/Model.TestModel.ssdl|res://*/Model.TestModel.msl;
provider=System.Data.SqlClient;
provider connection string=Data Source=D000097;
Initial Catalog=StevenTest;
Integrated Security=True;MultipleActiveResultSets=True" 
providerName="System.Data.EntityClient" />

The is occurring on the following method

        public StevenTestEntities() : base("name=StevenTestEntities", "StevenTestEntities")

Which is called in my Entity Designer Class.

-1 for neither putting effort into searching for the problem yourself nor asking a thoughtful, well written question. — Jeff, Mar 22 '12 at 16:49
Not really a duplication, as it is regarding the Entity Framework connection string format. Wasn't a very well formatted question to begin with, but it has been tidied up a bit. — Tim B James, Mar 22 '12 at 16:57

score 7 · Accepted Answer · edited May 18 '16 at 16:58

Are you missing the " from the connection string section.

Should be

<add name="StevenTestEntities" 
connectionString="metadata=res://*/Model.TestModel.csdl|res://*/Model.TestModel.ssdl|res://*/Model.TestModel.msl;
provider=System.Data.SqlClient;
provider connection string=&quot;Data Source=Data Source=D000097;
Initial Catalog=StevenTest;
Integrated Security=True;MultipleActiveResultSets=True&quot;"
providerName="System.Data.EntityClient" />

Try that out.

ASP.NET Entity Framwork Connection String Keyword not supported: 'initial catalog'

1 Answers1