How to force DbContext refresh connection string from config

Question

how can I force DbContext to reread a Connection string from config without restart my application? I Change the Password in the config Connection string. I create a new instance of DbContext with the Name=xxxx constructor. But in DbContext.Database.ConnectionString still is the old Password!?

The config file is read in at start-up, none of the values can be modified until your application or website is restarted. If you edit your web.config, your app pool will be restarted automatically. — Mister Epic
– Mister Epic, Commented Aug 16, 2013 at 13:05

Pawel · Accepted Answer · 2013-08-17 06:07:54Z

1

Instead of passing the name of the connection string from the config file you can just pass the connection string to the ctor.

answered Aug 17, 2013 at 6:07

Pawel

31.7k4 gold badges76 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:56:38Z

0

 ConfigurationManager.RefreshSection("xxx")

EDIT:

Looks Like EF Caches, so even teh refresh doesnty work apparently. so try this EF Runtime connection strings

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Aug 16, 2013 at 13:30

phil soady

11.4k5 gold badges55 silver badges100 bronze badges

2 Comments

Martin Schmeller Over a year ago

I already tried it but this doesn't refresh the DbContext. It seems that EF internally caches the connection string when the application starts up. Every new instance of DbContext uses the old Connection string as it was on app startup.

phil soady Over a year ago

then you will be forced to dynaically pass connection to context

Collectives™ on Stack Overflow

How to force DbContext refresh connection string from config

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related