Pivot more than one collection on same parent?

Jul 23, 2014 at 2:58 PM
Is it possible to pivot multiple collections on the same parent object? If so, please post an example.

For instance, if I have a Contact class containing a Phone collection and an Address collection, is it possible to pivot both Phone and Address collections into a single object? The PivotTestPage in the LinqLibExamples project only seem to show one or the other - I have a scenario needing both and was curious if it was even possible.
-Eric
Coordinator
Aug 1, 2014 at 7:17 PM
The pivot feature only supports one collection.
It will be difficult to pivot more than one: using you example, if each contact has three phones, the transformed class will have three rows per unique contact. If there are also have three addresses what will multiple pivots do? Create 9 rows for all combinations or create 6 rows leaving nulls in half of each?