Configuration.GetConnectionString returns null when running asp.net core on VS Code but fine on Visual Studio

Question

Here is my appsettings.json file

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=localhost;Port=5432;Database=db;User ID=postgres;Password=root"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
    }
  }
}

This is how I retrieve the connection string:

// Only works when run through visual studio not on vs code
Configuration.GetConnectionString("DefaultConnection")

My launch.json

{
    "version": "0.2.0",
    "configurations": [
        {
            "name": ".NET Core Launch (web)",
            "type": "coreclr",
            "request": "launch",
            "preLaunchTask": "build",
            "program": "${workspaceRoot}\\src\\Chlx\\bin\\Debug\\netcoreapp1.0\\Chlx.dll",
            "args": [],
            "cwd": "${workspaceRoot}",
            "stopAtEntry": false,
            "internalConsoleOptions": "openOnSessionStart",
            "launchBrowser": {
                "enabled": true,
                "args": "${auto-detect-url}",
                "windows": {
                    "command": "cmd.exe",
                    "args": "/C start ${auto-detect-url}"
                },
                "osx": {
                    "command": "open"
                },
                "linux": {
                    "command": "xdg-open"
                }
            },
            "env": {
                "ASPNETCORE_ENVIRONMENT": "Development"
            },
            "sourceFileMap": {
                "/Views": "${workspaceRoot}/Views"
            }
        },
        {
            "name": ".NET Core Attach",
            "type": "coreclr",
            "request": "attach",
            "processId": "${command.pickProcess}"
        }
    ]
}

My tasks.json

{
    "version": "0.1.0",
    "command": "dotnet",
    "isShellCommand": true,
    "args": [],
    "tasks": [
        {
            "taskName": "build",
            "args": [
                "${workspaceRoot}\\src\\Chlx\\project.json"
            ],
            "isBuildCommand": true,
            "problemMatcher": "$msCompile"
        }
    ]
}

Do you know how to fix this?

I am running it through the debug pane ".Net Core Launch (Web)" . I can set breakpoints and the method to get the connection string returns null on vs code — bman
– bman, Commented Sep 22, 2016 at 6:21
Please check my edit guys. I added a launch.json and tasks.json — bman
– bman, Commented Sep 22, 2016 at 7:52

Sjoerd · Accepted Answer · 2016-09-22 08:28:31Z

35

You run the program from the root (solution level) and not from the project. Change your "cwd" in the launchsettings.json to ${workspaceRoot}\src\Chlx\

answered Sep 22, 2016 at 8:28

Sjoerd

6605 silver badges10 bronze badges

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

3 Comments

bman Over a year ago

you are awesome

Timo Hermans Over a year ago

Or add applicationsettings.json to the root folder. That fixed it for me :)

hmadrigal Over a year ago

In ASP.NET Core 2.0 I have two projects: WebApi and DataAccess. The WebApi contains the appsettings.json. In the parent directory (containing the two projects) it is the solution file. I was experincing the same issue and: Copying the appsettings.json at the level of the solution or running the app from the WebApi project, any of those resolved my issue

Willie Cheng · Accepted Answer · 2020-09-01 07:17:22Z

3

The Configuration property is defined in the Startup class and it is initialized thru dependency injection. Here is the sample for a project created with dotnet new mvc -au Individual

  public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

answered Sep 1, 2020 at 7:17

Willie Cheng

8,36314 gold badges63 silver badges72 bronze badges

Collectives™ on Stack Overflow

Configuration.GetConnectionString returns null when running asp.net core on VS Code but fine on Visual Studio

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related