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