Gfw@yyyZ.Com (1) [Avatar] Offline
#1
Is there a command in Linq that convefrtes to tge TSQL IN function as in

WHERE Name IN ("Joe","John","Jane")
or
WHERE Name NOT IN ("Joe","John","Jane")
jwooley (123) [Avatar] Offline
#2
Re: SQL IN(##,##,##)
Use the Contains method in the where clause. I have a write-up at http://www.thinqlinq.com/Default.aspx?PostId=21985.

Jim
Telos (2) [Avatar] Offline
#3
Re: SQL IN(##,##,##)
I'm a little late, but is there a reason not to use Any() instead of contains?