New-DataTable

New-DataTable.ps1

function New-DataTable {
    <#
        .SYNOPSIS
            Create a new DataTable.
        .DESCRIPTION
            Create a new DataTable.
        .EXAMPLE
            `
            $myColumns = [ordered] @{
                ID = [int32]
                Name = [string]
                Age = [int]
                Date = [DateTime]
            }

            $myTable = New-DataTable -TableName 'MyTable' -Columns $myColumns
        .NOTES
            Author: Øyvind Kallstad
            Date: 20.10.2014
            Version: 1.0
    #>
    [CmdletBinding()]
    [OutputType([System.Data.DataTable])]
    param (
        [parameter()]
        [string] $TableName,

        # Use an ordered dictionary to define the table columns.
        [parameter()]
        [System.Collections.Specialized.OrderedDictionary] $Columns
    )

    # create new datatable
    $newDataTable = New-Object -TypeName  'System.Data.DataTable' -ArgumentList $TableName
    Write-Verbose "DataTable created '$TableName'"
    
    # create columns
    if ($PSBoundParameters['Columns']) {
        $Columns.GetEnumerator() | ForEach-Object {
            $columnName = $_.Key
            $columnType = $_.Value.ToString()
            $dataColumn = New-Object -TypeName 'System.Data.DataColumn' -ArgumentList ($columnName,$columnType)
            $newDataTable.Columns.Add($dataColumn)
            Write-Verbose "New column created '$columnName'"
        }
    }

    Write-Output @(,$newDataTable)
}