Thank you for contacting us and I am sorry for the inconvenience you experience.
Indeed, the support for SqlHierarchyId of Telerik Data Access does not offer server side execution of the IsDescendentOf() extension method. To workaround this, you need to perform the filtering on the client side. In other words, you need to load all the records from the FolderInfo table in-memory and to build the IsDescendentOf() clause in a following statement. For example:
folderTreeId = 123;
var parentId = (from folder
where folder.FolderTreeID == folderTreeId
var allFolders = (from folder
var folders = (from f
where f.FolderHierarchyID.IsDescendantOf(parentId).Value ==
I hope this helps. Let us know, if you need further information.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map