SqlCacheDependency 缓存数据库依赖

 

启用SQL SERVER 通知

aspnet_regsql.exe -S <Server> -U <Username> -P <Password> -ed -d Northwind -et -t Employees

配置文件调整

<system.web>
<caching>
    <sqlCacheDependency enabled="true" pollTime="60000">
    <databases>
        <add name="KM_ERP" connectionStringName="ERPSqlConnectionString" pollTime="60000"/>
    </databases>
    </sqlCacheDependency>
</caching>
</system.web>

定义依赖

SqlCacheDependency dep = new SqlCacheDependency("KM_ERP", "km_menu");

使用

CacheData.SetCacheData("SystemMenuData", Result, dep);