ビジネスデータカタログ (Business Data Catalog) のサンプル【RTM 日本語版】

環境：
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">tsmatsuz11\OfficeServers</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 >= @MinPartKey) AND
              (p.PartKey <= @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&SaveLocation=http://tsmatsuz11/sites/officedemo/DocLib2&openin=browser&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 <= @maxProductKey and
              ProductKey >= @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>