Hi,
I'm trying to implement syscache2 in my demo application. I've used the table-based dependency n it works fine. Now I'm trying to implement command-based dependency in my application. this is what I'm doing in my web.config.
<syscache2>
<cacheRegion name="CacheRegionForSysCache2">
<dependencies>
<commands>
<add name="SubjectTableQuery"
command="Select Id, Subject , Duration from dbo.tbl_Subject"/>
</commands>
</dependencies>
</cacheRegion>
</syscache2>

I started the service-broker listener in my app n enabled the service-broker in the database as well. it works fine untill i cache one business entity only. In case of when i cache other entities my all the cache is expired where it should only expire the command results.

Can any one help me out plz.