Multilevel hiearchical prefetch

Posts   
 
    
bunzee
User
Posts: 84
Joined: 20-Mar-2007
# Posted on: 18-Mar-2010 22:28:45   

llblgen 2.6 dotnet 3.5 adapter model

Hi

I have a table called Permission that reference to itself to model a tree of permissions.

Permission.Id 1:m Permission.ParentId

I would like to use prefetch so that when I fetch a permission it will fetch all of its descendant permissions. Is this possible?

Thanks.

BZ

bunzee
User
Posts: 84
Joined: 20-Mar-2007
# Posted on: 18-Mar-2010 23:40:07