PowerShell Core - System.Data DataRow not providing the correct result. #4232
Description
I didn't pay too much attention in Beta 2 but after upgrading to Beta 3 I'm concern.
Steps to reproduce
Run Sample Code:
## - Connect and run T-SQL query
$Global:getSvr = "mtrinidadlt2,1437";
$Global:con = "server=$Global:getSvr;database=Master;Integrated Security=false;User ID=sa;" + 'Password=$Adm1n!';
$SqlQry = @'
sp_who2
'@;
$sda = New-Object System.Data.SqlClient.SqlDataAdapter ($SqlQry, $global:con)
$sdt = New-Object System.Data.DataTable
$sda.fill($sdt) | Out-Null
$sdt.rows | Select -first 5 | Format-TableExpected behavior
DataRow data to provide proper objects results column with its data value. It works in Windows PowerShell.
(See Image)
Actual behavior
Seems like a Python list array result: (See image)
Environment data
Both OS's:
Windows 10 Build 16237
Ubuntu 16.04.02
PS C:\Program Files\PowerShell\6.0.0-beta.3> $PSVersionTable
Name Value
---- -----
PSVersion 6.0.0-beta
PSEdition Core
GitCommitId v6.0.0-beta.3
OS Microsoft Windows 10.0.16237
Platform Win32NT
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
WSManStackVersion 3.0