Example 101 - App Services with SQL DB
1 Apr 2018
A traditional enterprise web application architecture, consisting of a website, Restful API and SQL. Both the website and API are deployed into Azure App Service, a fully managed platform to run and scale applications on Windows or Linux. Supported Languages include NET, .NET Core, Java, Ruby, Node.js, PHP and Python. Azure’s fully managed Azure SQL Database service, offers built-in intelligence that learns app patterns and adapts to maximise performance, reliability and data protection.
|Key Features||App Service Offering|
|Support Languages||.NET, .NET Core, Java, Ruby, Node.js, PHP, or Python|
|Maintenance||Fully Managed, high availability with auto-patching|
|Tiers||Shared Compute, Dedicated Compute, Isolated Environment|
|Deployment||Deployment Slots feature and continuous deployment with Git, TFS, GitHub & VSTS|
|Scaling||Automatically scale vertically and horizontally with customisable rules|
|Monitoring||View application performance and health. Integrates with Application Insights for deeper analysis|
|Complexity||Low barrier to entry, majority of existing web applications can be hosted with minimal adjustments *|
|Portability||Can be hosted on traditional web servers such as IIS, Apache|
|Security||Built-in authentication and authorization support. Additionally, if required App Service Environments provide network isolation and improved scale capabilities.|
|Developer Productivity||A fast and simple way to host existing or new applications. APIs, connectors and services through the Azure Marketplace. Quickly implement SSL, SSO|
|Enterprise||Complies with ISO standards, SOC2 accounting standards, PCI security standards and many more|
|Open Source||Supports WordPress, Umbraco, Joomla, Drupal and more|
*If the app requires specific programs to be installed on the machine then this may not be appropriate. A few things to consider like making sure log files don’t write to local drives may be required.
|Key Features||Azure SQL Database|
|Tooling||Use the tools you already have. SQLCMD or the SQL Server Management Studio|
|Maintenance||Fully managed and high availability, no physical administration needed|
|Compatibility||Compatibility with most SQL Server features|
|Scaling||Various service plans and elasticity. Elastic Pool enables higher resource utilisation efficiency with all the databases within an elastic pool sharing predefined resources|
|Migration||Sync and migration tools available like the SQL Azure Federation Data Migration Wizard|
|Hybrid||Azure Hybrid Benefit allows you to use your on-premises Windows Server or SQL Server licenses with Software Assurance to save big when migrating workloads|
|Security||Advanced built-in protection and security features|
Application Performance Management
Application Insights provides rich performance monitoring, powerful alerting and easy-to-consume dashboards. Interactive queries and full-text search make finding the information you need quick and easy.
|Live Metrics||Interactive Data Analytics|
Looking into the code
As mentioned in the about us section, this site is focusing on the architecture, it’s not a guide to writing code. With that said, its worth talking about a few of our design choices.
Firstly, the code flow
In this initial example we’ve chosen to use the full .Net frame work, we could of course have written the app in many languages or even .Net Core 2.1. As the .Net framework is widely used in Enterprise organisations, we felt this was the best choice for our initial example, but in future examples we will move into .Net Core for a cross platform applications.
What about SPA’s?
A word on database connectivity
Many SQL based applications make use of object relational mappers or ORM’s for short. This is a hot topic and there is much debate over when to use an ORM, a micro ORM or whether one at all. We’ve chosen to use an Interface to abstract the repository layer and to write an implementation for each data store.
Going forward we will demonstrate how to use the same ORM for different data stores.
You can also deploy and run containerised web apps and take advantage of all the additional features of App Service. More information can be found at https://azure.microsoft.com/en-gb/services/app-service/containers/
How to Deploy the Examples
- Guide to setting up automated builds for each project using VSTS
- Guide to creating a release in VSTS
- Azure App Service - Quickly create powerful cloud apps using a fully managed platform
- Azure SQL DB - The intelligent relational cloud database service
- Application Insights - Rich performance monitoring and analytics
- Swagger Open API - API developer tools for the OpenAPI Specification (OAS)
The implementation in this project is intended for reference purpose only.