Using Hierarchies with HierarchyID

Posts   
 
    
SanderF
User
Posts: 125
Joined: 11-Dec-2006
# Posted on: 11-Sep-2014 12:04:06   

Hi,

Does LLBLGen Pro supports the HierarchyID of SQL Server 2008 (and higher), in terms of predicate-expressions? Now we are using ParentID's which references to the PK of the same table to support hierarchies (via LLBLGen Pro). We are looking for a (maybe) simpler solution and find the HierarchyID of SQL Server.

I've read serveral articles but in the support form and help files of LLBLGenPro there is (nearly) no information. I've seen that the datatype in the LLBLGenPro designer is a string.

Can you give me please more information about the combination LLBLGenPro and the HierarchyID in SQL Server?

Beste regards, Sander Fickweiler.

Walaa avatar
Walaa
Support Team
Posts: 14994
Joined: 21-Aug-2005
# Posted on: 11-Sep-2014 17:35:38   

No support for the HierarchyID for the reason explained here: https://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14060