ASP NET CORE GetConnectionString doesn't work

Question

I'm new to ASP NET CORE and I'm writing new web API. I'm not able to retrieve connection string from the appsettings.json file and I get an ArgumentNullException. This is the code in my Startup class:

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

    public IConfiguration Configuration { get; }
    public void ConfigureServices(IServiceCollection services)
    {
        services.AddMvc();
        services.AddDbContext<MyDBContext>(options => options.UseSqlServer(Configuration.GetConnectionString("MyDBConnection")));
        ...
    }
}

This is my appsettings.json file:

{
  "ConnectionStrings": {
    "MyDBConnection": "..."
  },
  "Logging": {
    "IncludeScopes": false,
    "Debug": {
       "LogLevel": {
          "Default": "Warning"
       }
    },
    "Console": {
      "LogLevel": {
        "Default": "Warning"
      }
    }
  }
}

What am I missing?

EDIT: This is also my Program.cs class:

public class Program
{
    public static void Main(string[] args)
    {
        CreateWebHostBuilder(args).Build().Run();
    }

    public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
        WebHost.CreateDefaultBuilder(args)
            .UseContentRoot(Directory.GetCurrentDirectory())
            .UseIISIntegration()
            .UseStartup<Startup>();
}

Your code looks good to me, the only thing I would change is to call services.AddMvc() after services.AddDbContext (in fact after any other service registration). — Isma
– Isma, Commented Feb 27, 2019 at 10:00
I put it at the end, after other service registartion, but nothing changes — Nicolas P
– Nicolas P, Commented Feb 27, 2019 at 11:47
@NicolasP Then there is something wrong in anywhere. Can you give remote access with team viewer so that I can fix this. — TanvirArjel
– TanvirArjel, Commented Feb 27, 2019 at 11:55
I think the problem is Directory.GetCurrentDirectory() which might cause issues debug and make sure that the path is the correct one. — A_kat
– A_kat, Commented Feb 27, 2019 at 12:01
@AntoniosKatopodis yes, it is. I removed it and now seems that it works, thanks! — Nicolas P
– Nicolas P, Commented Feb 27, 2019 at 12:04

A_kat · Accepted Answer · 2019-02-27 12:10:05Z

1

Just to answer this. Directory.GetCurrentDirectory() will get the bin/debug or release location.

This means that it will not be the project location. So it can not find the application.json and also it would also not be able to find your MVC views later on.

answered Feb 27, 2019 at 12:10

A_kat

1,57713 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

ASP NET CORE GetConnectionString doesn't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related