SqlCacheDependency in ASP.NET Whidbey

If you have been playing with the SqlCacheDependency in ASP.NET Whidbey, you know that the MSDN docs are not quite complete and still contain the PDC information from last year.  Here is what the web.config should look like.  I would like to thank Rob Howard and ScottW for setting me straight on this.  The IDE suggests that there is a problem with the XML used, but the ASP.NET application does work.  With the web.config entries from the MSDN docs, the application will not start and complains about an error in the web.config configuration.  I hope that this helps if you have been struggling with trying to get SqlCacheDependency working.  Note that this example is what is used for a Sql 7 or Sql 2000 database using a ASP.NET Whidbey front end.

Wally

<caching>

     <sqlCacheDependency enabled="true">

            <databases>

               <add name="BookSampleChapter10" connectionStringName="webAdminConnection632317440891727674" pollTime="60000" />

             </databases>

      </sqlCacheDependency>

</caching>

 

1 Comment

Comments have been disabled for this content.