ASP.NET Identity Web App Azure Deployment

I have an ASP.NET Identity web app with a SQL database that requires deployment to Azure. I also need an automated pipeline set up for this process.

Key Requirements:
- Deploying my web app to Azure App Service
- Setting up an automated pipeline for deployment
- Ensuring seamless connection with the SQL database

Additional Information:
- I have limited access to my Azure account
- The necessary infrastructure on Azure is already set up

Ideal Skills and Experience:
- Proficient in ASP.NET and Azure App Service
- Experience with setting up automated pipelines
- Knowledgeable in managing SQL databases on Azure
- Familiar with Azure account access levels