In this article we’ll see how to create a provider hosted SharePoint add-in, hosted in Office 365 with an ASP.NET MVC web application, which is using the Azure database.
Prerequisites:
Let’s start:
Create Azure Web application:
Create SQL Database in Azure
Create Tables in Database
Create provider hosted SharePoint add-in
Deployment to Azure Deployment of SharePoint hosted add-in to azure involves mainly 4 steps,
Register SharePoint Add-in to Office 365
Configure Azure web app
Publish SharePoint add-in to Office 365
Publish web app to Azure
Add this add-in to SharePoint
Hope this helps to understand the complete build & deployment cycle.
Setting Up SharePoint 2016 Multi-Server Farm In Azure