GUI for Azure SQL Database Table

Question

We have a Azure SQL DB and wanted to build a UI for one of the table to maintain data, business need to add new entries or update existing ones. It is just for one table.

• What is the best Azure resource for this? Must be cheap and easy to maintain.
• Can the URL be part of my company domain. ex: https://www.mycompany.com/edittableXYZ ?

Answer 1

Hi @Giri, Seshu Thank you for posting your question on Microsoft Q&A.

As per my understanding you are looking to build a UI for one of the tables in Azure SQL DB to maintain data ans add new entries or update existing ones.

In addition to @Alberto Morillo 's answer above, you can try Power Apps as a low-code option (requires a separate subscription, not an Azure service) or eventually Office Forms and integration with Power Automate or Logic Apps. For software developers, Azure Static Webapps would be a great fit (it integrates well with Azure Functions that can call Az SQL DB).

Regards,
Oury

Answer 2

This tutorial shows you how to deploy an ASP.NET CRUD app in App Service and connect it to Azure SQL Database.

You can make a URL rewrite if needed with Azure Web Apps.

Answer 3

Thanks @Oury Ba-MSFT and @Alberto Morillo

Quick question, since

• It is going to be a single page application and we already have a Azure subscription

Which is one is cheaprer? App Service or Power Apps?