MVC3 中的缓存设置 基于SqlDependency 数据库MSSQLSERVER2008

web.config

 

<connectionStrings>
  <add name="dbConn" connectionString="" providerName="System.Data.SqlClient"/>
 </connectionStrings>

 

<system.web>

<caching>
        <sqlCacheDependency enabled="true" pollTime="60000">
          <databases>
            <add name = "CacheName" connectionStringName = "dbConn"/>
          </databases>
        </sqlCacheDependency>
      </caching>

</system.web>

name可以自定义,connectionStringName名称同connectionStrings的节点名相同.

pollTime间隔时间,毫秒.

 

[OutputCache(Duration = Int32.MaxValue, SqlDependency = "CacheName:表名;CacheName:表名", VaryByParam = "none")]

加在control方法头上.多表需要成对出现,以分号分隔.

 

执行起动命令

cd %windir%\Microsoft.NET\Framework\v4.0.30319\

aspnet_regsql.exe -S 服务器名 -ed -d 库名 -et -t 表名 -E

 

SQL查询功能

select is_broker_enabled from sys.databases where [name]='库名'

ALTER DATABASE 库名 SET ENABLE_BROKER
ALTER DATABASE 库名 SET ENABLE_sBROKER with rollback immediate