Monthly Archives: September 2016

You are browsing the site archives by month.

Enable SQL Azure access from Azure WebJobs by adding firewall rules using PowerShell

Hi, When we are developing custom Azure Web Apps or WebJobs, likely we will need access to Azure SQL database. Depends on the needs you will use Entity Framework, or direct Queries using Stored Procedures, but this is not the topic of this post. The topic today is how to allow our Azure WebJob to Read More →

How to Unzip Azure Blobs programmatically using Memory Streams in Azure WebJOBs

Hi, Recently I had to extract files from a .zip file stored on Azure Blob Storage in Azure WebJob process.   This is what I did from scratch: 1. Create WebJob project: https://azure.microsoft.com/en-gb/documentation/articles/websites-dotnet-webjobs-sdk/ 2. Create Non-continuous Azure WebJob: https://github.com/Azure/azure-webjobs-sdk-samples/blob/master/BasicSamples/TableOperations/Program.cs static void Main(){    var host = new JobHost();    host.Call(typeof(Functions).GetMethod(“MyMethod”));} public class Functions{       [NoAutomaticTrigger]        public static void Read More →

How to provide SharePointContext to a Web API Action (ApiController) in a Provider-hosted SharePoint ADd-In

Hi, Recently I have been played with Azure Web Apps, and its integration with SharePoint. In this post we will see how to provide Authentication to Web API REST actions using SharePointContext, which means that we only will be able to invoke our REST actions if we are behind the context of SharePoint Provider-hosted App. Read More →