ASP.NET CORE MVC | System.ArgumentNullException : 'Value cannot be null. ' | Configuration.GetConnectionString

Question

I'm using MVC on Asp.NET Core, & actually, the Startup doesn't find my ConnectionString written the appsettings.json. I've already tried in 3 different ways (2 in comments). Do not pay attention about the "XXX"s.

Let's see : Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    [...]
    services.AddDbContext<ApplicationDbContext>(options =>
        options.UseOracle(Configuration.GetConnectionString("Web")));
    //options.UseOracle(Configuration.GetSection("ConnectionStrings")["Web"]));
    //options.UseOracle(Configuration.GetSection("Web")["ConnectionString"]));
    [...]
}

appsettings.json :

[...]
"ConnectionStrings": {
    "Test1": {
        "ConnectionString": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.X.XXX)(PORT=XXXX))(CONNECT_DATA=(SERVICE_NAME=XXX)));User Id=XXXXX;Password=XXXXX;",
            "ProviderName": "Oracle.ManagedDataAccess.Client"
    },
    "Web": {
        "ConnectionString": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.X.XXX)(PORT=XXXX))(CONNECT_DATA=(SERVICE_NAME=XXX)));User Id=XXXXX;Password=XXXXX;",
            "ProviderName": "Oracle.ManagedDataAccess.Client"
    },
    "Test2": {
        "ConnectionString": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.X.XXX)(PORT=XXXX))(CONNECT_DATA=(SERVICE_NAME=XXX)));User Id=XXXXX;Password=XXXXX;",
            "ProviderName": "Oracle.ManagedDataAccess.Client"
    }
}
[...]

& when I build the project to run in the browser, I've always got this error :

System.ArgumentNullException : 'Value cannot be null. '

Do you have any idea ?

vernou · Accepted Answer · 2020-12-17 08:00:16Z

3

The method IServiceCollection.GetConnectionString just add the prefix ConnectionStrings: in the key.

Then Configuration.GetConnectionString("Web") is similar to Configuration["ConnectionStrings:Web"].

In your case, you need :

Configuration["ConnectionStrings:Web:ConnectionString"]
//or
Configuration.GetConnectionString("Web:ConnectionString")

answered Dec 17, 2020 at 8:00

vernou

7,6825 gold badges40 silver badges74 bronze badges

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

1 Comment

Hashka Over a year ago

Exactly. You're absolutely right. Thank you sir!

Prasad Ramireddy · Accepted Answer · 2020-12-17 08:21:43Z

2

Yes! you need to add Test1/Web/Test2 ..

public void ConfigureServices(IServiceCollection services) {

services.AddDbContext<ApplicationDbContext>(options =>
    options.UseOracle(Configuration.GetConnectionString("Web:ConnectionString")));

}

answered Dec 17, 2020 at 8:21

Prasad Ramireddy

2971 silver badge7 bronze badges

1 Comment

Hashka Over a year ago

Thank you ! I got it know !

Collectives™ on Stack Overflow

ASP.NET CORE MVC | System.ArgumentNullException : 'Value cannot be null. ' | Configuration.GetConnectionString

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related