CODEWITHSUNDEEP
c#asp.netsql-serverentity-frameworkconnection-string
Buzzyboy
Buzzyboy

Reputation: 231

Keyword not supported: 'data source' in ASP.net Entity Framework 6

I've been poking my brain around for a few days trying to figure this out.

I'm using winhost to host a SQL Server and I've looked up quite a few similar questions with the same issue but they all seemed to have some formatting error that was their issue.

What's wrong with my connection string?

<add name="ContactsDb"
     connectionString="Data Source=tcp:s10.winhost.com;Initial Catalog=DB_84426_webdevct;User ID=DB_84426_webdevct_user;Password=***********;Integrated Security=False;" 
     providerName="System.Data.EntityClient"/>

Upvotes: 7

Views: 9452

Answers (1)

Buzzyboy
Buzzyboy

Reputation: 231

I had to change the provider name to System.Data.SqlClient from System.Data.EntityClient. I was mistaken in thinking I needed the EntityClient for the automagic powers of Entity Framework when connecting to an external SQL Server database. Thank you Paresh J.

Upvotes: 11

Related Questions