Change connection string dynamically from C#

Question

I would like to know how can I change the connection string dynamically from C# in run time. I have 3 connection string in the App.config, I would like to know how can I change one of the connections dynamically.

P.S I use Ado.NET , Entity Framework.

Answer 1

Every time you want to change the connection string just you change the main connection string in App.Config file.

Reference