Women in Technology

Hear us Roar



Article:
  Using SQL Cache Dependency
Subject:   Notify windows service when Sql table changed???
Date:   2006-09-16 02:43:23
From:   maulikCE
Nice, Article. I liked the idea of writing to text file and setting cache dependency on that file in aspnet.


Any idea about notifying Windows service when table in sql server chagnes or any suggestions on designing DB polling?


Thanks for anticipation.


Regards,
Maulik.

Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Notify windows service when Sql table changed???
    2010-01-13 07:56:31  KarahaNa [View]

    Hi
    did you find a solution to notify the windows service when dependency changed?

    <system.web>
    <caching>
    <sqlCacheDependency enabled="true" pollTime="12000" >
    <databases>
    <add name="testDB" connectionStringName="ConTest" /> </databases>
    </sqlCacheDependency>
    </caching>
    </system.web>

    the above setting work to notify the iis working process, but how to notify a windows service?