Search code examples
vb.netlinqwhere-in

Where Clause in LINQ with IN operator in Vb


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)


Solution

  • Dim item= From tableName In something
                   where {"Adam", "Chris" }.Contains(u.something)
                   select i
    

    Try this code