I am currently working on a data analyis tool that uses SQL Server 2005 express edition. Sometimes I find when I am shutting down my application, it takes forever to detach each of the data repositories. There could be maybe up to 200 repositories.
I was thinking maybe of starting a seperate process once the user hits close that starts detaching the repositories in the background while closing the UI and letting the user to work away normal in windows. The only problem I can see with
this solution is if the person reopens my application and starts attaching the same data repositories. Any thoughts or solutions?
View Complete Post