private static async Task CreateSprocIfNotExists(string scriptFileName, string scriptId, string scriptName) { var client = new DocumentClient(new Uri(Endpoint), AuthKey); Uri collectionLink = UriFactory.CreateDocumentCollectionUri(DbName, CollectionName); var sproc = new StoredProcedure { Id = scriptId, Body = File.ReadAllText(scriptFileName) }; bool needToCreate = false; Uri sprocUri = UriFactory.CreateStoredProcedureUri(DbName, CollectionName, scriptName); try { await client.ReadStoredProcedureAsync(sprocUri); } catch (DocumentClientException de) { if (de.StatusCode != HttpStatusCode.NotFound) { throw; } else { needToCreate = true; } } if (needToCreate) { await client.CreateStoredProcedureAsync(collectionLink, sproc); } }