How to customize output cache action filter where it's cache by sql query in mvc

134 Views Asked by At

Is there any way to cache data based on SQL query for table in mvc

i have tried following filter and it successfully cache list based on taskId but now when any row changes which contain this taskid need to fetch data from table.

(Duration = 300, VaryByParam = "taskId", SqlDependency="taskHistorySqlDependency:tblProjectTaskHistory")]

0

There are 0 best solutions below