managing user secret using environment variables

 

the prefix ASPNETCORE should not be used and should be always unique so what you can do is below:

in Program.cs add the prefix you want to use

for storing only password of the connection string and making a complete connection string 

here in example sa is actually a password so dont get confused.

and to make connection string we need to use sqlconnectionstringbuilder.

here we might have Default connection key in appsetting so manage accordingly.