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.
Continue reading…