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