Ok fellows. I've tried EVERYTHING!!
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!