Share via

Azure SQL Database and API

Red255 71 Reputation points
2022-01-31T19:31:57.16+00:00

I would like to create a SQL Database and use an API to expose various functions to the outside world (app). In the past I have done this on a web based sql server and asp.net backend to create a webservice. Is it possible to create something similar in Azure? Can I create a SQL database then access it using an API which exposes endpoints to the outside world - I guess REST service. If it is possibles any tutorials on doing this would be appreciated as this is not my main area of expertise.

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
2,447 questions
Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,937 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-01-31T20:09:35.49+00:00

    Many operations of Azure SQL Database can be done using native REST API as you can see in this documentation.

    You can also create your own API to perform data manipulation operations using Azure Functions as explained step-by-step here.

    Here is a way to create a .NET API using Azure SQL and Azure App Service.

    Finally, creating a Web API using Azure Web Apps and connecting to Azure SQL is explaine here.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.