Using SQL Cache Dependencies : SQL Cache Dependencies « Cache « ASP.NET Tutorial

1. ASP.NET Tutorial
2. Cache
3. SQL Cache Dependencies

File: Web.Config

<configuration>
  <connectionStrings>
    <add name="Products" connectionString="Data Source=.\SQLEXPRESS;
      AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;
User Instance=True" />
  </connectionStrings>

  <system.web>
    <caching>
      <sqlCacheDependency enabled="true" pollTime="5000">
        <databases>
          <add
            name="MyDatabase"
            connectionStringName="Products" />
        </databases>
      </sqlCacheDependency>
    </caching>
  </system.web>
</configuration>