Invoke SQL queries the old way

InvokeSqlQuery-Legacy.ps1

# This is the old way I used to invoke sql queries. 
# A better way now would be to use the SqlServer module and Invoke-SqlCommand
$tsqlQuery = @"
Select AccountName
From SUSDB.dbo.tbDownstreamServerTarget
"@
Try {
   $conn.Open()
}
Catch  {
   $PSCmdlt.ThrowTerminatingError($_)
}

$command = $conn.CreateCommand()
$command.CommandText = $tsqlQuery
$table = new-object System.Data.DataTable
$data = $command.ExecuteReader()
$table.load($data)

$conn.Close()
$conn.Dispose()