use npm install -g azure-functions-core-tools over Chocolatey, because Chocolatey installs 32-bit version...
- When running locally, ensure the following AppSettings are present:
- GleifBlobStorage
- GleifSQLConnectionString
- SendGridAPIKey
- LoadSQL uses the new Microsoft.Data.SqlClient as that's the "new flagship data access driver for SQL Server going forward"
- deploy using ZipDeploy
- run on Azure Functions Elastic Premium 2 (EP2) app service plan for sufficient Memory
see GLEIF.FunctionApp.yaml for multi-stage YAML pipeline which performs both Build & Deploy