Customer.text is a field in an T-SQL DB (that I do not control and thus may not alter) of type "text".

I'd like to do something like this:

List<string> compare = new List<string>();
compare.Add("one");
compare.Add("two");

var q = from t in customer
        where t.text.Contains( compare.First())
        select t;

this will work.

But now I'd like to do something like: (!NOT WORKING!)

var q = from t in customer
        where compare.Contains( t.text )
        select t;

How can I achieve this? Is it even possible?