ASP.NET MVC <OutputCache> SqlDependency (CommandNotification?) with LINQ queries

Posted by sinni800 on Stack Overflow See other posts from Stack Overflow or by sinni800
Published on 2010-05-04T14:15:32Z Indexed on 2010/05/04 14:18 UTC
Read the original article Hit count: 501

Hello,

I use LINQ queries in my ASP.NET MVC application and want to use OutputCache in some of my Actions.

I hear this should be possible with CommandNotifications. But those seem to only go for self-created SQLCommands, or am I wrong?

Can I manually tell SQL server to send SQLDependency notifications if certain tables change? And if yes, how can I attach them to the OutputCache?

Another side question: Can you do this with strongly types views too?

Thank you in advance...

© Stack Overflow or respective owner

Related posts about asp.net-mvc

Related posts about linq-to-sql