Azure Tips and Tricks Part 107 - Day 6 - An end to end scenario with Azure App Service, API Apps, SQL, VSTS and CI/CD

3 minute read

Azure Tips and Tricks Videos are NOW Available! : Get all the goodness of Azure Tips and Tricks in video form. Read more about it here


Most folks aren’t aware of how powerful the Azure platform really is. As I’ve been presenting topics on Azure, I’ve had many people say, “How did you do that?” So I’ll be documenting my tips and tricks for Azure in these posts.

The Complete List of Azure Tips and Tricks

Available Now!

A multi-part series showing an end-to-end possibility

Crystal Tenn and I teamed up to bring an E2E blog series that features an Azure App Service website that communicates with an API project, which communicates to an Azure SQL back-end. The app is a traditional To-Do application based on an existing sample that used ADO.NET, but adapted for Azure deploy and to Visual Studio 2017. The technology/tooling stack is Visual Studio, VSTS, C#, Angular, and SQL.

The process for the app is described below. In Visual Studio, you will start out with a working To Do list application. You will push the code to VSTS (Visual Studio Team Services). Then you will create a CI/CD (Continuous Integration/Continuous Delivery) process in order to deploy to Azure. In Azure you will create 3 resources: Azure Web App, Azure API App, and an Azure SQL Server through this exercise.

Keep in mind : While we won’t be going into the deep specifics of how to code, you should be able to use this guide to look at several parts of the Azure technology stack and how you can best implement them in your organization.

Pre-requisite: Install Git

Create the VSTS Account

1.) Sign up for VSTS if you do not have an account by clicking the Sign Up button on the homepage.

Make sure to use the same email address that you used for Azure.

2.) Create a new VSTS Account by hitting the button on the top right.

3.) After your account is created, then you’ll see the following:

4.) You can optionally rename the project by clicking on the Gear icon and clicking on the Project Name. Note that if you do this, it updates all of your version control paths, work items, queries, and other team project artifacts to reflect the new name.

5.) Click on the push an existing repository from the command line and copy the copy to notepad.

6.) If you’ve already installed Git, then run navigate to your Visual Studio solution and run the following commands in order. You’ll need to change the 4th command to the URL you copied earlier

git init
git add .
git commit -m "Initial commit"
git remote add origin
git push -u origin --all

7.) Go to VSTS and click Code, you should see your code there:

Come back tomorrow and we’ll look at VSTS Continuous Integration.

Want more Azure Tips and Tricks?

If you’d like to learn more Azure Tips and Tricks, then follow me on twitter or stay tuned to this blog! I’d also love to hear your tips and tricks for working in Azure, just leave a comment below.

Leave a Comment