環境：
Office SharePoint Server 2007 (RTM) 日本語

こんにちは。

SQL Server 2005 のサンプルデータベースである AdventureWorksDW データベースを使って動作するビジネスデータカタログの RTM 版 (日本語版) のサンプルを添付しておきます。

Beta 2 TR の時にあった ExactMatch が無くなっているので、ご注意ください。

==================================================

<?xml version="1.0" encoding="shift_jis" standalone="yes"?><LobSystem  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xsi:schemaLocation="http://schemas.microsoft.com/office/sps/2005/bdcMetadata BDCMetadata.xsd"  Type="Database"  Version="1.0.1.1"  Name="AdventureWorksDW"  xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">  <LobSystemInstances><LobSystemInstance Name="AdventureWorksDW">  <Properties><Property Name="AuthenticationMode" Type="System.String">PassThrough</Property><Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property><Property Name="RdbConnection Data Source" Type="System.String">tsmatsuz11OfficeServers</Property><Property Name="RdbConnection Initial Catalog" Type="System.String">AdventureWorksDW</Property><Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property><Property Name="RdbConnection Pooling" Type="System.String">false</Property>  </Properties></LobSystemInstance>  </LobSystemInstances>  <Entities><Entity EstimatedInstanceCount="1000" Name="Part">  <Properties><Property Name="__BdcTitle" Type="System.String">PartName</Property><Property Name="Title" Type="System.String">PartName</Property>  </Properties>  <Identifiers><Identifier Name="PartKey" TypeName="System.Int32" />  </Identifiers>  <Methods><Method Name="PartFinder">  <Properties><Property Name="RdbCommandText" Type="System.String">  SELECT distinct p.*  FROM  Part p  inner join product_part pp on p.PartKey = pp.PartKey  inner join Product prod on pp.ProductKey = prod.ProductKey  WHERE  (p.PartKey &gt;= @MinPartKey) AND  (p.PartKey &lt;= @MaxPartKey) AND  (prod.ProductCode LIKE @ProductCode)  </Property><Property Name="RdbCommandType" Type="System.Data.CommandType,System.Data,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089">Text</Property>  </Properties>  <FilterDescriptors><FilterDescriptor Type="Wildcard" Name="ByProductCode">  <Properties><Property Name="UsedForDisambiguation" Type="System.Boolean">true</Property>  </Properties></FilterDescriptor><FilterDescriptor Type="Comparison" Name="Key" />  </FilterDescriptors>  <Parameters><Parameter Direction="In" Name="@MinPartKey">  <TypeDescriptor Name="MinPartKey" TypeName="System.Int32" IdentifierName="PartKey" AssociatedFilter="Key"><DefaultValues>  <DefaultValue MethodInstanceName="PartFinderInstance" Type="System.Int32">0</DefaultValue>  <DefaultValue MethodInstanceName="PartSpecificFinderInstance" Type="System.Int32">0</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="In" Name="@MaxPartKey">  <TypeDescriptor Name="MaxPartKey" TypeName="System.Int32" IdentifierName="PartKey" AssociatedFilter="Key"><DefaultValues>  <DefaultValue MethodInstanceName="PartFinderInstance" Type="System.Int32">9999999</DefaultValue>  <DefaultValue MethodInstanceName="PartSpecificFinderInstance" Type="System.Int32">9999999</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="In" Name="@ProductCode">  <TypeDescriptor Name="ProductCode" TypeName="System.String" AssociatedFilter="ByProductCode"><DefaultValues>  <DefaultValue MethodInstanceName="PartFinderInstance" Type="System.String">%</DefaultValue>  <DefaultValue MethodInstanceName="PartSpecificFinderInstance" Type="System.String">%</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Name="Parts" Direction="Return">  <TypeDescriptor Name="Parts" TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true"><TypeDescriptors>  <TypeDescriptor Name="Part" TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"><TypeDescriptors>  <TypeDescriptor Name="PartKey" TypeName="System.Int32" IdentifierName="PartKey"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品番号</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.String" Name="PartCode"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品コード</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor>  <TypeDescriptor Name="PartName" TypeName="System.String"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品名</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.Int16" Name="ReorderPoint"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">再注文</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.Int32" Name="Inventory"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">インベントリー</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></Parameter></Parameters><MethodInstances>  <MethodInstance Name="PartFinderInstance" Type="Finder" ReturnParameterName="Parts" />  <MethodInstance Name="PartSpecificFinderInstance" Type="SpecificFinder" ReturnParameterName="Parts" /></MethodInstances></Method>  </Methods>  <Actions><Action Name="注文をおこなう" Position="1" IsOpenedInNewWindow="true" Url="http://tsmatsuz11/sites/officedemo/_layouts/FormServer.aspx?XsnLocation=http://tsmatsuz11/sites/officedemo/FormServerTemplates/TestForm1[1].xsn&amp;SaveLocation=http://tsmatsuz11/sites/officedemo/DocLib2&amp;openin=browser&amp;PartCode={0}" ImageUrl="">  <ActionParameters><ActionParameter Name="PartCode" Index="0" />  </ActionParameters></Action>  </Actions></Entity><Entity EstimatedInstanceCount="10000" Name="Product">  <Properties><Property Name="Title" Type="System.String">ProductName</Property>  </Properties>  <Identifiers><Identifier TypeName="System.Int32" Name="ProductKey" />  </Identifiers>  <Methods><Method Name="GetProducts">  <Properties><Property Name="RdbCommandText" Type="System.String">  select * from  product  where  ProductCode like @productCode and  ProductName like @productName and  ProductKey &lt;= @maxProductKey and  ProductKey &gt;= @minProductKey</Property><Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>  </Properties>  <FilterDescriptors><FilterDescriptor Type="Wildcard" Name="ByName">  <Properties><Property Name="UsedForDisambiguation" Type="System.Boolean">true</Property>  </Properties></FilterDescriptor><FilterDescriptor Type="Wildcard" Name="ByCode" /><FilterDescriptor Type="Comparison" Name="ByID" />  </FilterDescriptors>  <Parameters><Parameter Direction="In" Name="@minProductKey">  <TypeDescriptor TypeName="System.Int32" IdentifierName="ProductKey" AssociatedFilter="ByID" Name="minProductKey"><DefaultValues>  <DefaultValue MethodInstanceName="ProductFinderInstance" Type="System.Int32">0</DefaultValue>  <DefaultValue MethodInstanceName="ProductSpecificFinderInstance" Type="System.Int32">0</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="In" Name="@maxProductKey">  <TypeDescriptor TypeName="System.Int32" IdentifierName="ProductKey" AssociatedFilter="ByID" Name="maxProductKey"><DefaultValues>  <DefaultValue MethodInstanceName="ProductFinderInstance" Type="System.Int32">99999999</DefaultValue>  <DefaultValue MethodInstanceName="ProductSpecificFinderInstance" Type="System.Int32">99999999</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="In" Name="@productName">  <TypeDescriptor TypeName="System.String" AssociatedFilter="ByName" Name="ProductName"><DefaultValues>  <DefaultValue MethodInstanceName="ProductFinderInstance" Type="System.String">%</DefaultValue>  <DefaultValue MethodInstanceName="ProductSpecificFinderInstance" Type="System.String">%</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="In" Name="@productCode">  <TypeDescriptor TypeName="System.String" AssociatedFilter="ByCode" Name="ProductCode"><DefaultValues>  <DefaultValue MethodInstanceName="ProductFinderInstance" Type="System.String">%</DefaultValue>  <DefaultValue MethodInstanceName="ProductSpecificFinderInstance" Type="System.String">%</DefaultValue></DefaultValues>  </TypeDescriptor></Parameter><Parameter Direction="Return" Name="Products">  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="ProductDataReader"><TypeDescriptors>  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="ProductDataRecord"><TypeDescriptors>  <TypeDescriptor TypeName="System.Int32" IdentifierName="ProductKey" Name="ProductKey"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">製品番号</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">false</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.String" Name="ProductCode"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">製品コード</LocalizedDisplayName></LocalizedDisplayNames>  </TypeDescriptor>  <TypeDescriptor TypeName="System.String" Name="ProductName"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">製品名</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></Parameter>  </Parameters>  <MethodInstances><MethodInstance Type="Finder" ReturnParameterName="Products" Name="ProductFinderInstance" /><MethodInstance Type="SpecificFinder" ReturnParameterName="Products" Name="ProductSpecificFinderInstance" />  </MethodInstances></Method><Method Name="GetPartsForProduct">  <Properties><Property Name="RdbCommandText" Type="System.String">  SELECT distinct p.*  FROM  Part p  inner join product_part pp on p.PartKey = pp.PartKey  inner join Product prod on pp.ProductKey = prod.ProductKey  WHERE  prod.ProductKey LIKE @ProductKey</Property><Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>  </Properties>  <Parameters><Parameter Direction="In" Name="@productKey">  <TypeDescriptor TypeName="System.Int32" IdentifierName="ProductKey" Name="ProductKey" /></Parameter><Parameter Direction="Return" Name="Parts">  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="PartDataReader"><TypeDescriptors>  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="PartDataRecord"><TypeDescriptors>  <TypeDescriptor TypeName="System.Int32" IdentifierEntityName="Part" IdentifierName="PartKey" Name="PartKey"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品番号</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">false</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.String" Name="PartCode"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品コード</LocalizedDisplayName></LocalizedDisplayNames>  </TypeDescriptor>  <TypeDescriptor TypeName="System.String" Name="PartName"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">部品名</LocalizedDisplayName></LocalizedDisplayNames><Properties>  <Property Name="DisplayByDefault" Type="System.Boolean">true</Property></Properties>  </TypeDescriptor>  <TypeDescriptor TypeName="System.Int16" Name="ReorderPoint"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">再注文</LocalizedDisplayName></LocalizedDisplayNames>  </TypeDescriptor>  <TypeDescriptor TypeName="System.Int32" Name="Inventory"><LocalizedDisplayNames>  <LocalizedDisplayName LCID="1041">インベントリー</LocalizedDisplayName></LocalizedDisplayNames>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></TypeDescriptors>  </TypeDescriptor></Parameter>  </Parameters></Method>  </Methods></Entity>  </Entities>  <Associations><Association AssociationMethodEntityName="Product" AssociationMethodName="GetPartsForProduct" AssociationMethodReturnParameterName="Parts" Name="ProductsToParts" IsCached="true">  <SourceEntity Name="Product" />  <DestinationEntity Name="Part" /></Association>  </Associations></LobSystem>

=========================================================================

AdventureWorksDW_Sample.xml