originally posted by: here
Eron Wright post some ideas on how to set up queries in Yukon to use, presumably, Yukon's event notification for ASP.NET cache invalidation.
Update: Here's a good summary of the supported caching/notifications in ASP.NET 2.0 for SqlServer 2000 and Yukon.