Sql SiteMap provider for ASP.NET 2.0
February issue of MSDN magazine has realy cool article (and source code) about new version of SqlServer SiteMap provider. This version is compatible with Sql Server 7.0, 2000 and also 2005. Sql Server 2005 would be the best choise, because this new SiteMap provider has full support for Sql cache dependencies.
This is also the main difference from previous version. Sitemap automatically reloads, when underlying database changes. Other improvements were also made so this version is more consistent with build-in XmlSiteMapProvider. There is a lot to learn from this provider implementation.
This kind of post is really worth reading for because of the new knowledge instilled on the readers.
http://essays.mightystudents.com