SQL Statement In to SQL

[=?Utf-8?B?QmFmZmxlZA==?=]

Hi All,

How would I convert the SQL IN statement to LinQ

Select *
from TableName
where FieldName in (Value1, Value2)

or

Select *
from Table1
where Field1 in (Select Field1 from Table2)

Thanks

[Alberto Poblacion]

"Baffled" <Ba*****@discussions.microsoft.comwrote in message
news:CB**********************************@microsof t.com...

How would I convert the SQL IN statement to LinQ

Select *
from TableName
where FieldName in (Value1, Value2)

or

Select *
from Table1
where Field1 in (Select Field1 from Table2)

As to the second one, it can be refactored into a Join:

Select Table1.* from Table1 Join Table2 on Table1.Field1=Table2.Field1

This can then be readily converted into a LINQ query with a Join.