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:
Open Package Manager(PM): Tools -> Library Package Manager -> Package Manager Console.
You can select different projects using Default projects’ dropdown list. Type the following command
PM> Install-Package EntityFramework
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 ". I have faced of another exception which is “Format of the initialization string does not conform to specification starting at index 120.“