Dynamic Connection String Scenario

Idea: Write a middleware for a connectionstring.config file and refer to it in the appsettings. This could help getting this on the fly. You should avoid to call the DLL method on every request.

Currently, I don't use appsettings.json for storing the connection string.

I invoke "AddInMemoryCollection" method in program.cs and pass config key ("ConnectionStrings:CMSConnectionString") as parameter.

Even if use appsettings or memory-collection it doesn't work. I can access configuration object in middlewares and I can change the connection string. But application doesn't effect from this. Just works correctly when i restart.

Have you tried something like "ConfigurationManager.RefreshSection("connectionStrings")"?

The application isn't .NET Framework. It's Dotnet 5 application (Live Site). Even I've tried writing "custom configuration provider" and "reloading application configs in a middleware" but it doesn't work.

I think only solution is restarting application