EnvironmentVariablesConfigurationProvider not load connection string prefix POSTGRESQLCONNSTR_ on Azure AppService

[thohng]

Description

On Azure AppService, it is able to add connection string for PostgreSQL. But the configuration does not load the PostgreSQL connection string. The workaround is select 'Custom' when adding connection string instead of 'PostgreSQL' provider.

Configuration

Setup PostgreSQL connection string on Azure AppService

Checking Azure AppService Environments

Other information

Latest code on repository:

runtime/src/libraries/Microsoft.Extensions.Configuration.EnvironmentVariables/src/EnvironmentVariablesConfigurationProvider.cs

Lines 15 to 20 in faa0559

	private const string MySqlServerPrefix = "MYSQLCONNSTR_";
	private const string SqlAzureServerPrefix = "SQLAZURECONNSTR_";
	private const string SqlServerPrefix = "SQLCONNSTR_";
	private const string CustomPrefix = "CUSTOMCONNSTR_";
	private readonly string _prefix;

public class EnvironmentVariablesConfigurationProvider : ConfigurationProvider
{
	private const string MySqlServerPrefix = "MYSQLCONNSTR_";
	private const string SqlAzureServerPrefix = "SQLAZURECONNSTR_";
	private const string SqlServerPrefix = "SQLCONNSTR_";
	private const string CustomPrefix = "CUSTOMCONNSTR_";

	private readonly string _prefix;

I couldn't figure out the best area label to add to this issue. If you have write-permissions please help me learn by adding exactly one area label.

[thohng]

Related document of Azure AppService / Configure connection strings

https://docs.microsoft.com/en-us/azure/app-service/configure-common#configure-connection-strings

At runtime, connection strings are available as environment variables, prefixed with the following connection types:

SQLServer: SQLCONNSTR_
MySQL: MYSQLCONNSTR_
SQLAzure: SQLAZURECONNSTR_
Custom: CUSTOMCONNSTR_
PostgreSQL: POSTGRESQLCONNSTR_

[thohng]

Current dotnet document

https://docs.microsoft.com/en-us/dotnet/core/extensions/configuration-providers#connection-string-prefixes

https://github.com/dotnet/docs/blob/main/docs/core/extensions/configuration-providers.md

[davidfowl]

We should just add it.

Tagging subscribers to this area: @maryamariyan, @safern
See info in area-owners.md if you want to be subscribed.

Issue Details

---

Description

On Azure AppService, it is able to add connection string for PostgreSQL. But the configuration does not load the PostgreSQL connection string. The workaround is select 'Custom' when adding connection string instead of 'PostgreSQL' provider.

Configuration

Setup PostgreSQL connection string on Azure AppService

Checking Azure AppService Environments

Other information

Latest code on repository:

runtime/src/libraries/Microsoft.Extensions.Configuration.EnvironmentVariables/src/EnvironmentVariablesConfigurationProvider.cs

Lines 15 to 20 in faa0559

	private const string MySqlServerPrefix = "MYSQLCONNSTR_";
	private const string SqlAzureServerPrefix = "SQLAZURECONNSTR_";
	private const string SqlServerPrefix = "SQLCONNSTR_";
	private const string CustomPrefix = "CUSTOMCONNSTR_";
	private readonly string _prefix;

public class EnvironmentVariablesConfigurationProvider : ConfigurationProvider
{
	private const string MySqlServerPrefix = "MYSQLCONNSTR_";
	private const string SqlAzureServerPrefix = "SQLAZURECONNSTR_";
	private const string SqlServerPrefix = "SQLCONNSTR_";
	private const string CustomPrefix = "CUSTOMCONNSTR_";

	private readonly string _prefix;

Author:	thohng
Assignees:	-
Labels:	untriaged, area-Extensions-Configuration, in pr
Milestone:	-

[thohng]

The issue is not fixed