How to connect a cloud SQL database to an Azure Web App Service

So the Mobile App service that was previously available to us on Azure is gone, that beautiful easy to setup service that helped us connect a SQL database to it, create tables so easily, and manage permissions, is not dead, sort of.

We can still do everything just as before, but the setup is a bit different. Ok, a lot different, if I’m being honest. The basic process is this:

1. Create an Azure SQL service

2. Create a Web App Service

3. Connect them through a connection string

4. Upload the backend code to the Web App Service with Continuous Integration

This is a bit of a longer process than the old one:

1. Create a Mobile App service

2. Follow quickstart

But the result is the same.

You can watch the video of the entire process here:

---

This topic, along with many many others, is covered in greater depth in my 25-hour long "The Complete Xamarin Developer Course: iOS and Android" course, which you can practically steal from me by