using XXX.DAL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Caching;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace XXX.WebApp
{
public partial class SqlCacheDep : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Cache["customerList"] == null)
{
SqlCacheDependency cDep = new SqlCacheDependency("GSSMS", "数据表名");
string sql = "select * from 数据表名";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text); //DataTable da = ......;
Cache.Insert("customerList", da, cDep); //数据库依赖绑定到Cache中。
Response.Write("数据来自数据库");
}
else
{
Response.Write("数据来自缓存");
}
}
}
}
Web.config配置:
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.5" />
<httpRuntime targetFramework="4.5" />
<!--缓存依赖项配置-->
<caching>
<sqlCacheDependency enabled="true">
<databases>
<add name="GSSMS" connectionStringName="connStr" pollTime="15000"/>
</databases>
</sqlCacheDependency>
</caching>
</system.web>
<connectionStrings>
<add name="connStr" connectionString="server=.;uid=home;pwd=;database=EFFristModel" />
<add name="EFFristModelConnectionString" connectionString="Data Source=.;Initial Catalog=EFFristModel;User ID=home"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>