.Net Website - SQL Server Database - Connection String Issue When Publishing to Azure.
Budget: £10 – £20 GBP
I have created an ASP.net App Website which is Published and working as intended on Azure
However I am having a small issue publishing it correctly to Azure.
1. The website pages work as intended when published.
2. However when I create a new order on the website it does not seem to save the order details to the SQL Server Database locally (i cannot view the new order within VS 2019).
3. If I check in the "SQL Server Object Explorer Tab" in VS 2019 and view the database table data the order does not show up.
4. I am thinking this is a simple connection string problem - as i have never published to Azure am likely doing something wrong.
I need some assistance fixing the connection issue.
However I am having a small issue publishing it correctly to Azure.
1. The website pages work as intended when published.
2. However when I create a new order on the website it does not seem to save the order details to the SQL Server Database locally (i cannot view the new order within VS 2019).
3. If I check in the "SQL Server Object Explorer Tab" in VS 2019 and view the database table data the order does not show up.
4. I am thinking this is a simple connection string problem - as i have never published to Azure am likely doing something wrong.
I need some assistance fixing the connection issue.