get a dataset from a database

powershell get-dataset

function Get-DataSet($sqlCommand, $parameters, $connectionString) {
    $connection = new-object system.data.SqlClient.SQLConnection($connectionString)
    $command = new-object system.data.sqlclient.sqlcommand($sqlCommand,$connection)
    $dataset = New-Object System.Data.DataSet

    $parameters | Select-Object -ExpandProperty Keys | %{ 
        $command.Parameters.Add($_, $parameters[$_])
    }
    
    try{
        $connection.Open()
        $adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command
        $adapter.Fill($dataSet) | Out-Null
    }
    finally {
        $connection.Close()
    }
    return $dataSet
}