Skip to main content

Xamarin + Azure: Part 1 – The Basics

The following article covers a presentation and demo at Xamarin Dev Days in Mauritius. The article demonstrates how to get started with Azure Mobile Apps and benefit the powers of the cloud in terms of Scalability, Offline Sync and Data Analytics. 
This is the first part of the series where the basics of Azure App service is demonstrated.


Xamarin is a cross-platform implementation of the Common Language Infrastructure (CLI) and Common Language Specifications (often called Microsoft .NET). With a C#-shared code base, developers can use Xamarin tools to write native Android, iOS, and Windows apps with native user interfaces and share code across multiple 

However, today, mobile apps can’t run stand-alone. The data need to be stored where it can be shared and the application should be able to scale as required. This is where the cloud helps us.

Azure App Service

App Service is a platform-as-a-service (PaaS) offering of Microsoft Azure to create web and mobile apps for any platform/any device. Azure App Service runs your apps on fully managed virtual machines (VMs), with your choice of shared VM resources or dedicated VMs. App Service includes the web and mobile capabilities that we previously delivered separately as Azure Websites and Azure Mobile Services. It also includes new capabilities for automating business processes and hosting cloud APIs. 

Creating an Azure App Service Account

1. Go to  
2. Click on New > Web + Mobile > Mobile App 

3. Enter the App Name, Resource Group, Subscription, select pin to dashboard and hit create 

4.  The deployment progress will be displayed on the top right section. This will take 2-3 minutes following which you’ll see the new service on your dashboard. 

Examine the Quick Start Projects

Once the service is deployed, open the App Service and click on Quick Start. This will bring you to sample projects that will help you get started with the server-side code and the client rapidly. For this demo, click on Quick Create and the select Xamarin.Forms. The Portal will then guide you through 3 steps as below. 

Connect to a database

a. Add a data connection 

b. Select Database 

c. Select Database Server 
In this example, an existing SQL Server database shall be used.

d. The next step is to configure the connection string 

e. The new database will now be deployed and will be ready after some minutes 

Create the Table API

The Table API is the back end code that will be used by the mobile app. Microsoft Azure App Service allows supports 2 languages, namely, NodeJS and C#.
In this example, C# code shall be used.

a. The sample can now be downloaded and opened with Visual Studio
b. Once you open the solution, build it to restore the NuGet packages
c. The 3 important section to note are

i. The Data Object
In this example, the class TodoItem represents the data object, which will be used by Entity Framework to do the Object Relational Mapping. 

public class TodoItem : EntityData
    public string Text { getset; }
    public bool Complete { getset; }}

ii. The Controller 
The controller has all the CRUD methods that will interact with the database. 
The addition of a new controller shall be demonstrated in the next article of the series.

iii. The Web.Config File 
The connection string to the SQL Server database created previously has already been added here. 

<add name="MS_TableConnectionString" connectionString="Data Source=(localdb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-devdaysblogService-20161116032732.mdf;Initial Catalog=aspnet-devdaysblogService-20161116032732;Integrated Security=True;MultipleActiveResultSets=TrueproviderName="System.Data.SqlClient" />

d. Now that the major components have been examined, we may now deploy the App to Azure App Service.
i. Right-Click on the project and click publish
ii. Select Azure App Service

iii. Select the Resource Group and click publish

iv. Click publish and after a few minutes the back end code will be deployed.

Consume the Back End code from the Client

Now that the back-end codes have been deployed, we may now connect it to the mobile clients. In this example, we’ll use a Xamarin.Forms project. 
From the portal, click “Download” in the “create a new app” tab. 

i. Open the Application in Visual Studio 2015, build the project to restore the NuGet packages.

ii. All the codes will be in the Portable Project which will be used in the Android, IOS and Windows projects.

iii. The constants.cs file contains the references to the back end mobile app service URI

public static string ApplicationURL @"  ";

 iv. The TodoItem.cs class contains the data model that will be used in the application.

v. The TodoItemManager.cs class is the class that will be used by the client to communicate with the Cloud Back end.
This will be further discussed on the next article.

vi. You can now run the application

4. View the Database
i. To view the connection string, in the azure portal “all resources” and select the server that you created above

Select the database and click show connection strings

ii. In SQL Server Management Studio, input the server name, Login and Password

iii. Examine the tables
As you shown below, the cloud back end automatically created the tables and all the data have been inserted.


In this article, the basics of Azure App Service was demonstrated and in 3 simple steps, the SQL Server, the Cloud Back end and the Client was deployed. In the next article, this sample shall be extended to add custom classes and logic.




Popular posts from this blog

Creating and Querying Microsoft Azure DocumentDB

DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.

This article is available available on theMicrosoft Technet Wiki. This article was highlighted in theTop Contributor awardson the 12th of October 2014. This article was highlighted in the TNWiki Article Spotlight. This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).

DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.
This wiki shall introduce you to this new service.

Setting up a Microsoft Azure DocumentDBGo to the new Microsoft Azure Portal. 

 Click on New > DocumentDB

Enter A Database ID and hit Create!

Query Unstructured Data From SQL Server Using PolyBase

Scope The following article demonstrates how unstructured data and relational data can be queried, joined and processed in a single query using PolyBase, a new feature in SQL Server 2016. Pre-RequisitesIntroduction to Big Data Analytics Using Microsoft Azure Big Data Analytics Using Hive on Microsoft Azure Analyze Twitter Data With Hive in Azure HDInsight Running Hadoop on Linux using Azure HDInsight  Introduction Traditionally, Big Data is processed using Apache Hadoop which is totally fine. But what if the result of this needs to be linked to the traditional Relation Database? For example, assume that from the analysis of tons of application logs, marketing needs to contact some customs that faced problems in an application following a failure in the application.
This problem is solved with PolyBase. PolyBase allows you to use Transact-SQL (T-SQL) statements to access data stored in Hadoop or Azure Blob Storage and query it in an ad-hoc fashion. It also lets you query semi-structure…

Creating and Deploying Microsoft Azure WebJobs

Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.
This article focuses on the basics of WebJobs before demonstrating an example where it can be used.

This article is also available on the Mirosoft TechNet Wiki.
This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).

What is Microsoft Azure WebJobs?
Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.

What Scheduling Options is supported by Microsoft Azure WebJobs? Azure WebJobs can run Continuously, On Demand or on a Schedule.
In what language/scripts are WebJobs written?
Azure WebJobs can be created using the following scripts:  .cmd, .bat, .exe (using windows cmd).ps1 (using powershell).sh (using bash).php (using php).py (using python).js (using node)In this article, the use of c# command line app shall be demonstrated.