Exemplo SQL Server 2005 AdventureWorksDW
Se você estiver procurando o versão Microsoft SQL Server 2005 de metadados de AdventureWorks, você está no direito local. Nós percebeu que alguns de vocês estiver usando Microsoft SQL Server 2005 e portanto a versão SQL Server 2000 de metadados é praticamente inutilizável para você. Agora nós ter incluído os metadados exemplo que se conecta a banco de dados o AdventureWorksDW que está incluído Microsoft SQL Server 2005. Porque os conceitos e as etapas implantação permanecem os mesmos, nós pedirá que você referir para o Exemplo SQL Server 2000 AdventureWorks para obter detalhes.
Requisitos
Microsoft SQL Server 2005 e banco de dados o AdventureWorksDW.
Exemplo
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!-- This metadata defines four entities from the AdventureWorksDW Microsoft SQL Server 2005 sample database. Refer to the AdventureWorks 2000 XML for comments and the Walkthrough for instructions. -->
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="1.0.0.0" name="AdventureWorksDW" xmlns="https://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
<Properties>
<Property name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
<LobSystemInstances>
<LobSystemInstance name="AdventureWorksDWInstance">
<Properties>
<Property name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>
<Property name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>
<Property name="RdbConnection Data Source" Type="System.String">EnterYourAdventureWorksDW2005ServerNameHere</Property>
<Property name="RdbConnection Initial Catalog" Type="System.String">AdventureWorksDW</Property>
<Property name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
</Properties>
</LobSystemInstance>
</LobSystemInstances>
<Entities>
<Entity EstimatedInstanceCount="10000" name="Product">
<Properties>
<Property name="Title" Type="System.String">EnglishProductName</Property>
<Property name="DefaultAction" Type="System.String">View Profile</Property>
</Properties>
<Identifiers>
<Identifier name="ProductKey" Typename="System.Int32" />
</Identifiers>
<Methods>
<Method name="GetProducts">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT * FROM DimProduct WHERE (ProductKey >= @MinProductKey) AND (ProductKey <= @MaxProductKey) AND (EnglishProductName LIKE @EnglishProductName) AND (EnglishDescription LIKE @EnglishDescription) AND (Status='Current')</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<FilterDescriptors>
<FilterDescriptor Type="Comparison" name="Key" >
<Properties>
<Property name="Comparator" Type="System.String">Equals</Property>
</Properties>
</FilterDescriptor>
<FilterDescriptor Type="Wildcard" name="Name">
<Properties>
<Property name="UsedForDisambiguation" Type="System.Boolean">true</Property>
</Properties>
</FilterDescriptor>
<FilterDescriptor Type="Wildcard" name="Description" />
</FilterDescriptors>
<Parameters>
<Parameter Direction="In" name="@MinProductKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductKey" AssociatedFilter="Key" name="MinProductKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductFinderInstance" Type="System.Int32">0</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@MaxProductKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductKey" AssociatedFilter="Key" name="MaxProductKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductFinderInstance" Type="System.Int32">99999999</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@EnglishProductName">
<TypeDescriptor Typename="System.String" AssociatedFilter="Name" name="EnglishProductName">
<DefaultValues>
<DefaultValue MethodInstancename="ProductFinderInstance" Type="System.String">%</DefaultValue>
<DefaultValue MethodInstancename="ProductSpecificFinderInstance" Type="System.String">%</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@EnglishDescription">
<TypeDescriptor Typename="System.String" AssociatedFilter="Description" name="EnglishDescription">
<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="1033">Key</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishProductName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishDescription">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Description</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.Decimal" name="ListPrice">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">List Price</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Decimal" name="StandardCost">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Standard Cost</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="Color">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Color</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="Size">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Size</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="Class">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Class</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Int32" name="DaysToManufacture">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Days To Manufacture</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance name="ProductFinderInstance" Type="Finder" ReturnParametername="Products" />
<MethodInstance name="ProductSpecificFinderInstance" Type="SpecificFinder" ReturnParametername="Products" />
</MethodInstances>
</Method>
</Methods>
</Entity>
<Entity EstimatedInstanceCount="1000" name="Reseller">
<Properties>
<Property name="__BdcTitle" Type="System.String">ResellerName</Property>
<Property name="Title" Type="System.String">ResellerName</Property>
<Property name="DefaultAction" Type="System.String">View Profile</Property>
</Properties>
<Identifiers>
<Identifier name="ResellerKey" Typename="System.Int32" />
</Identifiers>
<Methods>
<Method name="ResellerIDEnumerator">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT ResellerKey FROM DimReseller</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<Parameters>
<Parameter Direction="Return" name="Resellers">
<TypeDescriptor Typename="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" name="ResellerDataReader">
<TypeDescriptors>
<TypeDescriptor Typename="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ResellerDataRecord">
<TypeDescriptors>
<TypeDescriptor Typename="System.Int32" Identifiername="ResellerKey" name="ResellerKey" />
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance name="ResellerIDEnumeratorInstance" Type="IdEnumerator" ReturnParametername="Resellers" />
</MethodInstances>
</Method>
<Method name="ResellerFinder">
<Properties>
<Property name="RdbCommandText" Type="System.String">
<![CDATA[
SELECT ResellerKey,DimReseller.GeographyKey,ResellerAlternateKey,Phone,BusinessType,
ResellerName,NumberEmployees,OrderFrequency,FirstOrderYear,LastOrderYear,ProductLine,
AddressLine1,AddressLine2,AnnualSales,BankName,MinPaymentAmount,AnnualRevenue,YearOpened,
City,StateProvinceCode,StateProvinceName,CountryRegionCode,EnglishCountryRegionName,PostalCode
FROM DimReseller INNER JOIN DimGeography
ON DimReseller.GeographyKey = DimGeography.GeographyKey
WHERE (ResellerKey >= @MinResellerKey) AND (ResellerKey <= @MaxResellerKey) AND (ResellerName LIKE @ResellerName)
]]>
</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<FilterDescriptors>
<FilterDescriptor Type="Wildcard" name="Name">
<Properties>
<Property name="UsedForDisambiguation" Type="System.Boolean">true</Property>
</Properties>
</FilterDescriptor>
<FilterDescriptor Type="Comparison" name="Key" >
<Properties>
<Property name="Comparator" Type="System.String">Equals</Property>
</Properties>
</FilterDescriptor>
</FilterDescriptors>
<Parameters>
<Parameter Direction="In" name="@MinResellerKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ResellerKey" AssociatedFilter="Key" name="MinResellerKey">
<DefaultValues>
<DefaultValue MethodInstancename="ResellerFinderInstance" Type="System.Int32">0</DefaultValue>
<DefaultValue MethodInstancename="ResellerSpecificFinderInstance" Type="System.Int32">0</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@MaxResellerKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ResellerKey" AssociatedFilter="Key" name="MaxResellerKey">
<DefaultValues>
<DefaultValue MethodInstancename="ResellerFinderInstance" Type="System.Int32">9999999</DefaultValue>
<DefaultValue MethodInstancename="ResellerSpecificFinderInstance" Type="System.Int32">9999999</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@ResellerName">
<TypeDescriptor Typename="System.String" AssociatedFilter="Name" name="ResellerName">
<DefaultValues>
<DefaultValue MethodInstancename="ResellerFinderInstance" Type="System.String">%</DefaultValue>
<DefaultValue MethodInstancename="ResellerSpecificFinderInstance" Type="System.String">%</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="Return" name="Resellers">
<TypeDescriptor Typename="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" name="Resellers">
<TypeDescriptors>
<TypeDescriptor Typename="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="Reseller">
<TypeDescriptors>
<TypeDescriptor Typename="System.Int32" Identifiername="ResellerKey" name="ResellerKey">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Number</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="Phone">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Phone</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="BusinessType">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Business Type</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="ResellerName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.Int32" name="NumberEmployees">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Employees</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="OrderFrequency">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Order Frequency</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Int32" name="FirstOrderYear">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">First Order Year</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Int32" name="LastOrderYear">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Last Order Year</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="ProductLine">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Product Line</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="AddressLine1">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Address Line 1</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="AddressLine2">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Address Line 2</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Decimal" name="AnnualSales">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Annual Sales</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="BankName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Bank Name</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Decimal" name="MinPaymentAmount">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Minimum Payment Amount</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Decimal" name="AnnualRevenue">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Annual Revenue</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.Int32" name="YearOpened">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Year Opened</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="City">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">City</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="StateProvinceCode">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">State/Province Code</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="StateProvinceName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">State/Province</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="CountryRegionCode">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Country/Region Code</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishCountryRegionName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Country/Region</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="PostalCode">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Postal Code</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance name="ResellerFinderInstance" Type="Finder" ReturnParametername="Resellers" />
<MethodInstance name="ResellerSpecificFinderInstance" Type="SpecificFinder" ReturnParametername="Resellers" />
</MethodInstances>
</Method>
</Methods>
</Entity>
<Entity EstimatedInstanceCount="10000" name="ProductSubcategory">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Product Subcategory</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="Title" Type="System.String">EnglishProductSubcategoryName</Property>
<Property name="DefaultAction" Type="System.String">View Profile</Property>
</Properties>
<Identifiers>
<Identifier name="ProductSubcategoryKey" Typename="System.Int32" />
</Identifiers>
<Methods>
<Method name="GetProductSubcategories">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT * FROM DimProductSubcategory WHERE (ProductSubcategoryKey >= @MinProductSubcategoryKey) AND (ProductSubcategoryKey <= @MaxProductSubcategoryKey) AND (EnglishProductSubcategoryName LIKE @EnglishProductSubcategoryName)</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<FilterDescriptors>
<FilterDescriptor Type="Comparison" name="Key" >
<Properties>
<Property name="Comparator" Type="System.String">Equals</Property>
</Properties>
</FilterDescriptor>
<FilterDescriptor Type="Wildcard" name="Name">
<Properties>
<Property name="UsedForDisambiguation" Type="System.Boolean">true</Property>
</Properties>
</FilterDescriptor>
</FilterDescriptors>
<Parameters>
<Parameter Direction="In" name="@MinProductSubcategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductSubcategoryKey" AssociatedFilter="Key" name="MinProductSubcategoryKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductSubcategoryFinderInstance" Type="System.Int32">0</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@MaxProductSubcategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductSubcategoryKey" AssociatedFilter="Key" name="MaxProductSubcategoryKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductSubcategoryFinderInstance" Type="System.Int32">99999999</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@EnglishProductSubcategoryName">
<TypeDescriptor Typename="System.String" AssociatedFilter="Name" name="EnglishProductSubcategoryName">
<DefaultValues>
<DefaultValue MethodInstancename="ProductSubcategoryFinderInstance" Type="System.String">%</DefaultValue>
<DefaultValue MethodInstancename="ProductSubcategorySpecificFinderInstance" Type="System.String">%</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="Return" name="ProductSubcategories">
<TypeDescriptor Typename="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" name="ProductSubcategoryDataReader">
<TypeDescriptors>
<TypeDescriptor Typename="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ProductSubcategoryDataRecord">
<TypeDescriptors>
<TypeDescriptor Typename="System.Int32" Identifiername="ProductSubcategoryKey" name="ProductSubcategoryKey">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Key</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishProductSubcategoryName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance name="ProductSubcategoryFinderInstance" Type="Finder" ReturnParametername="ProductSubcategories" />
<MethodInstance name="ProductSubcategorySpecificFinderInstance" Type="SpecificFinder" ReturnParametername="ProductSubcategories" />
</MethodInstances>
</Method>
<Method name="GetProducts">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT * FROM DimProduct WHERE ProductSubcategoryKey = @ProductSubcategoryKey AND Status = 'Current'</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<Parameters>
<Parameter Direction="In" name="@ProductSubcategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductSubcategoryKey" name="ProductSubcategoryKey" />
</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" IdentifierEntityname="Product" Identifiername="ProductKey" name="ProductKey">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Key</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishProductName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishDescription">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Description</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
</Method>
</Methods>
</Entity>
<Entity EstimatedInstanceCount="10000" name="ProductCategory">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Product Category</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="Title" Type="System.String">EnglishProductCategoryName</Property>
<Property name="DefaultAction" Type="System.String">View Profile</Property>
</Properties>
<Identifiers>
<Identifier name="ProductCategoryKey" Typename="System.Int32" />
</Identifiers>
<Methods>
<Method name="GetProductCategories">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT * FROM DimProductCategory WHERE (ProductCategoryKey >= @MinProductCategoryKey) AND (ProductCategoryKey <= @MaxProductCategoryKey) AND (EnglishProductCategoryName LIKE @EnglishProductCategoryName)</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<FilterDescriptors>
<FilterDescriptor Type="Comparison" name="Key" >
<Properties>
<Property name="Comparator" Type="System.String">Equals</Property>
</Properties>
</FilterDescriptor>
<FilterDescriptor Type="Wildcard" name="Name">
<Properties>
<Property name="UsedForDisambiguation" Type="System.Boolean">true</Property>
</Properties>
</FilterDescriptor>
</FilterDescriptors>
<Parameters>
<Parameter Direction="In" name="@MinProductCategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductCategoryKey" AssociatedFilter="Key" name="MinProductCategoryKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductCategoryFinderInstance" Type="System.Int32">0</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@MaxProductCategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductCategoryKey" AssociatedFilter="Key" name="MaxProductCategoryKey">
<DefaultValues>
<DefaultValue MethodInstancename="ProductCategoryFinderInstance" Type="System.Int32">99999999</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="In" name="@EnglishProductCategoryName">
<TypeDescriptor Typename="System.String" AssociatedFilter="Name" name="EnglishProductCategoryName">
<DefaultValues>
<DefaultValue MethodInstancename="ProductCategoryFinderInstance" Type="System.String">%</DefaultValue>
<DefaultValue MethodInstancename="ProductCategorySpecificFinderInstance" Type="System.String">%</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
<Parameter Direction="Return" name="ProductCategories">
<TypeDescriptor Typename="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" name="ProductCategoryDataReader">
<TypeDescriptors>
<TypeDescriptor Typename="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ProductCategoryDataRecord">
<TypeDescriptors>
<TypeDescriptor Typename="System.Int32" Identifiername="ProductCategoryKey" name="ProductCategoryKey">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Key</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishProductCategoryName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance name="ProductCategoryFinderInstance" Type="Finder" ReturnParametername="ProductCategories" />
<MethodInstance name="ProductCategorySpecificFinderInstance" Type="SpecificFinder" ReturnParametername="ProductCategories" />
</MethodInstances>
</Method>
<Method name="GetProductSubcategories">
<Properties>
<Property name="RdbCommandText" Type="System.String">SELECT * FROM DimProductSubcategory WHERE ProductCategoryKey = @ProductCategoryKey</Property>
<Property name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
</Properties>
<Parameters>
<Parameter Direction="In" name="@ProductCategoryKey">
<TypeDescriptor Typename="System.Int32" Identifiername="ProductCategoryKey" name="ProductCategoryKey" />
</Parameter>
<Parameter Direction="Return" name="ProductSubcategories">
<TypeDescriptor Typename="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" name="ProductSubcategoryDataReader">
<TypeDescriptors>
<TypeDescriptor Typename="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ProductSubcategoryDataRecord">
<TypeDescriptors>
<TypeDescriptor Typename="System.Int32" IdentifierEntityname="ProductSubcategory" Identifiername="ProductSubcategoryKey" name="ProductSubcategoryKey">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Key</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
<TypeDescriptor Typename="System.String" name="EnglishProductSubcategoryName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property name="DisplayByDefault" Type="System.Boolean">true</Property>
</Properties>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
</Method>
</Methods>
</Entity>
</Entities>
<Associations>
<Association AssociationMethodEntityname="ProductSubcategory" AssociationMethodname="GetProducts" AssociationMethodReturnParametername="Products" name="ProductSubcategoryToProduct" IsCached="true">
<SourceEntity name="ProductSubcategory" />
<DestinationEntity name="Product" />
</Association>
<Association AssociationMethodEntityname="ProductCategory" AssociationMethodname="GetProductSubcategories" AssociationMethodReturnParametername="ProductSubcategories" name="ProductCategoryToProductSubcategory" IsCached="true">
<SourceEntity name="ProductCategory" />
<DestinationEntity name="ProductSubcategory" />
</Association>
</Associations>
</LobSystem>
Consulte também
Outros recursos
Exemplo SQL Server 2000 AdventureWorks
Modelo de Metadados Catálogo de dados comerciais:
Catálogo de dados de negócios: arquitetura
Como a: Get Started with usando o modelo de objeto em tempo de execução
Como a: Get Started with usando o modelo de objeto de administração
Catálogo de dados Business FAQ:
Catálogo de dados de negócios: Glossário