Dataset: ProductCatalog
Dataset properties
| Property | Value |
| Data source name | AdventureWorks |
| Referenced data set | |
| Command type | Query |
Parameters
| Name |
| @Language |
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| ProdSubCat | ProdSubCat | System.String | |||
| ProdModel | ProdModel | System.String | |||
| ProdCat | ProdCat | System.String | |||
| Description | Description | System.String | |||
| LargePhoto | LargePhoto | System.Byte[] | |||
| ProdName | ProdName | System.String | |||
| ProductNumber | ProductNumber | System.String | |||
| Color | Color | System.String | |||
| Size | Size | System.String | |||
| Weight | Weight | System.Decimal | |||
| StandardCost | StandardCost | System.Decimal | |||
| Style | Style | System.String | |||
| Class | Class | System.String | |||
| ListPrice | ListPrice | System.Decimal |
Filters
Query
SELECT PS.Name AS ProdSubCat, PM.Name AS ProdModel, PC.Name AS ProdCat, PD.Description, PP.LargePhoto, P.Name AS ProdName, P.ProductNumber, P.Color, P.Size, P.Weight, P.StandardCost, P.Style, P.Class, P.ListPrice FROM Production.Product P INNER JOIN Production.ProductSubcategory PS INNER JOIN Production.ProductCategory PC ON PS.ProductCategoryID = PC.ProductCategoryID ON P.ProductSubcategoryID = PS.ProductSubcategoryID INNER JOIN Production.ProductProductPhoto PPP ON P.ProductID = PPP.ProductID INNER JOIN Production.ProductPhoto PP ON PPP.ProductPhotoID = PP.ProductPhotoID LEFT OUTER JOIN Production.ProductDescription PD INNER JOIN Production.ProductModel PM INNER JOIN Production.ProductModelProductDescriptionCulture PMPDCL ON PM.ProductModelID = PMPDCL.ProductModelID ON PD.ProductDescriptionID = PMPDCL.ProductDescriptionID ON P.ProductModelID = PM.ProductModelID WHERE (PMPDCL.CultureID = @Language) |
See also