How to read connection string in .NET Core?

by

The posted answer is fine but didn’t directly answer the same question I had about reading in a connection string. Through much searching I found a slightly simpler way of doing this.

In Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    ...
    // Add the whole configuration object here.
    services.AddSingleton<IConfiguration>(Configuration);
}

In your controller add a field for the configuration and a parameter for it on a constructor

private readonly IConfiguration configuration;

public HomeController(IConfiguration config) 
{
    configuration = config;
}

Now later in your view code you can access it like:

connectionString = configuration.GetConnectionString("DefaultConnection");

More Related Contents:

  1. Entity Framework change connection at runtime
  2. Get connection string from App.config
  3. How can I set an SQL Server connection string?
  4. Entity Framework Timeouts
  5. SQL Express connection string: mdf file location relative to application location
  6. Read connection string from web.config
  7. What is the connection string for localdb for version 11
  8. What is IMEX within OLEDB connection strings?
  9. Help with a OleDB connection string for excel files
  10. System.Data.SqlClient.SqlException: Login failed for user
  11. How to fix “The ConnectionString property has not been initialized”
  12. How to check if connection string is valid?
  13. How to add IHttpContextAccessor in the Startup class in the DI in ASP.NET Core 1.0?
  14. encrypt SQL connectionstring c#
  15. Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App
  16. How do I use Web.Config transform on my connection strings?
  17. Read appsettings.json in Main Program.cs
  18. Injection of IUrlHelper in ASP.NET Core
  19. Error handling (Sending ex.Message to the client)
  20. Persist Security Info Property=true and Persist Security Info Property=false
  21. How to stream with ASP.NET Core
  22. An async/await example that causes a deadlock
  23. Could not load file or assembly or one of its dependencies
  24. How to apply an XSLT Stylesheet in C#
  25. How to get the colour of a pixel at X,Y using c#?
  26. Checking network status in C#
  27. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  28. Simulating Cross Context Joins–LINQ/C#
  29. How to ignore route in asp.net forms url routing
  30. Getting the path of the home directory in C#?

Leave a Comment