LINQ in C# - Being Lazy with Mapping, Reducing, and Filtering

Have you been using LINQ in C#? You've probably come across using LINQ but perhaps didn't understand some of the use cases for it, such as mapping, filtering...