Skip to content

ToDataTable should support more than 1 result. #1

@romero126

Description

@romero126

ToDataTable needs to support more than 1 result.

internal static DataTable ToDataTable(this IDataReader reader) => reader.ToDataSet().Tables[0];

I did something like this in PS

        $outputObject.Results = [System.Collections.Arraylist]::new()

        foreach ($tableInfo in ($extendedDataReaderTableInfo.Where({ $_.Kind -eq "QueryResult" }))) {
            $r = $extendedDataReader.Tables[ [int]($tableInfo.Ordinal ) ] | Select-Object -Property $extendedDataReader.Tables[ [int]($tableInfo.Ordinal) ].Columns.ColumnName
            $null = $outputObjectResults.Add($r)
        }

        $outputObject

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions