An example of SqlCacheDependency cache on asp.net page

This article mainly explains "asp.net page SqlCacheDependency cache example explanation", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn the "asp.net page SqlCacheDependency cache example explanation" bar!

Cache technology is not only a very practical technology in asp.net programming, but also a common technology in large-scale web programming. This paper illustrates this in the form of an example. The details are as follows:

Duration= "999999" SqlDependency= "VS2005_Test:sqlcache" VaryByParam= "none" if it is SqlServer2005, change it to SqlDependency= "CommandNotification. Note the configuration in the configuration file.

Sql cache for data source controls:

The Cahce/SqlCachePage.aspx page code is as follows:

The DataSource control sets the following properties: EnableCaching= "True" SqlCacheDependency= "VS2005_Test:sqlcache" CacheDuration= "Infinite" if it is SqlServer2005, change it to SqlDependency= "CommandNotification note the configuration in the configuration file

Related configurations in web.config:

At this point, I believe that everyone on the "asp.net page SqlCacheDependency cache example explanation" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!