Functions/Data/Convert-DataRowToPSObject.ps1

Function Convert-DataRowToPSObject
    {
    [Cmdletbinding()]
    Param
        (
        # MSSQL Datarow to convert
        [Parameter(Mandatory=$true,ValueFromPipeline=$true)]
        [System.Data.Datarow]
        $MSSQLRow
        )
    
    Process
        {
        $HASH = [ordered]@{}
        foreach ($property in $MSSQLROW.psobject.Properties)
            {
            $HAsh.Add($property.name,$property.value)
            }
        [pscustomobject]($HASH)
        }
    }