ASP.NET core Entity Framework null value connection string

Question

I want to connect my api to a SQL Server database. I am getting a null connection string value in my startup class. I totally don't know what I am doing wrong. Could you please check and let me know what should I correct? Thank you in advance.

Startup.cs

var connectionSettings = Configuration.GetSection("Connection").Get<ConnectionSettings>();

services.AddDbContextPool<Context>(
      options => options
            .UseSqlServer(connectionSettings.ConnectionString));

My appsettings.json connection is below:

"Connection": [
{
  "EFMode": "MSSQL",
  "DatabaseName": "Shop",
  "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=Shop;Trusted_Connection=True,MultipleActiveResultSets=True"
}

In Program.cs (main class):

var db = services.GetService<Context>();

if (db != null)
{
    var cs = services.GetService<ConnectionSettings>();
    db.Database.Migrate();

    var dt = services.GetService<DefaultTriggers>();
}

And my Context.cs:

var connectionSettings = config.GetSection("Connection").Get<ConnectionSettings>();

var optionsBuilder = new DbContextOptionsBuilder<Context>();
optionsBuilder.UseSqlServer(connectionSettings.ConnectionString);

return new Context(optionsBuilder.Options);

ConnectionSettings.cs

    public class ConnectionSettings
{
    public string ConnectionString { get; set; }
    public string DatabaseName { get; set; }
}

Yes. I forgot to show ConnectionSettings. Please find below the code: public class ConnectionSettings ' { public string ConnectionString { get; set; } public string DatabaseName { get; set; } }' — Mateusz Kubera
– Mateusz Kubera, Commented Jun 9, 2018 at 11:06

ProgrammingLlama · Accepted Answer · 2018-06-09 11:08:54Z

1

You either have to change your settings so that you have a single connection object (note that I've removed the [ array ]:

"Connection": {
  "EFMode": "MSSQL",
  "DatabaseName": "Shop",
  "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=Shop;Trusted_Connection=True,MultipleActiveResultSets=True"
}

Or you need to instruct the configuration object to load an array of ConnectionSettings:

var connectionSettings = Configuration.GetSection("Connection").Get<ConnectionSettings[]>();
var shopConnection = connectionSettings.First(s => s.DatabaseName == "Shop");

answered Jun 9, 2018 at 11:08

ProgrammingLlama

39.4k7 gold badges78 silver badges104 bronze badges

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

Comments

Joe Audette · Accepted Answer · 2018-06-09 11:14:50Z

0

You could simplify getting the connection string like this:

var connectionString = config["Connection:ConnectionString"];

answered Jun 9, 2018 at 11:14

Joe Audette

37.1k12 gold badges111 silver badges103 bronze badges

Collectives™ on Stack Overflow

ASP.NET core Entity Framework null value connection string

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