Just a thought but..
I am designing a product catalog site whilst learning Linq and it has just struct me that instead of writing lots of methods to retrieve products form the database in various forms I could write one data access method GetProducts, that retirved all products for the site and stored them in the cache and then just query agaisn't it using Linq. This would mean my database would get hit only when my cache expired. Now I know this all depends on how much data I am putting into the cache but does anyone see an obvious problem with this idea?
I was thinking along the lines of something like this...
Public Class ProductRepository
Private Go to the complete details ...