I’m using LBLGenPro v2.6 RC
I’m having some difficulty getting my project off the ground, and I’m hoping I can get a swift kick to the head to knock some rocks loose. I’m building an application that manages data about my environment. This data is organized into an unstructured hierarchy (meaning the nodes do not follow a particular pattern), it follows a structure similar to a file system hierarchy. What I have done for the data model is created a supertype Item and several subtypes for the different objects which can exist in the hierarchy.
Item
Id (PK)
ParentId (FK - Item.Id)
Environment
EnvironmentId (PK) (FK - Item.Id)
Server
ServerId (PK) (FK - Item.Id)
Using the LLBLGen designer I created the supertype as an abstract class and created the TargetPerEntity hierarchy. What I can't seem to figure out is how to fetch a collection of the subtype objects by querying the supertype. I want to be able to fill a collection of subtypes that have the same parent Id. This all leads to an on-demand TreeView where I am extending TreeNode to contain my LLBLGen driven BL objects. I've tried to get the fetches going using both the new Linq syntax and standard LLBLGen 2.0 method of performing this fetch and I'm just spinning my wheels at this point. Any help would extraordinarily appreciated. I would also value any suggestions on changing the overall design. I'm at the point where I'm not seeing much else through the trees regardless of how simple it may be.
Thanks,
Joseph