Value cannot be null (Parameter 'connectionString') .NET 6

Question

I use .Net 6 and when I want to run my first migration, I get this error:

Value cannot be null. (Parameter 'connectionString')

My appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=Solardb;integrated security=SSPI"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },

  "AllowedHosts": "*"
}

And this is my Configuration method in program.cs:

builder.Services.AddDbContext<SolarDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("ConnectionStrings")));

The connection string you're trying to get is called "DefaultConnection", not "ConnectionsStrings". — David
– David, Commented Dec 29, 2021 at 12:19

Serge · Accepted Answer · 2021-12-29 12:18:57Z

7

You don't need to get the whole section. GetConnectionString does it already. You just need to put the name of connection string

builder.Services.AddDbContext<SolarDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

answered Dec 29, 2021 at 12:18

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

Comments

KaganTrky · Accepted Answer · 2022-05-26 12:52:47Z

0

MY appsettings.json

  "ConnectionStrings": {
"DefaulConnection": "Data source=skinet.db"}

I used a much simpler structure while solving the problem. startup.cs :

services.AddDbContext<StoreContext>(x => 
x.UseSqlite(_config.GetConnectionString("DefaultConnection")));

Writing the following instead of the above may solve the problem.

services.AddDbContext<StoreContext>(x =>
x.UseSqlite(("DefaultConnection")));

answered May 26, 2022 at 12:52

KaganTrky

1

Collectives™ on Stack Overflow

Value cannot be null (Parameter 'connectionString') .NET 6

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related