.NET

“where x in”-SQL query with LINQ

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…

Use task list in Visual Studio

Development environments, in short: IDE (Integrated Development Environment) often offer many useful tools, widgets, extensions, etc. in a sometimes unmanageable framework. If you just want to program quickly, you don’t necessarily need them, but for longer-term projects they make the work much easier.

One tool I would not like to miss is the Task List.

Continue reading…