Caching stored procedure results in Linq'u

Posted by itdebeloper on Stack Overflow See other posts from Stack Overflow or by itdebeloper
Published on 2010-05-22T14:38:22Z Indexed on 2010/05/22 14:40 UTC
Read the original article Hit count: 212

In our web application we have a lots of stored procedures look like this one:

getSomeData(/* 7 diffrent params */)

This stored procedure don't make any updates. We are using Linq'u.

I know that the date are changing no often than once per day so the results for the same sets of parameters values will be the same.

Does Linqu have cache simple solution?

I know how to 'manually' write cache mechanism in .net, but I supposed that in Linqu this problem was solved.

I'm a lazy guy :) so I'm looking for something realy simple like:

Linqu_global_store_procedure_configuration.CacheDuration="600"
Linqu_global_store_procedure_configuration.CacheVaryByParam="*"

I'm using .net 3.5 but its not any problem to move for 4.0.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about LINQ