For enterprise application, where data retrieval is a big issue, caching can enhance the performance in a dramatic fashion. With the launch of ASP.NET 2.0 framework, significant changes have been made to the caching mechanism to reduce the programmer’s headache.
The new DataSource controls include properties that make it easy to cache database data in memory without writing any code. The new support for SQL Cache Invalidation enables you to automatically reload database data in the cache whenever the data is modified in the underlying database. This feature provides you with all the performance benefits of caching, without the worries of the database changes.