Azure Mobile App Services Implementation

What Is Azure Mobile App Services?

Azure App Service is a fully-managed Platform-as-a-Service (PaaS) offering for professional developers. The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that's highly scalable and globally available.

The advantages are:

(For more information please refer to this link: Reference Link.)

Build engaging mobile apps fast
Quickly add corporate sign-in
Use offline data sync to build responsive apps
Connect your apps to on-premises data
Auto scale to fit your business
Broadcast personalized push notifications to millions in minutes

Create Azure Mobile Service Through Visual Studio

Note

Please install Azure SDK in your Visual Studio. If you don't have it installed please update your Visual Studio with cloud features.

In your Visual Studio right-click your project, click Manage NuGet Packages, search for the Microsoft.Azure.Mobile.Client package, then click Install.

In your main activity file, remember to add the following using statement:

using Microsoft.WindowsAzure.MobileServices;

Step 1

First, select ASP .Net Web Application, rename the project name as you like. Please refer to the below figure.

The second step is to select the Azure Mobile App and click on the Ok button. Please refer to the below figure.

Now your solution is ready to run by the default "TodoItemController" controller. Run your solution. Refer to the below figure.

Step 2

Please add the below tag in webconfig file under ConnectionStrings tag. The below connection string is pointing to our Database. (For security reasons, I am not mentioning my db credentials; please use your appropriate database credentials).

<add name="MS_TableConnectionString" connectionString="Server=;Database=;User ID=;Password=;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;" providerName="System.Data.SqlClient" />

Step 3

Right-click on the DataObjects folder and select the Add option and create the class.

I have created a class and named it AzureMobileAppDemoTbl. Please see the below figure.

Class IS

using Microsoft.Azure.Mobile.Server;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace AzureMobileAppServices.DataObjects
{
public class AzureMobileAppDemoTbl : EntityData
{
public int studentid { get; set; }
public string name { get; set; }
}
}

In the above code AzureMobileAppDemoTbl is inherited EntityData abstract class. EntityData class is implementing ITableData Interface.

What is ITableData Interface?

Microsoft.Azure.Mobile.Server.Tables.ITableData provides an abstraction indicating how the system properties for a given table data model are to be serialized when communicating with the clients. The uniform serialization of system properties ensures that the clients can process the system properties uniformly across platforms. It contains default properties such as Id, Version, CreatedAt, UpdatedAt, Deleted.

As of now in our class "AzureMobileAppDemoTbl" we have 2 properties such as student id and name. But we inherited EntityData class and for that reason, our class has the properties of EntityData(base) class also.

Step 4

Now we are creating a controller. Right-click on the "Controllers" folder and go for creating a controller.

Please check the below figure. Select Azure Mobile Apps table controller.

On the click of the Azure Mobile Apps Table controller, you will get one small window and in that, we need to -

Choose a Model (it means our DTO Object)
Select a Mobile Service Context.
Specify the controller name.

Once you click on the Add Button, it will start to do the Scaffolding process. After that, it will create AzureMobileAppDemoTblController with Post, Get, Patch, Delete methods.

The important thing is we selected Azure Mobile Apps Table controller and mapped to AzureMobileAppDemoTbl class right, so with the help of the code first approach it will create one table having AzureMobileAppDemoTbl class properties as columns.

Code snippet of "AzureMobileAppDemoTbl Controller"

using System.Linq;
using System.Threading.Tasks;
using System.Web.Http;
using System.Web.Http.Controllers;
using System.Web.Http.OData;
using Microsoft.Azure.Mobile.Server;
using AzureMobileAppServices.DataObjects;
using AzureMobileAppServices.Models;
namespace AzureMobileAppServices.Controllers
{
public class AzureMobileAppDemoTblController : TableController<AzureMobileAppDemoTbl>
{
protected override void Initialize(HttpControllerContext controllerContext)
{
base.Initialize(controllerContext);
MobileServiceContext context = new MobileServiceContext();
DomainManager = new EntityDomainManager<AzureMobileAppDemoTbl>(context, Request);
}
// GET tables/AzureMobileAppDemoTbl
public IQueryable<AzureMobileAppDemoTbl> GetAllAzureMobileAppDemoTbl()
{
return Query();
}
// GET tables/AzureMobileAppDemoTbl/48D68C86-6EA6-4C25-AA33-223FC9A27959
public SingleResult<AzureMobileAppDemoTbl> GetAzureMobileAppDemoTbl(string id)
{
return Lookup(id);
}
// PATCH tables/AzureMobileAppDemoTbl/48D68C86-6EA6-4C25-AA33-223FC9A27959
public Task<AzureMobileAppDemoTbl> PatchAzureMobileAppDemoTbl(string id, Delta<AzureMobileAppDemoTbl> patch)
{
return UpdateAsync(id, patch);
}
// POST tables/AzureMobileAppDemoTbl
public async Task<IHttpActionResult> PostAzureMobileAppDemoTbl(AzureMobileAppDemoTbl item)
{
AzureMobileAppDemoTbl current = await InsertAsync(item);
return CreatedAtRoute("Tables", new { id = current.Id }, current);
}
// DELETE tables/AzureMobileAppDemoTbl/48D68C86-6EA6-4C25-AA33-223FC9A27959
public Task DeleteAzureMobileAppDemoTbl(string id)
{
return DeleteAsync(id);
}
}
}

After doing this process the API is ready for making a CRUD operation with mapped table. Let's check with help of postman.

Note
While calling the API in the header we need to pass the API version keys. If you are not passing the API version at the header it means it will throw an exception.

Please refer to the below figure.

So please pass the below keys:

"key":"ZUMO-API-VERSION","value":"2.0.0"

Insert Query

URL:-Http://localhost:64729/tables/AzureMobileAppDemoTbl

Method:-POST

Please check the bellow figure. We are calling API and the method is POST. In the body, we are posting data that needs to insert to a particular table.