Just Code‎ > ‎

Powershell - Example of using hashmaps as dynamic objects

posted Nov 11, 2011, 1:36 AM by Peter Henell   [ updated Jan 25, 2012, 5:27 AM ]
Will also serialize it to xml
$peter will be the new "dynamic" object. Which is really a hash table where you can access the Value by using the .Key syntax
It will infer the datatype of the different properties from the assigned value.
$con = New-Object System.Data.SqlClient.SqlConnection(
"Data Source=Localhost;Initial Catalog=CustomerDb;Integrated Security=SSPI;")
function ExecuteSingleRow([string]$sql)
{
    $cmd = New-Object System.Data.SqlClient.SqlCommand($sql, $con)
    $cmd.Connection.Open()

    $adapter = New-Object System.Data.SqlClient.SqlDataAdapter($cmd)
    $ds = New-Object System.Data.DataSet
    $null = $adapter.Fill($ds)
    $row = $ds.Tables[0].Rows[0]
    $cmd.Connection.Close()
    
    $row
}
$nbp = ExecuteSingleRow "Select * from Customer where CustomerId = 5"


$peter = @{}
$peter.CustomerId = $nbp.CustomerId
$peter.JoinDate = $nbp.JoinDate
($peter| ConvertTo-Xml).save("c:\temp\peter.txt")
Comments