Keyword not supported: 'data source'.
My Connection String:
I have host my mvc4 application in windows azure with entity framework 5 model-first and i got this error. any one please help me.
2
-
According to this question it may have something to do with your connection string.Dangerous– Dangerous2014-07-03 14:39:28 +00:00Commented Jul 3, 2014 at 14:39
-
I have replace ' quotes , but after that getting same error.Ashok Patel– Ashok Patel2014-07-04 12:21:41 +00:00Commented Jul 4, 2014 at 12:21
Add a comment
|
1 Answer
As discussed in the comments and as previously answered here, this is because you have " in your connection string.
You should replace these with single quotes for it to work.
4 Comments
Ashok Patel
<add name="HIPAAtrekDBEntities" connectionString="metadata=res://*/Models.HIPAAtrekDB.csdl|res://*/Models.HIPAAtrekDB.ssdl|res://*/Models.HIPAAtrekDB.msl;provider=System.Data.SqlClient;provider connection string='data source=tcp:g80tw0l2qo.database.windows.net,1433;initial catalog=DatabaceName;user id=fdffddfsf;password=password;MultipleActiveResultSets=True;App=EntityFramework'" providerName="System.Data.EntityClient" /> Like this but solve my issue.
Dangerous
@Ashok Patel - Try removing the last ' before the " that you have at the end of the connection string (just after App=EntityFramework)
Dangerous
@Ashok Patel - Looking back I think my last comment was wrong as I now see the other single quote. I'm not quite sure what the problem is.
Ashok Patel
I think Azure is support only Code-first entity. i have try all the thinks but i have not solve my this issue.