Linq to SQL Contains Method Throwing Unsupported Overload Exception

I have a List and each Filter object has a property called "Id". I want to fetch all the records from my database using Linq to SQ开发者_StackOverflow社区L that contains those ids. The List is not part of the database it is just an independent list.

not very clear question. however this is what, i suppose, u r trying to do

from c in datacontext.TableName where
IndependentList.Contains(c=>c.id)
select c