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 Query