I have managed to deploy a web application on Azure with VS2015 and I have created a database but something seems to be wrong configured in the web.config because I get an error. I have followed a tutorial that helped me through the process.
Here is the link, maybe someone finds it useful: Link to pluralsight tutorial
Well, when I have finished, I got this:
My connection string:
<add name="DefaultConnection" connectionString="Data Source=tcp:xxxx.database.windows.net,1433;Initial Catalog={database};Persist Security Info=False;User ID={xxx};Password={xxxx};MultipleActiveResultSets=False;Connect Timeout=30;Encrypt=True;TrustServerCertificate=False" providerName="System.Data.SqlClient" />
I have tried several solutions on stackoverflow like changing the target framework version to 4.5. from 4.5.2. Link to solution Did not work for me. I would be so greatful if someone could help! Thanks!
If you are using ASP.NET 5 then configure your connection string in appsettings.json file.