azure function tool for vs2015 connection string

Question

I have created azure function app project using azure function tool for vs2015.

https://blogs.msdn.microsoft.com/webdev/2016/12/01/visual-studio-tools-for-azure-functions/

the project has appsettings.json file, which is being used to read application settings, which we set in application settings section on azure function. the format is

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "",
    ------
   }
}

How do i add connection string in this appsettings.json file , which i have configured in azure function Connection string section

I have tried following { "IsEncrypted": false, "Values": { "AzureWebJobsStorage": "", ------ }, "ConnectionStrings":{ "ConnectionStringName" : "Value" } } I tried to access connecton string by ConfigurationManager.ConnectionStrings["ConnectionStringName"] but no luck... — Utkarsh Patel

Peter Peter · Accepted Answer · 2017-02-09T08:11:04

You can just edit the appsettings.json file in a text editor to add the connection string.

{
  "IsEncrypted": false,
   "Values": {
        "AzureWebJobsDashboard": "<connectionstring>",
        "AzureWebJobsStorage": "<connectionstring>",
        "MyAppsetting": "<connectionstring>",
        .... etc ...
    },
    "ConnectionStrings": {
        "DbConStr": "data source=(localdb)\\MS..." ,
        "ConnectionStringName": "data source=(localdb)\\MS..." ,
         .... etc ...
    }
}

The file should be in the root of your project.

azure function tool for vs2015 connection string

2 Answers