ConvertFrom-DataRow.ps1

Latest commit

History

43 lines (38 loc) * 1.75 KB

.SYNOPSIS

Converts a DataRow object to a PSObject, Hashtable, or single value.

.INPUTS

System.Data.DataRow with fields to convert into an object with properties or

into a hash with key/value pairs.

.OUTPUTS

System.Management.Automation.PSObject

or System.Object[] if -AsValues is specified

or System.Collections.Specialized.OrderedDictionary if -AsDictionary is specified

.FUNCTIONALITY

Database

.EXAMPLE

Invoke-Sqlcmd "select top 3 ProductID, Name from Production.Product" -ServerInstance ServerName -Database AdventureWorks |ConvertFrom-DataRow.ps1 |ConvertTo-Html

#Requires -Version 3

[CmdletBinding(DefaultParameterSetName='AsObject')]

[OutputType([Management.Automation.PSCustomObject],ParameterSetName='AsObject')]

[OutputType([object[]],ParameterSetName='AsValues')]

[OutputType([Collections.Specialized.OrderedDictionary],ParameterSetName='AsDictionary')] Param(

# A record containing fields/columns to convert to an object with properties.

[Parameter(Position=0,Mandatory=$true,ValueFromPipeline=$true)][Data.DataRow]$DataRow,

# Indicates a the record's values should be returned as an array.

[Parameter(ParameterSetName='AsValues')][Alias('AsArray')][switch]$AsValues,

Indicates an ordered dictionary of fieldnames/columnnames to values should be returned

rather than an object with properties.

[Parameter(ParameterSetName='AsDictionary')][Alias('AsOrderedDictionary','AsHashtable')][switch]$AsDictionary

)

Process

{

if($AsValues) {return $DataRow.ItemArray}

$fields = [ordered]@{}

if($DataRow.Table -is [Data.DataTable]) {$DataRow.Table.Columns.ColumnName |ForEach-Object {[void]$fields.Add($_,$DataRow[$_])}}

if($AsDictionary) {return $fields}

elseif($fields.Count) {return [pscustomobject]$fields}

}

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

ConvertFrom-DataRow.ps1

Latest commit

History

ConvertFrom-DataRow.ps1

File metadata and controls

FilesExpand file tree

ConvertFrom-DataRow.ps1

Latest commit

History

ConvertFrom-DataRow.ps1

File metadata and controls