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]]

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;

 

[Robert Bravery]

Thanks jon, that helped a lot. It worked

Robert

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;