CompiledQuery using LINQ on Cached Data

See more:

.NET3.5

VS2008

C#

.NET

, +

I have a small (about 16 rows, 14 columns) static lookup table in an Oracle 10g database. I have cached the sorted data to a List object to avoid multiple trips to the database since I process thousands of requests on this data. I created a LINQ query object which works well but I still need to realize a better performance than what I'm getting.

I found some articles on compiled queries with LINQ and think it might be a solution to my performance issues since the query itself doesn't change, only the parameters to the WHERE clause. All of the examples I've found still reference a database context/structure.

Would someone show me how to create/use a compiled Linq query on an array/list?

I looked at that example. It's using a datacontext object. I need to use a list or array or find a way to create a data context out of a list or I'm totally missing something?