Powershell command in SharePoint to get the BCS throttle value. This also an example of a where working with a select. Note the GUID didn't really work.
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$ID = Get-SPServiceApplicationProxy | where {$_.DisplayName -like 'BCS*'} | select ID
$scuServAppProxy = Get-SPServiceApplicationProxy -Identity 5b48a638-0ba1-4aee-825f-13d16294329f
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$ID = Get-SPServiceApplicationProxy | where {$_.DisplayName -like 'BCS*'} | select ID
$scuServAppProxy = Get-SPServiceApplicationProxy -Identity 5b48a638-0ba1-4aee-825f-13d16294329f
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy