Multiple tables in ountputcache attribute sqldependency mvc

Question

I am using outputcache sqldependency and it works absolutely fine, but now I want to depend on multiple tables.

[OutputCache(Duration = 600, SqlDependency = "db:table1")]

My question: Is sqldependency support relying on multiple tables? if yes, then what is the syntax?

I tried the following syntax, but it did not work, it considers this table1,table2 as a name for one table.

[OutputCache(Duration = 600, SqlDependency = "db:table1,table2")]

Thanks in advance.

Piotr Czarnecki · Accepted Answer · 2015-07-03 08:28:55Z

3

Let's try:

SqlDependency = "[database]:[table1];[database]:[table2]"

answered Jul 3, 2015 at 8:28

Piotr Czarnecki

1,6983 gold badges14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Golda Over a year ago

@Piotr Czarnecki, Hi, I have tried the same thing what you have explained. For first table change it works perfectly but for table2 its not working properly. It access the action after 5 to 6 times to page refresh.

Golda Over a year ago

@Piotr Czarnecki, I have found the issue its due to the "pollTime" in webConfig. I have reduce the values so its works fine

Collectives™ on Stack Overflow

Multiple tables in ountputcache attribute sqldependency mvc

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related