Linq version of SQL "IN" statement

given array of items:

var list = new int[] {2,3,4}

use:

where list.Contains(tm.TagId)

Something like

var TagIds = new int[] {12, 32, 42};

var q = from map in Context.TagMaps 
        where TagIds.Contains(map.TagId)
        select map.Items;

should do what you need. This will generate an In ( 12, 32, 42 ) clause (or more specifically a parameterized IN clause if I'm not mistaken).

Related