Jan Doubek
My Dev Tricks

My Dev Tricks

Follow
homeLINQ gemsAboutContact
Series

LINQ gems

In this series, I will show you my favorite LINQ tricks.

Articles in this series

ToLookup or not ToLookup, that is the question!

May 30, 20214 min read

Shakespeare will hopefully forgive me for abusing a line from his famous Hamlet. In my post, I won't be covering questions of life and death, but...

ToLookup or not ToLookup, that is the question!

LINQ gems: Troubles with Out Parameters

Mar 25, 20218 min read

How do you deal with out parameters inside of LINQ queries? Almost every time I come across the need to invoke a method inside of a LINQ query, which...

LINQ gems: Troubles with Out Parameters

LINQ gems: Left Outer Join

Nov 12, 202010 min read

Doing a left outer join in T-SQL is as straightforward as adding a single keyword to the JOIN statement. I remember that when I first tried to perform...

LINQ gems: Left Outer Join

LINQ gems: Indexed Select

Oct 28, 20204 min read

Here's another LINQ gem, which is very useful if you plan to base your projection or filtering logic on the element's index in a sequence. From the...

LINQ gems: Indexed Select

LINQ gems: Zip

Oct 20, 20202 min read

I'm always fascinated by how simple yet helpful LINQ queries are. Take for example the Enumerable.Zip() method. It's simple, yet very useful in case...

LINQ gems: Zip