How to get ConnectionString from appsettings.json in ASP.NET Core

This post shows you how to get a connection string from appsettings.json in ASP.NET Core

You can easily find your connection string add in appsettings.json file.

"ConnectionStrings": {
    "DefaultConnection": "Server=.;Database=dbtest;User Id=sa;Password=123@qaz;Connection Timeout=3000;"

Creating a AppDbConnection class

public class AppDbConnection
    public string DefaultConnectionString { get; set; }

Opening your Startup class, then add a configuration as shown below.

services.Configure<AppDbConnection>(options =>
   options.DefaultConnectionString = Configuration.GetConnectionString("DefaultConnection");

You can get connection string from your repository as shown below.

private readonly string _connectionString;
public DataRepository(IOptions<AppDbConnection> config)
   _connectionString = config.Value.DefaultConnectionString;