Cache ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Cache
  4. SqlDependency=Northwind
<%@ Page Language="C#" AutoEventWireup="true"%>
<%@ OutputCache Duration="30" VaryByParam="none" SqlDependency="Northwind:Customers"%>

    protected void Page_Load(object sender, System.EventArgs e) 
    {
        Label1.Text = "Page created at " + DateTime.Now.ToShortTimeString();
    }



    Sql Cache Invalidation


    
        
        
        
        
                 SelectCommand="Select * From Customers"
         ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>" 
         ProviderName="<%$ ConnectionStrings:AppConnectionString1.providername %>">
        
    


File: Web.config