I have a dnn 7 dal 2 module and I need to have the cache reset for a chacheable object that is based on a Sql DB View when one of the underlying tables is updated.
For example, the view is based on table/petapoco object Table1 and Table2 where Table1 and Table2 are in a one to many relationship. Table2 is the many side.
Then I have a view named vw_TableDetails.
When I use the Dal 2 repository to add an item to Table2 the cache for Table2 gets cleared, but not the view.
Here is how I declared my view
<TableName("vw_TableDetails")> _<PrimaryKey("TableId", AutoIncrement:=False)> _
<Cacheable("TableDetails", CacheItemPriority.Default, 20)> _
Public Class vw_TableDetails
Public Properties Go Here...
Also, the CacheItemPriority is set to 20, but after 20 minutes the cache is not getting cleared for that object.
1. Am I understanding the CacheItemPriority incorrectly?
2. Is there a way to clear the cache manually for an object based on a SQL view?
Thanks in advance