LINQ

“where x in”-SQL query with LINQ

Posted on 6. January 2020 by Marco Development 0

Writing SQL queries for an “in” selection can be tedious for lists in .NET… but it does not have to be!

We switch off: List<CarType> largeTypeList

into: SELECT * FROM CARS WHERE type in ('Audi', 'Ford', 'BMW', 'Nissan', ...)

Thanks to LINQ, you can easily turn a list into an “in” query.