Deploying ASP.NET Core Web API with SQL database

Question

I have created a small todo app for my resume. Now I am struggling with deploying (backend: ASP.NET Core Web API, frontend: vueJs and database).

I have tried to deploy the ASP.NET Core Web API to Azure, but failed to connect with the database.

Could you explain the full deployment process?

Where does your database belongs to? Azure as well? If so replace your connection string before publishing your app to azure portal then, you should have resource group under that resource group you should have the app service. You have to finally publish your app on this app service then your application can operational. If you have your backend and frontend in different project then do the same. If your application has authentication stuff integrated then you have to have a look on azure active directory as well. — Md Farid Uddin Kiron
– Md Farid Uddin Kiron, Commented Dec 31, 2021 at 1:19
No, My database is on my local machine. I have tried to deploy it on azure but failed. — JmlKhan
– JmlKhan, Commented Dec 31, 2021 at 5:21
Does it mean that your deployment was successful but you cannot connect the database right? If so then you cannot connect your local database with deployed app unless you have hybrid connection with azure SQL to your local database. You can have a look on our official guideline here — Md Farid Uddin Kiron
– Md Farid Uddin Kiron, Commented Dec 31, 2021 at 5:40
Well, I found what is wrong. It is connection between azure SQL server and my app. I configured everything shown in doc but database responds 400 status — JmlKhan
– JmlKhan, Commented Dec 31, 2021 at 13:22

Thiago Custodio · Accepted Answer · 2021-12-30 15:41:00Z

1

You just need to configure it under App Settings -> Configuration

answered Dec 30, 2021 at 15:41

Thiago Custodio

18.4k9 gold badges50 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1