VS.Net 2003
My ASP.NET app draws information from SQL Server to populate dropdown lists etc. This information changes very seldom and is common to all sessions so I'm storing it in datatables in Application state, which are loaded at application start.
However, on the odd occasion a change IS made to the SQL Server data, it isn't reflected in the application until the app is restarted.
I realize that with VS.Net you only have to modify a configuration file, then the app will restart automatically. However, I don't want end users messing with the app in this fashion, and I'd rather not have them go into IIS and restart an app (or IIS itself) to achieve a restart. From an end-user standpoint this sort of stuff shouldn't be necessary if all they're doing is changing data in SQL Server.
What I'm thinking is to have a password-protected application page with "Admin" functions (I have user/password access control already in place). If there could be a button on that page that says "Restart Application" I'm thinking that would be a nice, user-friendly way to deal with this occasional situation.
Is it possible to programmatically force an application restart in this fashion? Is this desireable/good practice? Any gotchas?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up