Working with Data in ASP.NET 2.0 Tutorials Caching

Scott Mitchell has made available 4 new Working with Data in ASP.NET 2.0 tutorials. You can get these including VB and C# code here: http://scottonwriting.net/sowblog/posts/12751.aspx

Here is a description of the tutorials:

Caching Data with the ObjectDataSource - explores key concepts of caching and looks at how to declaratively cache data using the ObjectDataSource.

Caching Data in the Architecture - examines adding caching support to the application architecture by creating a separate Caching Layer (in addition to the Business Logic Layer and Data Access Layer).

Caching Data at Application Startup - for static data or expensive queries whose underlying data seldom changes, it may be optimal to cache this data at application startup. This topic is explored in detail in this tutorial.

Using SQL Cache Dependencies - one challenge of caching is data staleness. Since the cache is just a copy of the underlying data, if the underlying data changes, the cached content is no longer valid. Ideally, cached data will immediately be evicted from the cache once the underlying database data has been modified. This is possible with little effort thanks to ASP.NET 2.0's SQL Cache Dependencies. This tutorial looks at different ways to implement SQL Cache Dependencies and steps through using the polling method (which works with all versions of SQL Server 2005 and SQL Server 2000).