To get details of a person 'Adam' Sql query
SELECT * FROM tableName WHERE Name = 'Adam'
Linq query in Vb
From tableName In something Where row.Field(Of String)("name").Trim = "Adam"
But to get details of multiple people 'Adam', 'Chris' Sql query
SELECT * FROM tableName WHERE Name IN ('Adam', 'Chris')
Linq query in VB???
Edited: Linq query in VB is
From tableName In something Where {"Adam", "Chris"}.Contains(row.Field(Of String)("name").Trim)
Dim item= From tableName In something
where {"Adam", "Chris" }.Contains(u.something)
select i
Try this code