Ufdjrw

Need assistance with dynamically changing the connectionstring supplied in an API for netcore 2.2.

This is my sample code

Public StartUp

_connectionString = cryptography.GetProtectedValue("RandomName", dbEnvironmentVariableName);

Public ConfigureServices

services.AddDbContextPool(s => s.UseSqlServer(_connectionString));

The user can change the Environment Variable at anytime and I need to have the API pick up this change dynamically each time it is changed.

I can't find anywhere to see that this is occurring except setting up something in the controller, but that just seems wrong.

Any thoughts.

Well, first, you need to stop using connection pooling. This allows multiple instances of your context to use the same connection, which is not something you want if that connection needs to change on the fly.

Then, you need to get the connection string inside the DbContext registration, so that each time an instance is created, it gets the connection string anew. As you have it now, it's global.

services.AddDbContext<MyContext>((provider, options) =>

 // get connection string
 options.UseSqlServer(connectionString);
);

I'm not sure how to write this code for you as it's not clear what's going on with cryptography.GetProtectedValue("RandomName", dbEnvironmentVariableName). In general, here, provider is going to be an instance of IServiceProvider, and you want to use that to get the various services you need to make this call happen.