业务数据目录导入后无法在添加业务数据列表Web Part时显示

问题：

使用Business Data Catalog Definition Editor (Exchange 2007 SDK中的工具)，定义好业务数据目录并生成好.xml, 在SharePoint 管理中心 > 共享服务 > 业务数据目录 - 导入应用程序定义 中导入该.xml成功。然而在SharePoint 站点某页面添加 业务数据列表web part时，浏览窗口中却没有列出刚添加的业务数据定义！

 

解决：

 

(from - http://www.sharepointassist.com/2009/01/08/business-data-catalog-bdc-how-to/)

 

BUG ALERT - The BDC Editor has a bug that doesn’t allow it to properly create the finder method (thank you Stefano Demilani for finding this). When you import your application definition as created, you will receive an error stating There are no Business Data types loaded into the catalog when attempting to add a Business Data List to a web part page.

 

To prevent the bug above from becoming a nightmare expand out your Entities and update the MethodInstanceType to be “Finder” instead of IdEnumerator

 

Replace “IdEnumerator” with “Finder”

 

Update the FindAll* method’s RDBCommandText with several columns instead of only the ID field

 

If you do add addition columns to the FindAll method you will need to add references to these columns in the Reader portion of the FindAll parameters.

 

注意：修改 FindAll* method的RDBCommandText时注意其语法应类似：

 

select "ProductID", "Name" from Product

 

而不是

 

select "ProductID, Name" from product