Clause in with lambda

Question

Is it possible to have an IN clause with lambda Expression? Type:

context.tabela.Where(a => a.meu_campo_id_tipo_inteiro....)

let’s say one in like this: (2,3,4,5) As I put it in the dots?

Answer 1

More or less. The way to do it is like this:

var inteirosPraAchar = new List<int> {2, 3, 4, 5};
context.tabela.Where(a => inteirosPraAchar.Contains(a.meu_campo_id_tipo_inteiro));

Answer 2

An alternative to the method in the @Gypsy:

List<int> inteirosParaAchar = new List<int> { 1, 2, 3, 4 };
context.Where(i => inteirosParaAchar.Any(i1 => i1 == i));

For the reasons stated in this reply (concerning flexibility), the use of Any makes the comparison more flexible and can be extended to include more comparison elements.

Excerpt from the answer:

Finally, the . Any() due to the delegate, is more flexible than . Contains() which only accepts an object.