v2.7.0

SqlHydra.Cli v2.7.0

😺 SQL Server generation now supports HierarchyId column type. (Thanks to @michelbieleveld for contributing this feature!)

SqlHydra.Query v2.7.0

😺 Add new areEqual and notEqual query functions to support querying against the HierarchyId column type.
It is necessary to use these functions since the HierarchyId type overloads the = operator to return a SqlBoolean instead of a bool, which breaks the query syntax.

Usage example:

    let node = child.GetAncestor(1)

    let! result = 
        selectTask ctx { 
            for row in ext.HierarchyIdSupport do
            where (row.Id = id_parent && areEqual row.Hierarchy node)
            select row.Hierarchy
            toList
        }