I'm trying to figure out how to best lay this out. I'll explain what I have now, but I'm wondering if there is a better way to do this.
I have a class Section that has basic properties: Name, Description, et.al. I use a list of Sections for the users to choose from. They can add a Section as many times as they want to a Parent object and any number of Sections.
When they add a Section to the parent, they have to assign what group it belongs to (lets say group1, group2, group3) and in what order it will be displayed. This Group property is not on the table, there is no group needed when I list out the Sections for the user to choose from, it wouldn't make sense. Think of this Section they are adding as a clone with extra properties.
I have another table that has a foreign key to the Parent and to the Section. Many sections can be added to 1 Parent. On this link table is also the Grouping and DisplayOrder columns (as well as a few others) for each section that they add.
So when I create the Parent object and query a collection of its Sections, do I want to try and use the same Section class and add a Grouping property?
Section 1
Section 2
Section 3
Parent 1
Section 1 - Group = g1, DisplayOrder = 1
Section 1 - Group = g2, DisplayOrder = 2
Section 2 - Group = g2, DisplayOrder = 3
Section 3 - Group = g3, DisplayOrder = 4
Parent 2
Section 4 - Group = g3, DisplayOrder = 1
Section 1 - Group = g2, DisplayOrder = 2
Section 2 - Group = g3, DisplayOrder = 3
Tell me if you have no idea what I'm saying and I'll try to explain it better...or I'll delete it and pretend like I never asked. =P