Skip to content

Instantly share code, notes, and snippets.

@jdmonty
Created July 9, 2014 22:32
Show Gist options
  • Save jdmonty/82320d51dcf34c1210e7 to your computer and use it in GitHub Desktop.
Save jdmonty/82320d51dcf34c1210e7 to your computer and use it in GitHub Desktop.
# Executes an IDbCommand and converts the resultset
# to a Powershell object collection
function ExecuteCommand(
$command = { throw 'Command must be supplied' }
){
$rows = @();
$reader = $command.executereader()
while($reader.read()){
$values = new-object object;
for($i = 0; $i -lt $reader.FieldCount; $i++){
$name = $reader.GetName($i);
$value = $reader.GetValue($i);
Add-Member -in $values noteproperty $name $value
}
$rows+= $values;
}
$reader.Close();
$rows
}
@jdmonty
Copy link
Author

jdmonty commented Jul 9, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment