WHERE IN

Performing a WHERE IN with Entity Framework or on a List

WHERE IN is a very useful and commonly used feature of SQL, it looks like this - SELECT * FROM ORDER WHERE OrderId IN (10248, 10249, 10250, 10251) The will return up to four rows of data, showing just the orders that have an OrderId in the list you passed to the select statement.

Feb 9, 2018 # Entity Framework Core, SQL, WHERE IN

Parameterized SQL WHERE IN clause C#

If you are using some legacy SQL in C# you’ll occasionally need to write a WHERE IN. You don’t want to end up writing something like the below, either directly or through some sort of loop.

Jan 28, 2016 # Extension Method, Parameters, SQL, WHERE IN, C#