No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’

Working with Entity Framework in the service that is consumed by BizTalk server, I realized that if we didn’t install entity framework required packages the EF throws an exception which is “No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient“. The error details are as follows:

2

Open Package Manager(PM):  Tools -> Library Package Manager -> Package Manager Console.

3

You can select different projects using Default projects’ dropdown list. Type the following command


PM> Install-Package EntityFramework

4

If this solution doesn’t solve your problem, you try to remove “App=EntityFramework” from connection string. Be carefull when deleting this part, I had been deleted with &quot. I have faced of another exception which is Format of the initialization string does not conform to specification starting at index 120.

1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s