azure method blows up if the records does not exist
I am using this method from the azure mobile services tutorial: await todoTable.LookupAsync(id). I have 2 rows in a table of id 1,2. If i do await todoTable.LookupAsync(1), it works and return the record. If i do await todoTable.LookupAsync(8) to see how it's going to handle null, it just blows up with Not Found exception. Thanks for help on this.
NULL would mean there is a record for id = 8, but its value is `NULL'. But in your case you do not have a record. Which is different. What you observe is what you should observe if you do not have a record. And this is a standard for REST based HTTP services. If record is not there, you get an HTTP 404 from the service. Azure mobile services is nothing more than a combination of Web API and a wrapping (plumbing) code for your application. And every Web API call to a non-existent record would result into an HTTP 404 error. And as already said in the comments, you should wrap your code around try - catch blocks and inspect the exception. In .NET 4.5/4.6 there is new HttpClient type along with HttpResponseMessage and HttpRequestMessatge. The former has EnsureSuccessStatusCode() method. Which, if called will trigger exception. In the older versions of the Framework there WebClient class, which would throw an exception if the HTTP status code is not 200. So, again, at the end - you observe absolutely normal behavoir. Just have to read a little more about HTTP REST services, HTTP VERBS and HTTP Status Codes. Then also understand how the particular framework you use (.NET) handles the HTTP Status Codes.
Dynamitey exception when accessing input DocumentDB with F# in Azure Functions
Buying a domain through azure fails
Azure Queue - Reappearing mesages
A Branding RBAC role for Azure
How to delete 200k files from a directory in Azure?
Behavior of Asterisk(*) in Azure Search Service
Copy page blob from one storage account to Another storage account using .Net API startCopy
Azure Active Directory: One user with multiple providers account
Azure Cloud Service - Bad Request on external computer
VSTS deployment fails with “Authorization failed for … of type 'Microsoft.Storage/storageAccounts/providers/locks'”
How Scale-out work in Azure App Services
Azure - Best practice to scale a single thread app based on pending items
traffic manager for https azure website
How to combine account credits for Azure servers
Monitoring Bing Maps API requests
Azure AD Graph API - Assigning a group with role to a tenant's application (ServicePrincipal)