数据表里update delete ,Cache不会重新装载啊,大家帮忙看看是哪里的问题,程序执行没有报错 <connectionStrings>
<add name="Xindeco.EService"
connectionString="Data Source=192.168.2.218;Initial Catalog=EService;User Id=sa;Password=12345;"
providerName="System.Data.SqlClient" />
</connectionStrings> <caching>
<sqlCacheDependency enabled = "true" pollTime = "60000" >
<databases>
<add name="EService"
connectionStringName = "Xindeco.EService"
pollTime = "9000000"
/>
</databases>
</sqlCacheDependency>
</caching> SqlCacheDependencyAdmin.EnableNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString);
SqlCacheDependencyAdmin.EnableTableForNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString, "Sys_RoleGroup");HttpContext.Current.Cache.Insert(GlobalName.SysRoleGroup,roleGroups,new SqlCacheDependency("EService", "Sys_RoleGroup"));
<add name="Xindeco.EService"
connectionString="Data Source=192.168.2.218;Initial Catalog=EService;User Id=sa;Password=12345;"
providerName="System.Data.SqlClient" />
</connectionStrings> <caching>
<sqlCacheDependency enabled = "true" pollTime = "60000" >
<databases>
<add name="EService"
connectionStringName = "Xindeco.EService"
pollTime = "9000000"
/>
</databases>
</sqlCacheDependency>
</caching> SqlCacheDependencyAdmin.EnableNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString);
SqlCacheDependencyAdmin.EnableTableForNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString, "Sys_RoleGroup");HttpContext.Current.Cache.Insert(GlobalName.SysRoleGroup,roleGroups,new SqlCacheDependency("EService", "Sys_RoleGroup"));
解决方案 »
- SqlDataSource控件怎么获取不到存储过程输出参数的值
- asp.net 怎么获取页面关闭事件啊? 我想在关闭页面时 删除临时表
- 我什么我打印每次都全部打印呢?printDialog1控件设置了打印页啊
- 用jquery ajax 传递 json数据,为什么sucess 不执行?谢谢。
- 一个系统要求有简繁日英几种版本,该如何设计?
- session问题?想了很长时间...
- 求一自定义dropdownlist控件解决方案
- ASP新手,问高手简单问题:背景图片如何保持静止?
- 困惑vss6.0c自动产生的vssver文件
- 请教string.format的问题
- treeview的节点,能不能有tip,就是鼠标移到上面,显示提示,没分了,对不起各位
- 江湖救急!!!!!!!
1) Enable notifications for the database using the aspnet_regsql.exe tool. >aspnet_regsql.exe -S ".\SQLExpress" -E -d "pubs" -ed
This only needs to be done once for each database.
2) Enable notifications for the table(s) you want to have dependencies on using the aspnet_regsql.exe tool. >aspnet_regsql.exe -S ".\SQLExpress" -E -d "pubs" -et -t "authors"
SqlCacheDependencyAdmin.EnableTableForNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString, "Sys_RoleGroup");也是同样的效果,现在有作用了,我改了polltime,改小了,才能立马见效果
SqlCacheDependencyAdmin.EnableTableForNotifications(ConfigurationManager.ConnectionStrings["Xindeco.EService"].ConnectionString, "Sys_RoleGroup");起了配置库和表的功能。
polltime太大,查询数据库看是否有改变的间隔时间太长,所以造成没起作用的假象