How to override appsettings.json with environment variables?

Question

How to override appsettings.json with environment variables for connection string in onconfiguring method in dbcontext class in ASP.NET Core 3.0 project ?

 

I wrote below code in 

 

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

{

if (!optionsBuilder.IsConfigured)

{

IConfigurationRoot configuration = new ConfigurationBuilder()

.SetBasePath(AppDomain.CurrentDomain.BaseDirectory)

.AddJsonFile("appsettings.json")

.Build();

optionsBuilder.UseSqlServer(configuration.GetConnectionString("UserDBContext"));

 }

}