Azure API doesnt use connection string from configuration, but local one

Question

I have connection string in azure api configuration with the same name, but when i go to api, swagger, it tells me - System.PlatformNotSupportedException: LocalDB is not supported on this platform. returning 500 status. this is how i get connection string from api:

private string _connectionString = string.Empty;

        public string GetConnectionString(string name)
        {
            var configurationBuilder = new ConfigurationBuilder();
            var path = Path.Combine(Directory.GetCurrentDirectory(), "appsettings.json");
            configurationBuilder.AddJsonFile(path, false);

            var root = configurationBuilder.Build();
            _connectionString = root.GetSection("ConnectionStrings").GetSection(name).Value;
            var appSetting = root.GetSection("ApplicationSettings");

            return _connectionString;
        }

API project is on .net 5

Vova Bilyachat · Accepted Answer · 2021-07-14 12:48:19Z

1

This is because you are building you configuration from file only, while you need to add AddEnvironmentVariables so it will add properties from Azure App Service Configuration

Try this:

  public string GetConnectionString(string name)
        {
            var path = Path.Combine(Directory.GetCurrentDirectory(), "appsettings.json");
            var root = new ConfigurationBuilder()
                .AddJsonFile(path, false)
                .AddEnvironmentVariables()
                .Build();

            _connectionString = root.GetSection("ConnectionStrings").GetSection(name).Value;
            var appSetting = root.GetSection("ApplicationSettings");

            return _connectionString;
        }

Since its in library you need add package Microsoft.Extensions.Configuration.EnvironmentVariables which contains AddEnvironmentVariables extension.

The other way to do it would be to add FrameworkReference in your project but that would bring lots of asp.net core stuff you probably dont need

  <ItemGroup>
    <FrameworkReference Include="Microsoft.AspNetCore.App" />
  </ItemGroup>

edited Jul 14, 2021 at 12:48

answered Jul 14, 2021 at 12:03

Vova Bilyachat

19.5k4 gold badges60 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

kaumnen Over a year ago

It says that IConfigurationBuilder does not contain a definition for AddEnvironmentVariables

Vova Bilyachat Over a year ago

try to add namespace using Microsoft.Extensions.Configuration;

Vova Bilyachat Over a year ago

@komnen is that code in librarry or webapi project?

kaumnen Over a year ago

It's in library edit: Oh, could that be a problem? I didnt publish my library yet

Vova Bilyachat Over a year ago

@komnen done. Ask if you have any other questions

|

Collectives™ on Stack Overflow

Azure API doesnt use connection string from configuration, but local one

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related