Prevent an ASP.NET Application Restart when a Configuration Setting is changed

A change to configuration settings in your web.config leads to an application restart, affecting the Session and Cache objects. How do you prevent it? The answer is by placing configuration information in an external file. To do so, use the little known attribute called ‘configSource’ as shown below:

<connectionStrings configSource="Myconn.config"/>

In the Myconn.config file, declare the connectionStrings as follows:

<connectionStrings>
<
add name="nwstring" connectionString="Data Source=(local);Initial
Catalog=Northwind;Integrated Security=true;
"
providerName="System.Data.SqlClient" />
</
connectionStrings>

Now you can go ahead and change the connectionString even in a live application without worrying about an application restart!

Make sure you also read about the RestartOnExternalChanges property.



Will you give this article a +1 ? Thanks in advance


About The Author

Suprotim Agarwal
Suprotim Agarwal, ASP.NET Architecture MVP (Microsoft Most Valuable Professional) works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He is the Editor of a Developer Magazine called DNC Magazine. He has also written two EBooks 51 Recipes using jQuery with ASP.NET Controls. and The Absolutely Awesome jQuery CookBook

Follow him on twitter @suprotimagarwal

No comments: