--- title: "Todo App Using Azure App Service with SQL Database and Integrated with Azure DevOps" url: "https://www.pulumi.com/dev/examples/classic-azure-ts-appservice-devops/" image: "https://www.pulumi.com/assets/og/dev/examples/classic-azure-ts-appservice-devops.png" --- # Todo App Using Azure App Service with SQL Database and Integrated with Azure DevOps - Source on GitHub: https://github.com/pulumi/examples/tree/master/classic-azure-ts-appservice-devops ## Get started with this example This example lives in the [pulumi/examples](https://github.com/pulumi/examples/tree/master/classic-azure-ts-appservice-devops) repo. Pull down just this directory to follow along: ```bash git clone --filter=blob:none --sparse https://github.com/pulumi/examples pulumi-examples git -C pulumi-examples sparse-checkout set classic-azure-ts-appservice-devops cd pulumi-examples/classic-azure-ts-appservice-devops ``` A Todo List application from Azure Samples GitHub: [.NET Core MVC sample for Azure App Service](https://github.com/azure-samples/dotnetcore-sqldb-tutorial), a web app built with ASP.NET Core, Entity Framework Core and a SQL database. Provisions Azure SQL Database and Azure Application Insights to be used in combination with App Service. Defines an Azure DevOps pipeline to deploy in CI/CD environment. ## Running the App manually with Pulumi CLI 1. Build and publish the ASP.NET Core project: ```bash dotnet publish src ``` 1. Navigate to `infra`: ```bash cd infra ``` 1. Create a new stack: ```bash pulumi stack init dev ``` 1. Login to Azure CLI (you will be prompted to do this during deployment if you forget this step): ```bash az login ``` 1. Restore NPM dependencies: ```bash npm install ``` 1. Configure target Azure environment: ```bash pulumi config set azure:location pulumi config set azure:subscriptionId ``` 1. Define SQL Server username: ```bash pulumi config set sqlUsername ``` 1. Define SQL Server password (make it complex enough to satisfy Azure policy): ```bash pulumi config set --secret sqlPassword ``` 1. Run `pulumi up` to preview and deploy changes: ```console $ pulumi up Previewing changes: ... Performing changes: ... info: 10 changes performed: + 10 resources created Update duration: 1m14.59910109s ``` 1. Check the deployed website endpoint: ```console $ pulumi stack output endpoint https://dev-as10d706a2.azurewebsites.net $ curl "$(pulumi stack output endpoint)" Index - My ToDoList App ... ``` ## Integrating with Azure DevOps `azure-pipeline.yml` in the root folder of this example shows a configuration for Azure DevOps using [Pulumi task](https://marketplace.visualstudio.com/items?itemName=pulumi.build-and-release-task). Pulumi task expects a Pulumi access token to be configured as a build variable. Copy your token from [Access Tokens page](https://app.pulumi.com/account/tokens) and put it into `pulumi.access.token` build variable. `alternative-pipeline` folder contains custom scripts and a pipeline to run Pulumi program in environments that have to access to the marketplace. Follow [Azure DevOps](https://www.pulumi.com/docs/guides/continuous-delivery/azure-devops/) guide for more details.