1.缓存依赖
- System.Web.Caching.SqlCacheDependencyAdmin.EnableTableForNotifications(System.Configuration.ConfigurationManager.ConnectionStrings["SQLConnString1"].ConnectionString, "T_USER");
- AggregateCacheDependency dependency = new AggregateCacheDependency();
- dependency.Add(new SqlCacheDependency("RTU", "T_USER"));
2.webconfig
- <connectionStrings>
- <add name="SQLConnString1" connectionString="server=(local);database=RTU;uid=sa;pwd=5197313" providerName="System.Data.SqlClient"/>
- </connectionStrings>
- <sqlCacheDependency enabled="true">
- <databases>
- <add name="RTU" connectionStringName="SQLConnString1" pollTime="60000" />
- </databases>
- </sqlCacheDependency>
3.数据源设置
- <asp:SqlDataSource ID="SqlDataSource1" runat="server"
- ConnectionString="<%$ ConnectionStrings:SQLConnString1 %>" EnableCaching="True"
- SelectCommand="SELECT a.[WMeterID],b.[UserName] FROM [T_WMETER] a,[T_USER] b where a.[UserID] = b.[UserID]"
- SqlCacheDependency="RTU:T_WMeter;RTU:T_USER"></asp:SqlDataSource>