如何設定 SharePoint 2010 Business Connectivity Services (BCS) 資料傳回數量的限制 ?

當使用 SharePoint 2010 中的 Business Connectivity Services (BCS) 連接外部資料庫時，預設傳回的資料量是有數量限制的 (2000筆)，超過的話，External List 這個 webpart 就無法正常顯示，就會出現下列錯誤:

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator. Correlation ID:b944db82-81bd-40a0-8a1a-ba24c57c1eac

##ReadMore##

可以使用 PowerShell 來放寬限制:

Add-PSSnapin Microsoft.SharePoint.PowerShell

Get-SPServiceApplicationProxy

Get-SPBusinessDataCatalogThrottleConfig
-Scope Database
-ThrottleType Items
-ServiceApplicationProxy 28739dbe-cc48-44e3-b7aa-8693e52d4843

$bdc = Get-SPBusinessDataCatalogThrottleConfig
-Scope Database
-ThrottleType Items
-ServiceApplicationProxy 28739dbe-cc48-44e3-b7aa-8693e52d4843

Set-SPBusinessDataCatalogThrottleConfig
-Identity $bdc
-Maximum 50000
-Default 50000