Connecting Windows Apps Using Azure App Service - Part 1

I am getting lot of questions and queries regarding connecting apps to SQL using Azure App Service. So, today I am going to deep dive into:

I will cover part 3 and 4 or Part 2 and Part 3 respectively in the next article to keep things simple.

Let’s Start

WAIT!

I knew about Mobile Service but what is App Service ? What is the difference ? Is Mobile Service discontinued ?

I have answers to that

App Service Mobile Apps is our newest mobile backend platform and gives you additional advantages over Mobile Services. Migrating to App Service is recommended for customers using the .NET backend SDK. However, Mobile Apps Node SDK is currently in preview and is not yet recommended for production use. SDK and API contracts are subject to change within minor version releases.

What advantages do I get with App Service over Mobile Service

Your existing Mobile Service is safe and will remain supported. However there are number of advantages the Azure App Service platform provides for your mobile app that are not available today with Mobile Services: (Reference).

• Simpler, easier and more cost effective offering for apps that include both web and mobile clients.
• New host features including Web Jobs, custom CNames, better monitoring.
• Turnkey integration with Office 365, Dynamics CRM, Salesforce, and other vital SaaS APIs.
• Support for Java and PHP backend code, in addition to Node.js and .NET.
• Turnkey integration with Traffic Manager.
• Connectivity to your on-premise resources and VPNs using VNet in addition to Hybrid Connections.
• Monitoring and troubleshooting for your app using NewRelic or AppInsights, as well as alerts.
• Richer spectrum of the underlying compute resources, e.g. VM sizes.
• Built-in auto scale, load balancing, and performance monitoring.
• Built-in staging, backup, roll-back, and testing-in-production capabilities.

Now we can definitely start

What is App Service

Azure App Service is a fully managed Platform as a Service (PaaS) offering for professional developers that brings a rich set of capabilities to web, mobile and integration scenarios. Mobile Apps in Azure App Service offer a highly scalable, globally available mobile application development platform for Enterprise Developers and System Integrators that brings a rich set of capabilities to mobile developers.

Creating App Service

Step 1: Login on your Azure Portal.

Step 2: Click on New, then on Web + Mobile,

Step 3: Click on Mobile App,

Step 4: Enter your desired name for Mobile App Service then click on Create (You can also change the other settings as per your wish),