Ok fellows. I've tried EVERYTHING!!
System
OS: Windows Vista SP2
IIS: version 7
MSSQL: 2008 express
ASPX: .NET 3.5 framework
my global.asax has sqlcachedependency.start and stop at application start and end
i have enabled sqlnotifications on the database.
The database has a table for tracking the changes and the track counter increments correctly with each add/edit/delete to the table.
On the asp.net side i have this simple page
<%@ Page Language="VB" CodeFile="SizeTest.aspx.vb" Inherits="SizeTest" %>
<%@ OutputCache Duration="50000" VaryByParam="None" SqlDependency="MyDay:SitePages" %>
<html>
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" DataKeyNames="SitePageID" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyDay%>"
ProviderName="<%$ ConnectionStrings:MyDay.providername %>" SelectCommand="SELECT SitePageID, PageName FROM SitePages" />
</div>
</form>
</body>
</html>
Where "MyDay" is the name of my db as well as the name of the connectionstring in the web.config
here is my web.config parts
<caching>
<sqlCacheDependency enabled="true">
<databases>
<add name="MyDay" connectionStringName="MyDay" />
</databases>
</sqlCacheDependency>
</caching>
Now, all this does not help get my aspx page invalidate on data change
the procedures and broker stuff all get created on app start. but the data remains stale
i granted notification permissions to any user i could think of (at least i believe i have). i would note that i did not find in my sytem any type of user/login called aspnet or the like, if that means anything.
i tried changing my connectionstring from a windows integrate login to a sql server login with u&p. still stale data.
i read tens of articles, i also added a masterkey to the db. really idid every step i could find. nothing helps!
im feeling desperate here.
can anyone help out?
thanks to all!