gistfile1.txt

$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.commandtext = $query
$conn.open()
#Creates sql command
if ($conn.Open())
{
    Write-Host "connection established..."
}
$cmd.connection = $conn

#$cmd.executenonquery()
$queryResult = $cmd.ExecuteReader()
$conn.close()