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.






About The Author

Suprotim Agarwal
Suprotim Agarwal, Developer Technologies MVP (Microsoft Most Valuable Professional) is the founder and contributor for DevCurry, DotNetCurry and SQLServerCurry. He is the Chief Editor of a Developer Magazine called DNC Magazine. He has also authored two Books - 51 Recipes using jQuery with ASP.NET Controls. and The Absolutely Awesome jQuery CookBook.

Follow him on twitter @suprotimagarwal.

No comments: