Using Polling SQL Cache Dependencies with Page Output Caching : SQL Cache Dependencies « Cache « ASP.NET Tutorial






  1. ASP.NET Tutorial
  2. Cache
  3. SQL Cache Dependencies
<%@ Page Language="C#" %>
<%@ OutputCache Duration="9999" VaryByParam="none"
  SqlDependency="MyDatabase:Products" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Polling SQL Output Cache</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <%= DateTime.Now.ToString("T") %>
    <hr />
    <asp:GridView
        id="grdProducts"
        DataSourceID="srcProducts"
        Runat="server" />

    <asp:SqlDataSource
        id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT Title, Director FROM Products"
        Runat="server" />

    </div>
    </form>
</body>
</html>








13.12.SQL Cache Dependencies
13.12.1.SqlDependency (C#)
13.12.2.SqlDependency (VB)
13.12.3.Using SQL Cache Dependencies
13.12.4.Using Polling SQL Cache Dependencies with Page Output Caching
13.12.5.Using Polling SQL Cache Dependencies with DataSource Caching
13.12.6.Using Polling SQL Cache Dependencies with Data Caching
13.12.7.SqlDependency="Northwind:Customers"
13.12.8.Using the Cache object with the SqlDependency object (C#)
13.12.9.Using the Cache object with the SqlDependency object (VB)