CODEWITHSUNDEEP
sqllinq
Ye Peng
Ye Peng

Reputation: 183

How to implement Linq Where In query with an array

Can we build a Linq where clause really like SQL In? Like:

int[] ids = { 1, 2, 3, 4, 5};    
var query = from item in db.myTable
            where item.ID In ids
            select item;

I know we can use a Contains keyword like below but I want to split the where clause without that local array ids so that I can save the where clause in a table to reuse it. I will save the real data { 1, 2, 3, 4, 5} in DB but not a local variable.

int[] ids = { 1, 2, 3, 4, 5};    
var query = from item in db.myTable
            where ids.Contains(item.ID)
            select item;

Upvotes: 0

Views: 726

Answers (1)

StriplingWarrior
StriplingWarrior

Reputation: 156469

The query should follow a similar pattern, you'll just pull the values from the other table instead of having them in an array.

var ids = db.someTable.Where(...).Select(e => e.ID);
var query = from item in db.myTable
        where ids.Contains(item.ID)
        select item;

Upvotes: 1

Related Questions