Ggtcf

Bartok - Syncopation (1): Meaning of notes in between Grand Staff

Is it ever safe to open a suspicious HTML file (e.g. email attachment)?

How to invert MapIndexed on a ragged structure? How to construct a tree from rules?

How many extra stops do monopods offer for tele photographs?

Won the lottery - how do I keep the money?

TikZ: How to reverse arrow direction without switching start/end point?

Is it convenient to ask the journal's editor for two additional days to complete a review?

Flying from Cape Town to England and return to another province

INSERT to a table from a database to other (same SQL Server) using Dynamic SQL

What steps are necessary to read a Modern SSD in Medieval Europe?

Unclear about dynamic binding

Domestic-to-international connection at Orlando (MCO)

Which one is the true statement?

Rotate a column

Where do students learn to solve polynomial equations these days?

Is it okay to majorly distort historical facts while writing a fiction story?

Writing differences on a blackboard

Math-accent symbol over parentheses enclosing accented symbol (amsmath)

Find non-case sensitive string in a mixed list of elements?

Does increasing your ability score affect your main stat?

Why the difference in type-inference over the as-pattern in two similar function definitions?

Axiom Schema vs Axiom

Necessary condition on homology group for a set to be contractible

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

NetCore 2.2 Change SQLConnection using environment variable

0

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.

sql controller connection-string asp.net-core-webapi

share|improve this question

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

add a comment | 

0

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.

sql controller connection-string asp.net-core-webapi

share|improve this question

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

add a comment | 

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.

sql controller connection-string asp.net-core-webapi

share|improve this question

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

share|improve this question

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

share|improve this question

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

asked Mar 8 at 16:13

qwerty1906qwerty1906

254

1 Answer
1

active

oldest

votes

1

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.

share|improve this answer

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Cryptography just returns an unencrypted connection string. Ok on the connection pool, that makes sense. On the other part, I don't think this still accomplishes changing the connection while the API is up and running. When a new instance is created then I agree, but when the API is already started it would not reset the connectionstring using this method. Hope that makes sense.
  
  – qwerty1906
  Mar 8 at 20:16
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The context is request-scoped, so each request will get it's own instance, with the current connection string at that time. You are correct that once the instance is created, the connection string value is locked, and that is the case regardless. Config reload itself only happens on a per-request basis, so that's not actually an issue in practice. However, if you intend to change the connection string mid-request, then you are in fact out of luck.
  
  – Chris Pratt
  Mar 11 at 12:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, that is what I was figuring, just wanted to make sure.
  
  – qwerty1906
  Mar 11 at 21:56
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55066993%2fnetcore-2-2-change-sqlconnection-using-environment-variable%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

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.

share|improve this answer

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Cryptography just returns an unencrypted connection string. Ok on the connection pool, that makes sense. On the other part, I don't think this still accomplishes changing the connection while the API is up and running. When a new instance is created then I agree, but when the API is already started it would not reset the connectionstring using this method. Hope that makes sense.
  
  – qwerty1906
  Mar 8 at 20:16
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The context is request-scoped, so each request will get it's own instance, with the current connection string at that time. You are correct that once the instance is created, the connection string value is locked, and that is the case regardless. Config reload itself only happens on a per-request basis, so that's not actually an issue in practice. However, if you intend to change the connection string mid-request, then you are in fact out of luck.
  
  – Chris Pratt
  Mar 11 at 12:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, that is what I was figuring, just wanted to make sure.
  
  – qwerty1906
  Mar 11 at 21:56
  

  
  
  
  

add a comment | 

1

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.

share|improve this answer

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Cryptography just returns an unencrypted connection string. Ok on the connection pool, that makes sense. On the other part, I don't think this still accomplishes changing the connection while the API is up and running. When a new instance is created then I agree, but when the API is already started it would not reset the connectionstring using this method. Hope that makes sense.
  
  – qwerty1906
  Mar 8 at 20:16
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The context is request-scoped, so each request will get it's own instance, with the current connection string at that time. You are correct that once the instance is created, the connection string value is locked, and that is the case regardless. Config reload itself only happens on a per-request basis, so that's not actually an issue in practice. However, if you intend to change the connection string mid-request, then you are in fact out of luck.
  
  – Chris Pratt
  Mar 11 at 12:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, that is what I was figuring, just wanted to make sure.
  
  – qwerty1906
  Mar 11 at 21:56
  

  
  
  
  

add a comment | 

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.

share|improve this answer

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

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

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

share|improve this answer

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310

answered Mar 8 at 16:34

Chris PrattChris Pratt

160k21243310