Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App

by

STEP 1: Include the following in OnConfiguring()

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        IConfigurationRoot configuration = new ConfigurationBuilder()
            .SetBasePath(AppDomain.CurrentDomain.BaseDirectory)
            .AddJsonFile("appsettings.json")
            .Build();
        optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
    }

STEP 2: Create appsettings.json: 

  {
    "ConnectionStrings": {       
      "DefaultConnection": "Server=YOURSERVERNAME; Database=YOURDATABASENAME; Trusted_Connection=True; MultipleActiveResultSets=true"        
    } 
  }

STEP 3: Hard copy appsettings.json to the correct directory 

  Hard copy appsettings.json.config to the directory specified in the AppDomain.CurrentDomain.BaseDirectory directory. 
  Use your debugger to find out which directory that is.

Assumption: you have already included package Microsoft.Extensions.Configuration.Json (get it from Nuget) in your project.

More Related Contents:

  1. Getting value from appsettings.json in .net core
  2. Automatically set appsettings.json for dev and release environments in asp.net core?
  3. Read appsettings json values in .NET Core Test Project
  4. ASP.NET Core appsettings.json update in code
  5. Can’t use Count() in C#
  6. Select Tag Helper in ASP.NET Core MVC
  7. How to get current user in asp.net core
  8. .NET Core 2.1 Identity get all users with their associated roles
  9. Change route collection of MVC6 after startup
  10. @Html.Action in Asp.Net Core
  11. How to turn off or handle camelCasing in JSON response ASP.NET Core?
  12. Parse and modify a query string in .NET Core
  13. What are the costs and possible side effects of calling BuildServiceProvider() in ConfigureServices()
  14. Asp.net core Identity successful login redirecting back to login page
  15. Command dotnet ef not found
  16. Custom Authentication in ASP.Net-Core
  17. Where are the ControllerContext and ViewEngines properties in MVC 6 Controller?
  18. Modifying a JSON file using System.Text.Json
  19. How to add OpenIdConnect via IdentityServer4 to ASP.NET Core ServerSide Blazor web app?
  20. Switch between dotnet core SDK versions
  21. Disable transitive project reference in .NET Standard 2
  22. Generate access token with IdentityServer4 without password
  23. Simple token based authentication/authorization in asp.net core for Mongodb datastore
  24. Intercept bad requests before reaching controller in ASP.NET Core
  25. Customize automatic response on validation error
  26. Register AspNetCore 2.1 Identity system with DbContext interface
  27. ‘HttpPostedFileBase’ in Asp.Net Core 2.0
  28. Customize JSON property name for options in ASP.NET Core
  29. Equivalent of UseUrls for .NET Core 3.1/IHostBuilder
  30. Formatting DateTime in ASP.NET Core 3.0 using System.Text.Json

Leave a Comment