有线电视机顶盒退钱吗:asp.net缓存机制 - .net新手 - 博客园
来源:百度文库 编辑:中财网 时间:2024/07/09 06:12:11
存是在计算中广泛使用的一种技术,通过将经常访问的数据或存取开销较大的数据保留在内存或硬盘中来提高性能。在 Web 应用程序的上下文中,缓存用于在 HTTP 请求之间保留页或数据,在重用它们时可以不必耗费资源重新创建。
关键
1、@OutputCache指令中的属性:
Duration - 缓存时间(秒)
VaryByParam - 根据使用 POST 或 GET 发送的名称/值对来改变缓存的结果(多参数用分号隔开)
VaryByControl - 根据用户控件中的控件来改变缓存的片段(值是控件ID,多控件用分号隔开)
CacheProfile - 调用配置文件中设置的缓存时间
2、增加数据缓存时用Cache.Insert,可以指定缓存时间
3、替换缓存(Substitution)- 回调函数要是静态的
4、SqlCacheDependency
配置文件中的配置
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
如果不是SqlServer2005的话,应该使用aspnet_regsql注册一下
aspnet_regsql.exe -S "server" -E -d "database" -ed
aspnet_regsql.exe -S "server" -E -d "database" -et -t "table"
如果是Sql验证的话要把-E换成,-U(用户名),-P(密码)
示例
页面输出缓存
Cahce/Page.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Duration="10" VaryByParam="none"
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
API操作缓存
Cahce/Page.aspx.cs
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
页面输出缓存(VaryByParam)
Cahce/PageByParam.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
CacheProfile="CacheTest" VaryByParam="p1;p2"
CacheProfile="CacheTest" - 从web.config中读信息
get或post方式都行
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
上面页所需的web.config中的配置
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
页面输出缓存(VaryByControl)
Cahce/CacheControl.ascx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
DataTextField="text" DataValueField="value">
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Cahce/PageByControl.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
未经缓存设置的容器页:
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
经过VaryByControl设置的用户控件,根据DropDownList的不同缓存不同的内容(用户控件中的@OutputCache指令为Duration="10"
VaryByControl="DropDownList1"):
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
数据缓存
Cahce/Data.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Cahce/Data.aspx.cs
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
替换缓存(部分区域强行不使用缓存)
Cahce/Substitution.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Duration="10" VaryByParam="none"
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
API 向返回当前日期的静态方法中插入动态回调,此回调在每次请求时都会执行
<%
Response.WriteSubstitution(new HttpResponseSubstitutionCallback(GetTime)); %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
使用Substitution 控件插入动态内容
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Cahce/Substitution.aspx.cs
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_7.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_8.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_6.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_9.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
SqlCacheDependency
页的Sql缓存
Cahce/SqlCachePage.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
Duration="999999" SqlDependency="VS2005_Test:sqlcache" VaryByParam="none"
如果是SqlServer2005则改成SqlDependency="CommandNotification
注意配置文件中的配置
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
数据源控件的Sql缓存
Cahce/SqlCachePage.aspx
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_2.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_3.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_4.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_5.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
DataSource控件设置如下属性:EnableCaching="True" SqlCacheDependency="VS2005_Test:sqlcache"
CacheDuration="Infinite"
如果是SqlServer2005则改成SqlDependency="CommandNotification
注意配置文件中的配置
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
<%=DateTime.Now %>
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
CacheDuration="Infinite" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"
SelectCommand="SELECT * FROM [SqlCache]">
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
web.config中的相关配置
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
![](http://image4.360doc.cn/DownloadImg/2009/3/24/32573_2903638_1.gif)
注意
Sql Server 2005 基于通知的缓存失效,不用aspnet_regsql设置,要设置属性SqlDependency="CommandNotification"。在首次执行某 SQL 查询之前,必须在应用程序某处调用 System.Data.SqlClient.SqlDependency.Start() 方法。此方法应放在 global.asax 文件的 Application_Start() 事件中。因为Sql Server 2005 基于通知的缓存失效对支持查询通知的查询语法有许多限制,所以我觉得最好先别用,而是使用轮询机制。在使用轮询机制时如本例子中的SqlCacheDependency="VS2005_Test:sqlcache",冒号前面是配置文件中配置的相关值指向数据库连接,后面是启用SqlCache的表名,注意区分大小写。