Where IN Clause in Entity Framework Core

Question

I want to convert this SQL query to an Entity Framework Core 2.0 query.

SELECT * FROM Product WHERE ProdID IN (1,2,3);

ProdID column is of bigint type and contains only works with string columns — Kumudini Porwal
– Kumudini Porwal, Commented Aug 31, 2018 at 7:32
A question about Entity Framework Core 2.0 in 2018 is not a duplicate of a LINQ to Entities question from 2009. — Mark Rendle
– Mark Rendle, Commented Feb 23, 2019 at 13:55
@MarkRendle I suppose you're right...however the technique still applies. The underlying IQueryable implementation is what's different between various Linq-to-something technologies...making usage (fairly) consistent across the board. Folks unfamiliar with the history of Linq may not realize this. — Clay
– Clay, Commented Feb 23, 2019 at 17:43
@KumudiniPorwal, Contains in Linq is a generic function taking a lambda as an argument...and can be of any type as inferred by the lambda itself. — Clay
– Clay, Commented Feb 23, 2019 at 17:46
@Clay sure but the linked answer is not what you would do using Marten, or NHibernate, or RavenDB. We shouldn't be linking EF Core to EF or Linq2Sql. — Phill
– Phill, Commented Feb 24, 2019 at 7:18

Mark Rendle · Accepted Answer · 2019-04-24 11:34:48Z

As per the comments on the question, the way you do this in EF Core is the same as for LINQ-to-SQL: use the Enumerable.Contains extension method on an array in your Where expression.

public async Task<List<Product>> GetProducts(params int[] ids) { return await context.Products .Where(p => ids.Contains(p.ProdID)) // Enumerable.Contains extension method .ToListAsync(); }

See related LINQ to Entities question

In my case ProdID is nullable, which means I get a compilation error stating int[] doesn't contain a method Contains that accepts a nullable int. What's the best way to do this in my case? Use p.ProdID.Value?

Collectives™ on Stack Overflow

Where IN Clause in Entity Framework Core

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related