Is there any way to use multiple OR where clauses in a Linq to Entities query?
Suppose I have a table in the database
TABLE
Key1 INT,
Key2 INT,
...
and in code I have a
List<KeyValuePair<int, int>>
where I want to get all value from table that match the items in my list.
Is there any way I can do that.
Contains doesn't work because it doesn't seem to work on non-primitive types.
Any ideas?
Thanks, Eric