Connection string issue with azure sql server

[andreespin]

I'm having an issue to connect to an azure sql, the application was deployed but we can't see the roles when we try to register an user. Is anyone using az sql and can send us the connection string to comparison?

[DanielUlisses]

I upgraded the entire project to target the .net 4.7.2 and added the conditional compilation symbol to net472 in all parts of the project

then I updated the connection string based on https://azure.microsoft.com/en-us/blog/securing-azure-sql-databases-with-managed-identities-just-got-easier/

as the module requires the .net 4.7.2 it may be the issue you have

the connection string now look like:

<add name="LOBMergedEntities" connectionString="metadata=res://*/EMIEDataModel.csdl|res://*/EMIEDataModel.ssdl|res://*/EMIEDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=tcp:<servername>.database.windows.net,1433;Initial Catalog=EMIEDatabase;UID=a;Authentication=Active Directory Interactive;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />