Azure Functions Database Connection String

Jan_V almost nailed it, which led me to experiment with this in the local.settings.json

{  "IsEncrypted": false,  "Values": {    "AzureWebJobsStorage": "UseDevelopmentStorage=true;",    "AzureWebJobsDashboard": ""  },  "ConnectionStrings": {    "MyConnectionString": "[YourConnectionStringHere]"  }}

This allows you to use the ConfigurationManager.ConnectionStrings[] we are all used to.

var sqlConnection = ConfigurationManager                   .ConnectionStrings["MyConnectionString"].ConnectionString;

The best way to do this is to add a Connection String from the Azure portal:

• From your Function App UI, click Function App Settings
• Settings / Application Settings
• Add connection strings

They will then be available using the same logic as if they were in a web.config, e.g.

var conn = System.Configuration.ConfigurationManager                 .ConnectionStrings["MyConn"].ConnectionString;

Or if you're using a non-.NET language, you can use App Settings instead, which become simple environment variables at runtime that your functions can access.

Configuration Manager will be replaced by the new Asp.Net Core Configuration System in Functions Runtime v2.

So if you are using .Net Core you should follow John Gallants Blog article:https://blog.jongallant.com/2018/01/azure-function-config/

• Works with local.settings.json and Settings in Azure Function
• Works with App Settings and Connection Strings