1.使用SqlCacheDependency类需要注意的:
CacheDependency类的语法定义如下:
public class CacheDependency : IDisposable
其中继承了接口“IDisposable”,此接口主要用来定义释放分配的非托管资源的方法。继承此接口必须实现方法Dispose,以实现资源的释放。
CacheDependency类的构造函数实现了8个重载,下面的代码列出了这些重载的函数,并详细说明了各函数的参数。了解这些函数就可以知道CacheDependency究竟能为缓存带来什么优势。
//假设缓存的来源文件是当前目录下的data.xml文件
//缓存依赖的文件路径
CacheDependency mydep = new CacheDependency("data.xml");
//缓存依赖的文件可以有多个
CacheDependency mydep1=new CacheDependency(new string []{"data.xml","data1.xml"});
//检查缓存依赖更改的依据时间
CacheDependency mydep2 = new CacheDependency("data.xml", DateTime.Now);
//检查多个依赖文件更改的依据时间
CacheDependency mydep3 = new CacheDependency(new string[] { "data.xml", "data1.xml" }, DateTime.Now);
//检查依赖多个文件,也依赖多个缓存键值
CacheDependency mydep4 = new CacheDependency(new string[] { "data.xml", "data1.xml" },
new string[] { "Category", "Category1" });
//关联依赖,还可以依赖于另一个文件缓存依赖
CacheDependency mydep5 = new CacheDependency(new string[] { "data.xml", "data1.xml" },
new string[] { "Category", "Category1" }, mydep);
//文件和键值上次修改的依据时间
CacheDependency mydep6 = new CacheDependency(new string[] { "data.xml", "data1.xml" },
new string[] { "Category", "Category1" }, DateTime.Now);
//文件、另一个缓存依赖和键值上次修改的依据时间
CacheDependency mydep6 = new CacheDependency(new string[] { "data.xml", "data1.xml" },
new string[] { "Category", "Category1" }, mydep,DateTime.Now);
在配置文件里面需要配置
<connectionStrings>
<add name="TestCacheConnectionString" connectionString="Data Source=CGJ-57F90 CCA64C/sqlexpress;Initial Catalog=testCache;Integrated Security=True" providerName= "System.
Data.SqlClient"/>
</connectionStrings>
在页面上写上这样的语句
<%@ OutputCache Duration="3600" SqlDependency="testCache:CacheTable" VaryByParam="none" %>
C#缓存
最新推荐文章于 2025-08-07 21:35:16 发布