Linq Select in

[Robert Bravery]

Hi all,

Using studio 2008
Vista
MSSQL 2005

I am wanting to achive something like:
select * from mytable where mycolumn in (1,2,3)

How does one perform a select in, with linq

Thanks
Robert

[Jon Skeet [C# MVP]]

Robert Bravery <[e-mail]:

Using studio 2008
Vista
MSSQL 2005

I am wanting to achive something like:
select * from mytable where mycolumn in (1,2,3)

How does one perform a select in, with linq

Try Contains:

int[] options = {1, 2, 3};

var query = from row in mytable
where options.Contains(row.MyColumn)
select row;

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
World class .NET training in the UK: http://iterativetraining.co.uk

[Robert Bravery]

Thanks jon, that helped a lot. It worked

Robert

"Jon Skeet [C# MVP]" <sk***@pobox.comwrote in message
news:MP*********************@msnews.microsoft.com. ..

Robert Bravery <[e-mail]:

>Using studio 2008
Vista
MSSQL 2005

I am wanting to achive something like:
select * from mytable where mycolumn in (1,2,3)

How does one perform a select in, with linq

Try Contains:

int[] options = {1, 2, 3};

var query = from row in mytable
where options.Contains(row.MyColumn)
select row;

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
World class .NET training in the UK: http://iterativetraining.co.uk