Caching stored procedure results in Linq'u
- by itdebeloper
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.
