Connection strings & app settings in asp.net core

Question

Haven't worked in .net core before and I am having some issues with the connection string. I am trying to get the connection string in my controller like so

 SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DefaultConnection"].ToString());

but I am getting an 'Object reference not set to an instance of an object.' in my controller. This is what my appsettings.json looks like

"ConnectionStrings": {
    "DefaultConnection": "Server=(server)\\\\mssqllocaldb;Database=dbName;User ID=user;Password=123123"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"

A N M Mahabubul Hasan · Accepted Answer · 2020-02-03 13:48:27Z

3

You can't get the connection string directly in your controller, but you can inject the configuration and then you can access the connection string like this in your controller

public class HomeController : Controller
{
    public HomeController (IConfiguration configuration)
    {
        var connectionString = configuration.GetConnectionString("DefaultConnection")
    }
}

answered Feb 3, 2020 at 13:48

A N M Mahabubul Hasan

1,61615 silver badges22 bronze badges

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

Comments

AndrewElagin · Accepted Answer · 2020-02-03 14:59:54Z

3

The use of ConfigurationManager assumes the presence of "App.config" in your project, not appsettings.json. Example:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Server=(server)\\\\mssqllocaldb;Database=dbName;User ID=user;Password=123123" />
  </connectionStrings>
</configuration>

To use

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());

answered Feb 3, 2020 at 14:59

AndrewElagin

311 bronze badge

Collectives™ on Stack Overflow

Connection strings & app settings in asp.net core

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