If the Web app uses entity framework, locally the connection string is like this:
<add name="Entities" connectionString="metadata=res://*/EF.Model1.csdl|res://*/EF.Model1.ssdl|
res://*/EF.Model1.msl; provider=System.Data.SqlClient;provider connection string="data source=(local);
initial catalog=blogDb;persist security info=True;user id={yourId};password={yourPass};MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
The issue is the HTML encoding: $quot; <=> " that the Pubilsh does not convert those encoding back to a double quote.
On Azure => Web App => Configuration => Application settings => Found or create a Connection string:
Name: Entities
Value: metadata=res://*/EF.Model1.csdl|res://*/EF.Model1.ssdl|
res://*/EF.Model1.msl;provider=System.Data.SqlClient;
provider connection string="data source=tcp:xg-sql.database.windows.net,1433;initial catalog=blogDb;persist security info=True;user id={yourName};password={yourPass};MultipleActiveResultSets=True;App=EntityFramework"
Type: Custom