Share via


SqlHierarchyId.GetReparentedValue Method

Gets a value representing the location of a new SqlHierarchyId node that has a path from newRoot equal to the path from oldRoot to this, effectively moving this to the new location.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

'Declaration
<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None,  _
    InvokeIfReceiverIsNull := False, OnNullCall := False,  _
    IsDeterministic := True, IsPrecise := True, IsMutator := False)> _
Public Function GetReparentedValue ( _
    oldRoot As SqlHierarchyId, _
    newRoot As SqlHierarchyId _
) As SqlHierarchyId
'Usage
Dim instance As SqlHierarchyId
Dim oldRoot As SqlHierarchyId
Dim newRoot As SqlHierarchyId
Dim returnValue As SqlHierarchyId

returnValue = instance.GetReparentedValue(oldRoot, _
    newRoot)
[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public SqlHierarchyId GetReparentedValue(
    SqlHierarchyId oldRoot,
    SqlHierarchyId newRoot
)
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
SqlHierarchyId GetReparentedValue(
    SqlHierarchyId oldRoot, 
    SqlHierarchyId newRoot
)
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
member GetReparentedValue : 
        oldRoot:SqlHierarchyId * 
        newRoot:SqlHierarchyId -> SqlHierarchyId
public function GetReparentedValue(
    oldRoot : SqlHierarchyId, 
    newRoot : SqlHierarchyId
) : SqlHierarchyId

Parameters

Return Value

Type: Microsoft.SqlServer.Types.SqlHierarchyId
A SqlHierarchyId node representing the new hierarchical location of this. Will return nulla null reference (Nothing in Visual Basic) if oldRoot, newRoot, or thisare nulla null reference (Nothing in Visual Basic).

Remarks

Returns a node whose path from the root is the path to newRoot, followed by the path from oldRoot to this.

The SqlHierarchyId data type represents but does not enforce the hierarchical structure. Users must ensure that the SqlHierarchyId node is appropriately structured for the new location.

See Also

Reference

SqlHierarchyId Structure

Microsoft.SqlServer.Types Namespace