linq_flatten_to_hierarchies | C# Online Compiler

linq_flatten_to_hierarchies by Revious

using System.Collections.Generic;
using System.Linq;

public class MacroTab
{
    public MacroTab()
    {
        Tabs = new List<Tab>();
    }

    public int IDMacroTab { get; set; }
    public List<Tab> Tabs { get; set; }
    public object HelperClass { get; set; }
}

public class Tab
{
    public Tab()
    {
        Slots = new List<Slot>();
    }

    public int IDTab { get; set; }
    public List<Slot> Slots { get; set; }
    public object HelperClass { get; set; }
}


public class Slot
{
    public int IDSlot { get; set; }
    public object HelperClass { get; set; }
}



public class Program
{
    public static void Main()
    {
        List<MacroTab> hierarchaldata = CreateHierarchaldata();

        //Flatten
        var flattenedList = (from macroTab in hierarchaldata
            from tab in macroTab.Tabs
            from slot in tab.Slots
            select new {macroTab.IDMacroTab, tab.IDTab, slot.IDSlot}).ToList();

        //Antiflatten
        var antiflatten = from macrotab in flattenedList
            group macrotab by new {macrotab.IDMacroTab}
            into macrotabs
            let macrotabFirst = macrotabs.First()
            select new MacroTab
            {
                IDMacroTab = macrotabFirst.IDMacroTab,
                Tabs = (from macrotab in macrotabs
                    group macrotabs by new {macrotab.IDTab}
                    into tabs
                    let tabFirst = tabs.First()
                    select new Tab(){ HelperClass = tabFirst}).ToList()
            };

        ;
    }

    private static List<MacroTab> CreateHierarchaldata()
    {
        List<MacroTab> p = new List<MacroTab>()
        {
            new MacroTab
            {
                IDMacroTab = 1,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
            new MacroTab
            {
                IDMacroTab = 2,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
            new MacroTab
            {
                IDMacroTab = 3,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
        };
        return p;
    }
}

​x
 
using System.Collections.Generic;
using System.Linq;
​
public class MacroTab
{
    public MacroTab()
    {
        Tabs = new List<Tab>();
    }
​
    public int IDMacroTab { get; set; }
    public List<Tab> Tabs { get; set; }
    public object HelperClass { get; set; }
}
​
public class Tab
{
    public Tab()
    {
        Slots = new List<Slot>();
    }
​
    public int IDTab { get; set; }
    public List<Slot> Slots { get; set; }
    public object HelperClass { get; set; }
}
​
​
public class Slot
{
    public int IDSlot { get; set; }
    public object HelperClass { get; set; }
}
​
​
​
public class Program
{
    public static void Main()
    {
        List<MacroTab> hierarchaldata = CreateHierarchaldata();
​
        //Flatten
        var flattenedList = (from macroTab in hierarchaldata
            from tab in macroTab.Tabs
            from slot in tab.Slots
            select new {macroTab.IDMacroTab, tab.IDTab, slot.IDSlot}).ToList();
​
        //Antiflatten
        var antiflatten = from macrotab in flattenedList
            group macrotab by new {macrotab.IDMacroTab}
            into macrotabs
            let macrotabFirst = macrotabs.First()
            select new MacroTab
            {
                IDMacroTab = macrotabFirst.IDMacroTab,
                Tabs = (from macrotab in macrotabs
                    group macrotabs by new {macrotab.IDTab}
                    into tabs
                    let tabFirst = tabs.First()
                    select new Tab(){ HelperClass = tabFirst}).ToList()
            };
​
        ;
    }
​
    private static List<MacroTab> CreateHierarchaldata()
    {
        List<MacroTab> p = new List<MacroTab>()
        {
            new MacroTab
            {
                IDMacroTab = 1,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
            new MacroTab
            {
                IDMacroTab = 2,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
            new MacroTab
            {
                IDMacroTab = 3,
                Tabs = new List<Tab>
                {
                    new Tab
                    {
                        IDTab = 1,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2}
                        }
                    },
                    new Tab
                    {
                        IDTab = 2,
                        Slots = new List<Slot>()
                        {
                            new Slot {IDSlot = 1},
                            new Slot {IDSlot = 2},
                            new Slot {IDSlot = 3},
                        }
                    },
                    new Tab {IDTab = 3}
                }
            },
        };
        return p;
    }
}

Cached Result
Last Run:	10:09:16 am
Compile:	0.137s
Execute:	0s
Memory:	0b
CPU:	0s

View IL Code