Debugging in LINQPad 

- Cases where Linq-to-Objects fails and Linq-to-Entities succeeds
- Cases where Linq-to-Objects succeeds and Linq-to-Entities fails
- Cases where both succeed/fail but behave differently

LINQ Extensions Library - Pivot Extensions

The pivot feature enables transforming a collection of objects into a new collection of objects flattening the original hierarchy

: In the following example The Pivot extension method is used to transform a collection as follow