Saturday, February 25, 2012

MS SQL 2005 caching dependancy....

Is it possible to build an MS sql 2005 caching dependancy stucture similar
to what is offered by the SqlCacheDependency class for use with non asp.net
applications using MS sql 2005 notification services and C# ?
Cheers
OllieNotification Services is something different from what you describe. You sho
uld read about "Query
Notifications" and the SqlDedendency object, which you can use from ADO.NET
2,0 but doesn't require
ASP in any form or shape.
In fact, to the best of my knowledge, SqlCacheDepenency uses in turn SqlDepe
ndency.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dave" <dave@.nospamnoemial.com> wrote in message news:eFlqCSY1GHA.4264@.TK2MSFTNGP05.phx.gbl.
.
> Is it possible to build an MS sql 2005 caching dependancy stucture similar
to what is offered by
> the SqlCacheDependency class for use with non asp.net applications using M
S sql 2005 notification
> services and C# ?
> Cheers
> Ollie
>

No comments:

Post a Comment