Click here to Skip to main content
16,021,112 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
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?
Posted
Updated 4-May-11 5:30am
v2

Just look the following links
Compiled Queries (LINQ to Entities)[^]
Linq Exchange[^]
C++

 
Share this answer
 
 
Share this answer
 
Hope this[^] might help you.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900