MSSQL缓存方法

1.缓存依赖

1. System.Web.Caching.SqlCacheDependencyAdmin.EnableTableForNotifications(System.Configuration.ConfigurationManager.ConnectionStrings["SQLConnString1"].ConnectionString, "T_USER");
2.            AggregateCacheDependency dependency = new AggregateCacheDependency();
3.            dependency.Add(new SqlCacheDependency("RTU", "T_USER"));

2.webconfig

1.   <connectionStrings>
2.     <add name="SQLConnString1" connectionString="server=(local);database=RTU;uid=sa;pwd=5197313" providerName="System.Data.SqlClient"/>
3.   </connectionStrings>
5.       <sqlCacheDependency enabled="true">
6.         <databases>
7.           <add name="RTU" connectionStringName="SQLConnString1" pollTime="60000" />
8.         </databases>
9.       </sqlCacheDependency>

3.数据源设置

 

1.   <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
2.             ConnectionString="<%$ ConnectionStrings:SQLConnString1 %>" EnableCaching="True" 
3.             SelectCommand="SELECT a.[WMeterID],b.[UserName] FROM [T_WMETER] a,[T_USER] b where a.[UserID] = b.[UserID]" 
4.             SqlCacheDependency="RTU:T_WMeter;RTU:T_USER"></asp:SqlDataSource>