SQL

Mixing Raw SQL and Fluent Statements with Entity Framework

There are times when it is necessary to use handwritten SQL with Entity Framework Core. In this post I should how to do that, and to mix it with the usual fluent statements.

Jan 15, 2025 # Postgres, Entity Framework, SQL

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#