Hello,

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)> _
<Scope("PortalId")>
Public Class vw_TableDetails
Public Properties Go Here...
End Class

Also, the CacheItemPriority is set to 20, but after 20 minutes the cache is not getting cleared for that object.

2 QUESTIONS:

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

Jordan