SQL server service broker usage with ASP.net cache? -


i have asp.net site (4.5) uses sql cache notification. (using aspnet_regsql.exe)

the idea sql server tables stored in app's cache .this - not load data on , on again specific table.

the beauty asp.net's cache can automatically remove table cache (and load again - optionally) when data modified on table.

it done via web.config :

 <system.web>       <caching>          <sqlcachedependency enabled="true">             <databases>                <add name="northwind" connectionstringname="appconnectionstring1"                  polltime="500" />             </databases>          </sqlcachedependency>       </caching>  </system.web> 

but way works polling main sql cache notification table (which holds table names , counters)

question:

i know service broker can used instead . how mechanism different opposed polling? mean - when table changed - there trigger updates main table how asp.net knows counter (which represent change) has been increased ? asp.net still polls ?


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -