DocumentDbRepository.cs

// Stored Procedures
private const string TransferGoldStoredProcedureScriptFileName = @"Models\DocumentDB\js\transferGoldStoredProcedure.js";
private const string TransferGoldStoredProcedureId = "transferGold";
private const string GetRecentPhotosForCategoriesStoredProcedureScriptFileName = @"Models\DocumentDB\js\getRecentPhotosForCategoriesStoredProcedure.js";
private const string GetRecentPhotosForCategoriesStoredProcedureId = "getRecentPhotosForCategories";
        
private async Task InitializeStoredProceduresInDocumentDb()
        {
            // Initialize GoldTransaction Sproc
            var sproc = new StoredProcedure
            {
                Id = TransferGoldStoredProcedureId,
                Body = File.ReadAllText(TransferGoldStoredProcedureScriptFileName)
            };
            await _documentClient.UpsertStoredProcedureAsync(DocumentCollectionUri, sproc);

            // Initialize GetCategoriesPreview Sproc
            sproc = new StoredProcedure
            {
                Id = GetRecentPhotosForCategoriesStoredProcedureId,
                Body = File.ReadAllText(GetRecentPhotosForCategoriesStoredProcedureScriptFileName)
            };
            await _documentClient.UpsertStoredProcedureAsync(DocumentCollectionUri, sproc);
        }