SqlCacheDependency Strongly Typed Dataset

[chris]

Hello all,

Background: Using .NET 2.0, Sql Server 2005, SqlCacheDependency is
utilized successfully against SqlCommand objects elsewhere in the code
(in other words I have successful instances of using
SqlCacheDependency). ASP.NET website built in 3 separate tiers:
Presentation, Business Logic Layer (BLL), and Data Access Layer (DAL).

I have a strongly typed data set that is utilized by my BLL and returns
the strongly typed data table to the ObjectDataSource that consumes it.
This works fine. Now I want to tie the SqlCacheDependency dependency
to this data set so that if the underlying data changes, it will
invalidate my cache, thus causing the data set to refresh.

How do you do this? I see the SqlCacheDependency object has two
constructors: one for SqlCommand (I use this elsewhere successfully),
and one for the string representation of the database and table to be
notified of when it changes (this will not do, it is not granular
enough).

Any ideas are greatly appreciated.

Regards,
Chris

 

[chris]

I am thinking this may be the wrong group. I will put this post on the
aspnet group to see if I get any more responses.

Thanks,
Chris