score:2

Accepted answer

Assuming that myList is a List<string>, you can try something like this:

var query = from r in d.AsEnumerable()
            where myList.Any(r.Field<string>("Column7").Contains)
            select r;

Or, if myList is a List<int>, you might want to modify your Database column to also have type int, and you can do the following:

var query = from r in d.AsEnumerable()
            where myList.Contains(r.Field<int>("Column7"))
            select r;

Related Articles