ASP.NET MVC <OutputCache> SqlDependency (CommandNotification?) with LINQ queries
- by sinni800
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...