<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AdventureWorksDW2012DataSet" targetNamespace="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns:mstns="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AdventureWorksDW2012ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AdventureWorksDW2012ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Win_Application.Properties.Settings.GlobalReference.Default.AdventureWorksDW2012ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DimProductTableAdapter" GeneratorDataComponentClassName="DimProductTableAdapter" Name="DimProduct" UserDataComponentName="DimProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.DimProduct" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DimProduct] WHERE (([ProductKey] = @Original_ProductKey) AND ((@IsNull_ProductAlternateKey = 1 AND [ProductAlternateKey] IS NULL) OR ([ProductAlternateKey] = @Original_ProductAlternateKey)) AND ((@IsNull_ProductSubcategoryKey = 1 AND [ProductSubcategoryKey] IS NULL) OR ([ProductSubcategoryKey] = @Original_ProductSubcategoryKey)) AND ((@IsNull_WeightUnitMeasureCode = 1 AND [WeightUnitMeasureCode] IS NULL) OR ([WeightUnitMeasureCode] = @Original_WeightUnitMeasureCode)) AND ((@IsNull_SizeUnitMeasureCode = 1 AND [SizeUnitMeasureCode] IS NULL) OR ([SizeUnitMeasureCode] = @Original_SizeUnitMeasureCode)) AND ([EnglishProductName] = @Original_EnglishProductName) AND ([SpanishProductName] = @Original_SpanishProductName) AND ([FrenchProductName] = @Original_FrenchProductName) AND ((@IsNull_StandardCost = 1 AND [StandardCost] IS NULL) OR ([StandardCost] = @Original_StandardCost)) AND ([FinishedGoodsFlag] = @Original_FinishedGoodsFlag) AND ([Color] = @Original_Color) AND ((@IsNull_SafetyStockLevel = 1 AND [SafetyStockLevel] IS NULL) OR ([SafetyStockLevel] = @Original_SafetyStockLevel)) AND ((@IsNull_ReorderPoint = 1 AND [ReorderPoint] IS NULL) OR ([ReorderPoint] = @Original_ReorderPoint)) AND ((@IsNull_ListPrice = 1 AND [ListPrice] IS NULL) OR ([ListPrice] = @Original_ListPrice)) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size)) AND ((@IsNull_SizeRange = 1 AND [SizeRange] IS NULL) OR ([SizeRange] = @Original_SizeRange)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_DaysToManufacture = 1 AND [DaysToManufacture] IS NULL) OR ([DaysToManufacture] = @Original_DaysToManufacture)) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_DealerPrice = 1 AND [DealerPrice] IS NULL) OR ([DealerPrice] = @Original_DealerPrice)) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ((@IsNull_Style = 1 AND [Style] IS NULL) OR ([Style] = @Original_Style)) AND ((@IsNull_ModelName = 1 AND [ModelName] IS NULL) OR ([ModelName] = @Original_ModelName)) AND ((@IsNull_EnglishDescription = 1 AND [EnglishDescription] IS NULL) OR ([EnglishDescription] = @Original_EnglishDescription)) AND ((@IsNull_FrenchDescription = 1 AND [FrenchDescription] IS NULL) OR ([FrenchDescription] = @Original_FrenchDescription)) AND ((@IsNull_ChineseDescription = 1 AND [ChineseDescription] IS NULL) OR ([ChineseDescription] = @Original_ChineseDescription)) AND ((@IsNull_ArabicDescription = 1 AND [ArabicDescription] IS NULL) OR ([ArabicDescription] = @Original_ArabicDescription)) AND ((@IsNull_HebrewDescription = 1 AND [HebrewDescription] IS NULL) OR ([HebrewDescription] = @Original_HebrewDescription)) AND ((@IsNull_ThaiDescription = 1 AND [ThaiDescription] IS NULL) OR ([ThaiDescription] = @Original_ThaiDescription)) AND ((@IsNull_GermanDescription = 1 AND [GermanDescription] IS NULL) OR ([GermanDescription] = @Original_GermanDescription)) AND ((@IsNull_JapaneseDescription = 1 AND [JapaneseDescription] IS NULL) OR ([JapaneseDescription] = @Original_JapaneseDescription)) AND ((@IsNull_TurkishDescription = 1 AND [TurkishDescription] IS NULL) OR ([TurkishDescription] = @Original_TurkishDescription)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WeightUnitMeasureCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WeightUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SizeUnitMeasureCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SizeUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StandardCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_StandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FinishedGoodsFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FinishedGoodsFlag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SafetyStockLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_SafetyStockLevel" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ReorderPoint" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ListPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ListPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Size" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Size" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SizeRange" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SizeRange" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductLine" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DealerPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_DealerPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Style" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Style" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModelName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModelName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnglishDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrenchDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChineseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChineseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArabicDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArabicDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HebrewDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HebrewDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThaiDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ThaiDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GermanDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GermanDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JapaneseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JapaneseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TurkishDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TurkishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DimProduct] ([ProductAlternateKey], [ProductSubcategoryKey], [WeightUnitMeasureCode], [SizeUnitMeasureCode], [EnglishProductName], [SpanishProductName], [FrenchProductName], [StandardCost], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [ListPrice], [Size], [SizeRange], [Weight], [DaysToManufacture], [ProductLine], [DealerPrice], [Class], [Style], [ModelName], [LargePhoto], [EnglishDescription], [FrenchDescription], [ChineseDescription], [ArabicDescription], [HebrewDescription], [ThaiDescription], [GermanDescription], [JapaneseDescription], [TurkishDescription], [StartDate], [EndDate], [Status]) VALUES (@ProductAlternateKey, @ProductSubcategoryKey, @WeightUnitMeasureCode, @SizeUnitMeasureCode, @EnglishProductName, @SpanishProductName, @FrenchProductName, @StandardCost, @FinishedGoodsFlag, @Color, @SafetyStockLevel, @ReorderPoint, @ListPrice, @Size, @SizeRange, @Weight, @DaysToManufacture, @ProductLine, @DealerPrice, @Class, @Style, @ModelName, @LargePhoto, @EnglishDescription, @FrenchDescription, @ChineseDescription, @ArabicDescription, @HebrewDescription, @ThaiDescription, @GermanDescription, @JapaneseDescription, @TurkishDescription, @StartDate, @EndDate, @Status);
SELECT ProductKey, ProductAlternateKey, ProductSubcategoryKey, WeightUnitMeasureCode, SizeUnitMeasureCode, EnglishProductName, SpanishProductName, FrenchProductName, StandardCost, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, ListPrice, Size, SizeRange, Weight, DaysToManufacture, ProductLine, DealerPrice, Class, Style, ModelName, LargePhoto, EnglishDescription, FrenchDescription, ChineseDescription, ArabicDescription, HebrewDescription, ThaiDescription, GermanDescription, JapaneseDescription, TurkishDescription, StartDate, EndDate, Status FROM DimProduct WHERE (ProductKey = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WeightUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SizeUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@StandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FinishedGoodsFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FinishedGoodsFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@SafetyStockLevel" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ReorderPoint" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ListPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Size" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SizeRange" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductLine" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@DealerPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Style" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModelName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@LargePhoto" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="LargePhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChineseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HebrewDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ThaiDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GermanDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JapaneseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TurkishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductKey, ProductAlternateKey, ProductSubcategoryKey, WeightUnitMeasureCode, SizeUnitMeasureCode, EnglishProductName, SpanishProductName, FrenchProductName, StandardCost, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, ListPrice, Size, SizeRange, Weight, DaysToManufacture, ProductLine, DealerPrice, Class, Style, ModelName, LargePhoto, EnglishDescription, FrenchDescription, ChineseDescription, ArabicDescription, HebrewDescription, ThaiDescription, GermanDescription, JapaneseDescription, TurkishDescription, StartDate, EndDate, Status FROM dbo.DimProduct</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DimProduct] SET [ProductAlternateKey] = @ProductAlternateKey, [ProductSubcategoryKey] = @ProductSubcategoryKey, [WeightUnitMeasureCode] = @WeightUnitMeasureCode, [SizeUnitMeasureCode] = @SizeUnitMeasureCode, [EnglishProductName] = @EnglishProductName, [SpanishProductName] = @SpanishProductName, [FrenchProductName] = @FrenchProductName, [StandardCost] = @StandardCost, [FinishedGoodsFlag] = @FinishedGoodsFlag, [Color] = @Color, [SafetyStockLevel] = @SafetyStockLevel, [ReorderPoint] = @ReorderPoint, [ListPrice] = @ListPrice, [Size] = @Size, [SizeRange] = @SizeRange, [Weight] = @Weight, [DaysToManufacture] = @DaysToManufacture, [ProductLine] = @ProductLine, [DealerPrice] = @DealerPrice, [Class] = @Class, [Style] = @Style, [ModelName] = @ModelName, [LargePhoto] = @LargePhoto, [EnglishDescription] = @EnglishDescription, [FrenchDescription] = @FrenchDescription, [ChineseDescription] = @ChineseDescription, [ArabicDescription] = @ArabicDescription, [HebrewDescription] = @HebrewDescription, [ThaiDescription] = @ThaiDescription, [GermanDescription] = @GermanDescription, [JapaneseDescription] = @JapaneseDescription, [TurkishDescription] = @TurkishDescription, [StartDate] = @StartDate, [EndDate] = @EndDate, [Status] = @Status WHERE (([ProductKey] = @Original_ProductKey) AND ((@IsNull_ProductAlternateKey = 1 AND [ProductAlternateKey] IS NULL) OR ([ProductAlternateKey] = @Original_ProductAlternateKey)) AND ((@IsNull_ProductSubcategoryKey = 1 AND [ProductSubcategoryKey] IS NULL) OR ([ProductSubcategoryKey] = @Original_ProductSubcategoryKey)) AND ((@IsNull_WeightUnitMeasureCode = 1 AND [WeightUnitMeasureCode] IS NULL) OR ([WeightUnitMeasureCode] = @Original_WeightUnitMeasureCode)) AND ((@IsNull_SizeUnitMeasureCode = 1 AND [SizeUnitMeasureCode] IS NULL) OR ([SizeUnitMeasureCode] = @Original_SizeUnitMeasureCode)) AND ([EnglishProductName] = @Original_EnglishProductName) AND ([SpanishProductName] = @Original_SpanishProductName) AND ([FrenchProductName] = @Original_FrenchProductName) AND ((@IsNull_StandardCost = 1 AND [StandardCost] IS NULL) OR ([StandardCost] = @Original_StandardCost)) AND ([FinishedGoodsFlag] = @Original_FinishedGoodsFlag) AND ([Color] = @Original_Color) AND ((@IsNull_SafetyStockLevel = 1 AND [SafetyStockLevel] IS NULL) OR ([SafetyStockLevel] = @Original_SafetyStockLevel)) AND ((@IsNull_ReorderPoint = 1 AND [ReorderPoint] IS NULL) OR ([ReorderPoint] = @Original_ReorderPoint)) AND ((@IsNull_ListPrice = 1 AND [ListPrice] IS NULL) OR ([ListPrice] = @Original_ListPrice)) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size)) AND ((@IsNull_SizeRange = 1 AND [SizeRange] IS NULL) OR ([SizeRange] = @Original_SizeRange)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_DaysToManufacture = 1 AND [DaysToManufacture] IS NULL) OR ([DaysToManufacture] = @Original_DaysToManufacture)) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_DealerPrice = 1 AND [DealerPrice] IS NULL) OR ([DealerPrice] = @Original_DealerPrice)) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ((@IsNull_Style = 1 AND [Style] IS NULL) OR ([Style] = @Original_Style)) AND ((@IsNull_ModelName = 1 AND [ModelName] IS NULL) OR ([ModelName] = @Original_ModelName)) AND ((@IsNull_EnglishDescription = 1 AND [EnglishDescription] IS NULL) OR ([EnglishDescription] = @Original_EnglishDescription)) AND ((@IsNull_FrenchDescription = 1 AND [FrenchDescription] IS NULL) OR ([FrenchDescription] = @Original_FrenchDescription)) AND ((@IsNull_ChineseDescription = 1 AND [ChineseDescription] IS NULL) OR ([ChineseDescription] = @Original_ChineseDescription)) AND ((@IsNull_ArabicDescription = 1 AND [ArabicDescription] IS NULL) OR ([ArabicDescription] = @Original_ArabicDescription)) AND ((@IsNull_HebrewDescription = 1 AND [HebrewDescription] IS NULL) OR ([HebrewDescription] = @Original_HebrewDescription)) AND ((@IsNull_ThaiDescription = 1 AND [ThaiDescription] IS NULL) OR ([ThaiDescription] = @Original_ThaiDescription)) AND ((@IsNull_GermanDescription = 1 AND [GermanDescription] IS NULL) OR ([GermanDescription] = @Original_GermanDescription)) AND ((@IsNull_JapaneseDescription = 1 AND [JapaneseDescription] IS NULL) OR ([JapaneseDescription] = @Original_JapaneseDescription)) AND ((@IsNull_TurkishDescription = 1 AND [TurkishDescription] IS NULL) OR ([TurkishDescription] = @Original_TurkishDescription)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)));
SELECT ProductKey, ProductAlternateKey, ProductSubcategoryKey, WeightUnitMeasureCode, SizeUnitMeasureCode, EnglishProductName, SpanishProductName, FrenchProductName, StandardCost, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, ListPrice, Size, SizeRange, Weight, DaysToManufacture, ProductLine, DealerPrice, Class, Style, ModelName, LargePhoto, EnglishDescription, FrenchDescription, ChineseDescription, ArabicDescription, HebrewDescription, ThaiDescription, GermanDescription, JapaneseDescription, TurkishDescription, StartDate, EndDate, Status FROM DimProduct WHERE (ProductKey = @ProductKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WeightUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SizeUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@StandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FinishedGoodsFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FinishedGoodsFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@SafetyStockLevel" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ReorderPoint" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ListPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Size" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SizeRange" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductLine" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@DealerPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Style" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModelName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@LargePhoto" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="LargePhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChineseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HebrewDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ThaiDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GermanDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JapaneseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TurkishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WeightUnitMeasureCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WeightUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WeightUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SizeUnitMeasureCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SizeUnitMeasureCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SizeUnitMeasureCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StandardCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_StandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="StandardCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FinishedGoodsFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FinishedGoodsFlag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SafetyStockLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_SafetyStockLevel" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="SafetyStockLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ReorderPoint" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ListPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ListPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ListPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Size" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Size" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SizeRange" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SizeRange" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SizeRange" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DaysToManufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DaysToManufacture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductLine" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DealerPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_DealerPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="DealerPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Style" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Style" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Style" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModelName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModelName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnglishDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FrenchDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChineseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChineseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChineseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArabicDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArabicDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HebrewDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HebrewDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HebrewDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThaiDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ThaiDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThaiDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GermanDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GermanDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GermanDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JapaneseDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JapaneseDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JapaneseDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TurkishDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TurkishDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TurkishDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductKey" ColumnName="ProductKey" DataSourceName="AdventureWorksDW2012.dbo.DimProduct" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductKey" DataSetColumn="ProductKey" />
              <Mapping SourceColumn="ProductAlternateKey" DataSetColumn="ProductAlternateKey" />
              <Mapping SourceColumn="ProductSubcategoryKey" DataSetColumn="ProductSubcategoryKey" />
              <Mapping SourceColumn="WeightUnitMeasureCode" DataSetColumn="WeightUnitMeasureCode" />
              <Mapping SourceColumn="SizeUnitMeasureCode" DataSetColumn="SizeUnitMeasureCode" />
              <Mapping SourceColumn="EnglishProductName" DataSetColumn="EnglishProductName" />
              <Mapping SourceColumn="SpanishProductName" DataSetColumn="SpanishProductName" />
              <Mapping SourceColumn="FrenchProductName" DataSetColumn="FrenchProductName" />
              <Mapping SourceColumn="StandardCost" DataSetColumn="StandardCost" />
              <Mapping SourceColumn="FinishedGoodsFlag" DataSetColumn="FinishedGoodsFlag" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="SafetyStockLevel" DataSetColumn="SafetyStockLevel" />
              <Mapping SourceColumn="ReorderPoint" DataSetColumn="ReorderPoint" />
              <Mapping SourceColumn="ListPrice" DataSetColumn="ListPrice" />
              <Mapping SourceColumn="Size" DataSetColumn="Size" />
              <Mapping SourceColumn="SizeRange" DataSetColumn="SizeRange" />
              <Mapping SourceColumn="Weight" DataSetColumn="Weight" />
              <Mapping SourceColumn="DaysToManufacture" DataSetColumn="DaysToManufacture" />
              <Mapping SourceColumn="ProductLine" DataSetColumn="ProductLine" />
              <Mapping SourceColumn="DealerPrice" DataSetColumn="DealerPrice" />
              <Mapping SourceColumn="Class" DataSetColumn="Class" />
              <Mapping SourceColumn="Style" DataSetColumn="Style" />
              <Mapping SourceColumn="ModelName" DataSetColumn="ModelName" />
              <Mapping SourceColumn="LargePhoto" DataSetColumn="LargePhoto" />
              <Mapping SourceColumn="EnglishDescription" DataSetColumn="EnglishDescription" />
              <Mapping SourceColumn="FrenchDescription" DataSetColumn="FrenchDescription" />
              <Mapping SourceColumn="ChineseDescription" DataSetColumn="ChineseDescription" />
              <Mapping SourceColumn="ArabicDescription" DataSetColumn="ArabicDescription" />
              <Mapping SourceColumn="HebrewDescription" DataSetColumn="HebrewDescription" />
              <Mapping SourceColumn="ThaiDescription" DataSetColumn="ThaiDescription" />
              <Mapping SourceColumn="GermanDescription" DataSetColumn="GermanDescription" />
              <Mapping SourceColumn="JapaneseDescription" DataSetColumn="JapaneseDescription" />
              <Mapping SourceColumn="TurkishDescription" DataSetColumn="TurkishDescription" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DimProductCategoryTableAdapter" GeneratorDataComponentClassName="DimProductCategoryTableAdapter" Name="DimProductCategory" UserDataComponentName="DimProductCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.DimProductCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DimProductCategory] WHERE (([ProductCategoryKey] = @Original_ProductCategoryKey) AND ((@IsNull_ProductCategoryAlternateKey = 1 AND [ProductCategoryAlternateKey] IS NULL) OR ([ProductCategoryAlternateKey] = @Original_ProductCategoryAlternateKey)) AND ([EnglishProductCategoryName] = @Original_EnglishProductCategoryName) AND ([SpanishProductCategoryName] = @Original_SpanishProductCategoryName) AND ([FrenchProductCategoryName] = @Original_FrenchProductCategoryName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DimProductCategory] ([ProductCategoryAlternateKey], [EnglishProductCategoryName], [SpanishProductCategoryName], [FrenchProductCategoryName]) VALUES (@ProductCategoryAlternateKey, @EnglishProductCategoryName, @SpanishProductCategoryName, @FrenchProductCategoryName);
SELECT ProductCategoryKey, ProductCategoryAlternateKey, EnglishProductCategoryName, SpanishProductCategoryName, FrenchProductCategoryName FROM DimProductCategory WHERE (ProductCategoryKey = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductCategoryKey, ProductCategoryAlternateKey, EnglishProductCategoryName, SpanishProductCategoryName, FrenchProductCategoryName FROM dbo.DimProductCategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DimProductCategory] SET [ProductCategoryAlternateKey] = @ProductCategoryAlternateKey, [EnglishProductCategoryName] = @EnglishProductCategoryName, [SpanishProductCategoryName] = @SpanishProductCategoryName, [FrenchProductCategoryName] = @FrenchProductCategoryName WHERE (([ProductCategoryKey] = @Original_ProductCategoryKey) AND ((@IsNull_ProductCategoryAlternateKey = 1 AND [ProductCategoryAlternateKey] IS NULL) OR ([ProductCategoryAlternateKey] = @Original_ProductCategoryAlternateKey)) AND ([EnglishProductCategoryName] = @Original_EnglishProductCategoryName) AND ([SpanishProductCategoryName] = @Original_SpanishProductCategoryName) AND ([FrenchProductCategoryName] = @Original_FrenchProductCategoryName));
SELECT ProductCategoryKey, ProductCategoryAlternateKey, EnglishProductCategoryName, SpanishProductCategoryName, FrenchProductCategoryName FROM DimProductCategory WHERE (ProductCategoryKey = @ProductCategoryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductCategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductCategoryKey" ColumnName="ProductCategoryKey" DataSourceName="AdventureWorksDW2012.dbo.DimProductCategory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductCategoryKey" DataSetColumn="ProductCategoryKey" />
              <Mapping SourceColumn="ProductCategoryAlternateKey" DataSetColumn="ProductCategoryAlternateKey" />
              <Mapping SourceColumn="EnglishProductCategoryName" DataSetColumn="EnglishProductCategoryName" />
              <Mapping SourceColumn="SpanishProductCategoryName" DataSetColumn="SpanishProductCategoryName" />
              <Mapping SourceColumn="FrenchProductCategoryName" DataSetColumn="FrenchProductCategoryName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DimProductSubcategoryTableAdapter" GeneratorDataComponentClassName="DimProductSubcategoryTableAdapter" Name="DimProductSubcategory" UserDataComponentName="DimProductSubcategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.DimProductSubcategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DimProductSubcategory] WHERE (([ProductSubcategoryKey] = @Original_ProductSubcategoryKey) AND ((@IsNull_ProductSubcategoryAlternateKey = 1 AND [ProductSubcategoryAlternateKey] IS NULL) OR ([ProductSubcategoryAlternateKey] = @Original_ProductSubcategoryAlternateKey)) AND ([EnglishProductSubcategoryName] = @Original_EnglishProductSubcategoryName) AND ([SpanishProductSubcategoryName] = @Original_SpanishProductSubcategoryName) AND ([FrenchProductSubcategoryName] = @Original_FrenchProductSubcategoryName) AND ((@IsNull_ProductCategoryKey = 1 AND [ProductCategoryKey] IS NULL) OR ([ProductCategoryKey] = @Original_ProductCategoryKey)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DimProductSubcategory] ([ProductSubcategoryAlternateKey], [EnglishProductSubcategoryName], [SpanishProductSubcategoryName], [FrenchProductSubcategoryName], [ProductCategoryKey]) VALUES (@ProductSubcategoryAlternateKey, @EnglishProductSubcategoryName, @SpanishProductSubcategoryName, @FrenchProductSubcategoryName, @ProductCategoryKey);
SELECT ProductSubcategoryKey, ProductSubcategoryAlternateKey, EnglishProductSubcategoryName, SpanishProductSubcategoryName, FrenchProductSubcategoryName, ProductCategoryKey FROM DimProductSubcategory WHERE (ProductSubcategoryKey = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductSubcategoryKey, ProductSubcategoryAlternateKey, EnglishProductSubcategoryName, SpanishProductSubcategoryName, FrenchProductSubcategoryName, ProductCategoryKey FROM dbo.DimProductSubcategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DimProductSubcategory] SET [ProductSubcategoryAlternateKey] = @ProductSubcategoryAlternateKey, [EnglishProductSubcategoryName] = @EnglishProductSubcategoryName, [SpanishProductSubcategoryName] = @SpanishProductSubcategoryName, [FrenchProductSubcategoryName] = @FrenchProductSubcategoryName, [ProductCategoryKey] = @ProductCategoryKey WHERE (([ProductSubcategoryKey] = @Original_ProductSubcategoryKey) AND ((@IsNull_ProductSubcategoryAlternateKey = 1 AND [ProductSubcategoryAlternateKey] IS NULL) OR ([ProductSubcategoryAlternateKey] = @Original_ProductSubcategoryAlternateKey)) AND ([EnglishProductSubcategoryName] = @Original_EnglishProductSubcategoryName) AND ([SpanishProductSubcategoryName] = @Original_SpanishProductSubcategoryName) AND ([FrenchProductSubcategoryName] = @Original_FrenchProductSubcategoryName) AND ((@IsNull_ProductCategoryKey = 1 AND [ProductCategoryKey] IS NULL) OR ([ProductCategoryKey] = @Original_ProductCategoryKey)));
SELECT ProductSubcategoryKey, ProductSubcategoryAlternateKey, EnglishProductSubcategoryName, SpanishProductSubcategoryName, FrenchProductSubcategoryName, ProductCategoryKey FROM DimProductSubcategory WHERE (ProductSubcategoryKey = @ProductSubcategoryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EnglishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpanishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FrenchProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductSubcategoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductSubcategoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EnglishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EnglishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SpanishProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpanishProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FrenchProductSubcategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrenchProductSubcategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCategoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductSubcategoryKey" ColumnName="ProductSubcategoryKey" DataSourceName="AdventureWorksDW2012.dbo.DimProductSubcategory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductSubcategoryKey" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductSubcategoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductSubcategoryKey" DataSetColumn="ProductSubcategoryKey" />
              <Mapping SourceColumn="ProductSubcategoryAlternateKey" DataSetColumn="ProductSubcategoryAlternateKey" />
              <Mapping SourceColumn="EnglishProductSubcategoryName" DataSetColumn="EnglishProductSubcategoryName" />
              <Mapping SourceColumn="SpanishProductSubcategoryName" DataSetColumn="SpanishProductSubcategoryName" />
              <Mapping SourceColumn="FrenchProductSubcategoryName" DataSetColumn="FrenchProductSubcategoryName" />
              <Mapping SourceColumn="ProductCategoryKey" DataSetColumn="ProductCategoryKey" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DimSalesTerritoryTableAdapter" GeneratorDataComponentClassName="DimSalesTerritoryTableAdapter" Name="DimSalesTerritory" UserDataComponentName="DimSalesTerritoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.DimSalesTerritory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DimSalesTerritory] WHERE (([SalesTerritoryKey] = @Original_SalesTerritoryKey) AND ((@IsNull_SalesTerritoryAlternateKey = 1 AND [SalesTerritoryAlternateKey] IS NULL) OR ([SalesTerritoryAlternateKey] = @Original_SalesTerritoryAlternateKey)) AND ([SalesTerritoryRegion] = @Original_SalesTerritoryRegion) AND ([SalesTerritoryCountry] = @Original_SalesTerritoryCountry) AND ((@IsNull_SalesTerritoryGroup = 1 AND [SalesTerritoryGroup] IS NULL) OR ([SalesTerritoryGroup] = @Original_SalesTerritoryGroup)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryRegion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryCountry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalesTerritoryGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DimSalesTerritory] ([SalesTerritoryAlternateKey], [SalesTerritoryRegion], [SalesTerritoryCountry], [SalesTerritoryGroup], [SalesTerritoryImage]) VALUES (@SalesTerritoryAlternateKey, @SalesTerritoryRegion, @SalesTerritoryCountry, @SalesTerritoryGroup, @SalesTerritoryImage);
SELECT SalesTerritoryKey, SalesTerritoryAlternateKey, SalesTerritoryRegion, SalesTerritoryCountry, SalesTerritoryGroup, SalesTerritoryImage FROM DimSalesTerritory WHERE (SalesTerritoryKey = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryRegion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@SalesTerritoryImage" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="SalesTerritoryImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesTerritoryKey, SalesTerritoryAlternateKey, SalesTerritoryRegion, SalesTerritoryCountry, SalesTerritoryGroup, SalesTerritoryImage FROM dbo.DimSalesTerritory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DimSalesTerritory] SET [SalesTerritoryAlternateKey] = @SalesTerritoryAlternateKey, [SalesTerritoryRegion] = @SalesTerritoryRegion, [SalesTerritoryCountry] = @SalesTerritoryCountry, [SalesTerritoryGroup] = @SalesTerritoryGroup, [SalesTerritoryImage] = @SalesTerritoryImage WHERE (([SalesTerritoryKey] = @Original_SalesTerritoryKey) AND ((@IsNull_SalesTerritoryAlternateKey = 1 AND [SalesTerritoryAlternateKey] IS NULL) OR ([SalesTerritoryAlternateKey] = @Original_SalesTerritoryAlternateKey)) AND ([SalesTerritoryRegion] = @Original_SalesTerritoryRegion) AND ([SalesTerritoryCountry] = @Original_SalesTerritoryCountry) AND ((@IsNull_SalesTerritoryGroup = 1 AND [SalesTerritoryGroup] IS NULL) OR ([SalesTerritoryGroup] = @Original_SalesTerritoryGroup)));
SELECT SalesTerritoryKey, SalesTerritoryAlternateKey, SalesTerritoryRegion, SalesTerritoryCountry, SalesTerritoryGroup, SalesTerritoryImage FROM DimSalesTerritory WHERE (SalesTerritoryKey = @SalesTerritoryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryRegion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesTerritoryGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@SalesTerritoryImage" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="SalesTerritoryImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryRegion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryCountry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalesTerritoryGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesTerritoryGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesTerritoryGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SalesTerritoryKey" ColumnName="SalesTerritoryKey" DataSourceName="AdventureWorksDW2012.dbo.DimSalesTerritory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesTerritoryKey" DataSetColumn="SalesTerritoryKey" />
              <Mapping SourceColumn="SalesTerritoryAlternateKey" DataSetColumn="SalesTerritoryAlternateKey" />
              <Mapping SourceColumn="SalesTerritoryRegion" DataSetColumn="SalesTerritoryRegion" />
              <Mapping SourceColumn="SalesTerritoryCountry" DataSetColumn="SalesTerritoryCountry" />
              <Mapping SourceColumn="SalesTerritoryGroup" DataSetColumn="SalesTerritoryGroup" />
              <Mapping SourceColumn="SalesTerritoryImage" DataSetColumn="SalesTerritoryImage" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FactInternetSalesTableAdapter" GeneratorDataComponentClassName="FactInternetSalesTableAdapter" Name="FactInternetSales" UserDataComponentName="FactInternetSalesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.FactInternetSales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FactInternetSales] WHERE (([ProductKey] = @Original_ProductKey) AND ([OrderDateKey] = @Original_OrderDateKey) AND ([DueDateKey] = @Original_DueDateKey) AND ([ShipDateKey] = @Original_ShipDateKey) AND ([CustomerKey] = @Original_CustomerKey) AND ([PromotionKey] = @Original_PromotionKey) AND ([CurrencyKey] = @Original_CurrencyKey) AND ([SalesTerritoryKey] = @Original_SalesTerritoryKey) AND ([SalesOrderNumber] = @Original_SalesOrderNumber) AND ([SalesOrderLineNumber] = @Original_SalesOrderLineNumber) AND ([RevisionNumber] = @Original_RevisionNumber) AND ([OrderQuantity] = @Original_OrderQuantity) AND ([UnitPrice] = @Original_UnitPrice) AND ([ExtendedAmount] = @Original_ExtendedAmount) AND ([UnitPriceDiscountPct] = @Original_UnitPriceDiscountPct) AND ([DiscountAmount] = @Original_DiscountAmount) AND ([ProductStandardCost] = @Original_ProductStandardCost) AND ([TotalProductCost] = @Original_TotalProductCost) AND ([SalesAmount] = @Original_SalesAmount) AND ([TaxAmt] = @Original_TaxAmt) AND ([Freight] = @Original_Freight) AND ((@IsNull_CarrierTrackingNumber = 1 AND [CarrierTrackingNumber] IS NULL) OR ([CarrierTrackingNumber] = @Original_CarrierTrackingNumber)) AND ((@IsNull_CustomerPONumber = 1 AND [CustomerPONumber] IS NULL) OR ([CustomerPONumber] = @Original_CustomerPONumber)) AND ((@IsNull_OrderDate = 1 AND [OrderDate] IS NULL) OR ([OrderDate] = @Original_OrderDate)) AND ((@IsNull_DueDate = 1 AND [DueDate] IS NULL) OR ([DueDate] = @Original_DueDate)) AND ((@IsNull_ShipDate = 1 AND [ShipDate] IS NULL) OR ([ShipDate] = @Original_ShipDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DueDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ShipDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PromotionKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PromotionKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CurrencyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_SalesOrderLineNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SalesOrderLineNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_OrderQuantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OrderQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ExtendedAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ExtendedAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_UnitPriceDiscountPct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UnitPriceDiscountPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ProductStandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ProductStandardCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TotalProductCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalProductCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SalesAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalesAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarrierTrackingNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CarrierTrackingNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerPONumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CustomerPONumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FactInternetSales] ([ProductKey], [OrderDateKey], [DueDateKey], [ShipDateKey], [CustomerKey], [PromotionKey], [CurrencyKey], [SalesTerritoryKey], [SalesOrderNumber], [SalesOrderLineNumber], [RevisionNumber], [OrderQuantity], [UnitPrice], [ExtendedAmount], [UnitPriceDiscountPct], [DiscountAmount], [ProductStandardCost], [TotalProductCost], [SalesAmount], [TaxAmt], [Freight], [CarrierTrackingNumber], [CustomerPONumber], [OrderDate], [DueDate], [ShipDate]) VALUES (@ProductKey, @OrderDateKey, @DueDateKey, @ShipDateKey, @CustomerKey, @PromotionKey, @CurrencyKey, @SalesTerritoryKey, @SalesOrderNumber, @SalesOrderLineNumber, @RevisionNumber, @OrderQuantity, @UnitPrice, @ExtendedAmount, @UnitPriceDiscountPct, @DiscountAmount, @ProductStandardCost, @TotalProductCost, @SalesAmount, @TaxAmt, @Freight, @CarrierTrackingNumber, @CustomerPONumber, @OrderDate, @DueDate, @ShipDate);
SELECT ProductKey, OrderDateKey, DueDateKey, ShipDateKey, CustomerKey, PromotionKey, CurrencyKey, SalesTerritoryKey, SalesOrderNumber, SalesOrderLineNumber, RevisionNumber, OrderQuantity, UnitPrice, ExtendedAmount, UnitPriceDiscountPct, DiscountAmount, ProductStandardCost, TotalProductCost, SalesAmount, TaxAmt, Freight, CarrierTrackingNumber, CustomerPONumber, OrderDate, DueDate, ShipDate FROM FactInternetSales WHERE (SalesOrderLineNumber = @SalesOrderLineNumber) AND (SalesOrderNumber = @SalesOrderNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DueDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PromotionKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PromotionKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@SalesOrderLineNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SalesOrderLineNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@OrderQuantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OrderQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ExtendedAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ExtendedAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UnitPriceDiscountPct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UnitPriceDiscountPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ProductStandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ProductStandardCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TotalProductCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalProductCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SalesAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalesAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CarrierTrackingNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CustomerPONumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductKey, OrderDateKey, DueDateKey, ShipDateKey, CustomerKey, PromotionKey, CurrencyKey, SalesTerritoryKey, SalesOrderNumber, SalesOrderLineNumber, RevisionNumber, OrderQuantity, UnitPrice, ExtendedAmount, UnitPriceDiscountPct, DiscountAmount, ProductStandardCost, TotalProductCost, SalesAmount, TaxAmt, Freight, CarrierTrackingNumber, CustomerPONumber, OrderDate, DueDate, ShipDate FROM dbo.FactInternetSales</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FactInternetSales] SET [ProductKey] = @ProductKey, [OrderDateKey] = @OrderDateKey, [DueDateKey] = @DueDateKey, [ShipDateKey] = @ShipDateKey, [CustomerKey] = @CustomerKey, [PromotionKey] = @PromotionKey, [CurrencyKey] = @CurrencyKey, [SalesTerritoryKey] = @SalesTerritoryKey, [SalesOrderNumber] = @SalesOrderNumber, [SalesOrderLineNumber] = @SalesOrderLineNumber, [RevisionNumber] = @RevisionNumber, [OrderQuantity] = @OrderQuantity, [UnitPrice] = @UnitPrice, [ExtendedAmount] = @ExtendedAmount, [UnitPriceDiscountPct] = @UnitPriceDiscountPct, [DiscountAmount] = @DiscountAmount, [ProductStandardCost] = @ProductStandardCost, [TotalProductCost] = @TotalProductCost, [SalesAmount] = @SalesAmount, [TaxAmt] = @TaxAmt, [Freight] = @Freight, [CarrierTrackingNumber] = @CarrierTrackingNumber, [CustomerPONumber] = @CustomerPONumber, [OrderDate] = @OrderDate, [DueDate] = @DueDate, [ShipDate] = @ShipDate WHERE (([ProductKey] = @Original_ProductKey) AND ([OrderDateKey] = @Original_OrderDateKey) AND ([DueDateKey] = @Original_DueDateKey) AND ([ShipDateKey] = @Original_ShipDateKey) AND ([CustomerKey] = @Original_CustomerKey) AND ([PromotionKey] = @Original_PromotionKey) AND ([CurrencyKey] = @Original_CurrencyKey) AND ([SalesTerritoryKey] = @Original_SalesTerritoryKey) AND ([SalesOrderNumber] = @Original_SalesOrderNumber) AND ([SalesOrderLineNumber] = @Original_SalesOrderLineNumber) AND ([RevisionNumber] = @Original_RevisionNumber) AND ([OrderQuantity] = @Original_OrderQuantity) AND ([UnitPrice] = @Original_UnitPrice) AND ([ExtendedAmount] = @Original_ExtendedAmount) AND ([UnitPriceDiscountPct] = @Original_UnitPriceDiscountPct) AND ([DiscountAmount] = @Original_DiscountAmount) AND ([ProductStandardCost] = @Original_ProductStandardCost) AND ([TotalProductCost] = @Original_TotalProductCost) AND ([SalesAmount] = @Original_SalesAmount) AND ([TaxAmt] = @Original_TaxAmt) AND ([Freight] = @Original_Freight) AND ((@IsNull_CarrierTrackingNumber = 1 AND [CarrierTrackingNumber] IS NULL) OR ([CarrierTrackingNumber] = @Original_CarrierTrackingNumber)) AND ((@IsNull_CustomerPONumber = 1 AND [CustomerPONumber] IS NULL) OR ([CustomerPONumber] = @Original_CustomerPONumber)) AND ((@IsNull_OrderDate = 1 AND [OrderDate] IS NULL) OR ([OrderDate] = @Original_OrderDate)) AND ((@IsNull_DueDate = 1 AND [DueDate] IS NULL) OR ([DueDate] = @Original_DueDate)) AND ((@IsNull_ShipDate = 1 AND [ShipDate] IS NULL) OR ([ShipDate] = @Original_ShipDate)));
SELECT ProductKey, OrderDateKey, DueDateKey, ShipDateKey, CustomerKey, PromotionKey, CurrencyKey, SalesTerritoryKey, SalesOrderNumber, SalesOrderLineNumber, RevisionNumber, OrderQuantity, UnitPrice, ExtendedAmount, UnitPriceDiscountPct, DiscountAmount, ProductStandardCost, TotalProductCost, SalesAmount, TaxAmt, Freight, CarrierTrackingNumber, CustomerPONumber, OrderDate, DueDate, ShipDate FROM FactInternetSales WHERE (SalesOrderLineNumber = @SalesOrderLineNumber) AND (SalesOrderNumber = @SalesOrderNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DueDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PromotionKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PromotionKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@SalesOrderLineNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SalesOrderLineNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@OrderQuantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OrderQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ExtendedAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ExtendedAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UnitPriceDiscountPct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UnitPriceDiscountPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ProductStandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ProductStandardCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TotalProductCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalProductCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SalesAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalesAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CarrierTrackingNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CustomerPONumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DueDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ShipDateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PromotionKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PromotionKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CurrencyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesTerritoryKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesTerritoryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_SalesOrderLineNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SalesOrderLineNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_OrderQuantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OrderQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ExtendedAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ExtendedAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_UnitPriceDiscountPct" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UnitPriceDiscountPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ProductStandardCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ProductStandardCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TotalProductCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalProductCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SalesAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalesAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarrierTrackingNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CarrierTrackingNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CarrierTrackingNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerPONumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CustomerPONumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerPONumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductKey" DataSetColumn="ProductKey" />
              <Mapping SourceColumn="OrderDateKey" DataSetColumn="OrderDateKey" />
              <Mapping SourceColumn="DueDateKey" DataSetColumn="DueDateKey" />
              <Mapping SourceColumn="ShipDateKey" DataSetColumn="ShipDateKey" />
              <Mapping SourceColumn="CustomerKey" DataSetColumn="CustomerKey" />
              <Mapping SourceColumn="PromotionKey" DataSetColumn="PromotionKey" />
              <Mapping SourceColumn="CurrencyKey" DataSetColumn="CurrencyKey" />
              <Mapping SourceColumn="SalesTerritoryKey" DataSetColumn="SalesTerritoryKey" />
              <Mapping SourceColumn="SalesOrderNumber" DataSetColumn="SalesOrderNumber" />
              <Mapping SourceColumn="SalesOrderLineNumber" DataSetColumn="SalesOrderLineNumber" />
              <Mapping SourceColumn="RevisionNumber" DataSetColumn="RevisionNumber" />
              <Mapping SourceColumn="OrderQuantity" DataSetColumn="OrderQuantity" />
              <Mapping SourceColumn="UnitPrice" DataSetColumn="UnitPrice" />
              <Mapping SourceColumn="ExtendedAmount" DataSetColumn="ExtendedAmount" />
              <Mapping SourceColumn="UnitPriceDiscountPct" DataSetColumn="UnitPriceDiscountPct" />
              <Mapping SourceColumn="DiscountAmount" DataSetColumn="DiscountAmount" />
              <Mapping SourceColumn="ProductStandardCost" DataSetColumn="ProductStandardCost" />
              <Mapping SourceColumn="TotalProductCost" DataSetColumn="TotalProductCost" />
              <Mapping SourceColumn="SalesAmount" DataSetColumn="SalesAmount" />
              <Mapping SourceColumn="TaxAmt" DataSetColumn="TaxAmt" />
              <Mapping SourceColumn="Freight" DataSetColumn="Freight" />
              <Mapping SourceColumn="CarrierTrackingNumber" DataSetColumn="CarrierTrackingNumber" />
              <Mapping SourceColumn="CustomerPONumber" DataSetColumn="CustomerPONumber" />
              <Mapping SourceColumn="OrderDate" DataSetColumn="OrderDate" />
              <Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
              <Mapping SourceColumn="ShipDate" DataSetColumn="ShipDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AdventureWorksDW2012DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="AdventureWorksDW2012DataSet" msprop:Generator_UserDSName="AdventureWorksDW2012DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DimProduct" msprop:Generator_TableClassName="DimProductDataTable" msprop:Generator_TableVarName="tableDimProduct" msprop:Generator_TablePropName="DimProduct" msprop:Generator_RowDeletingName="DimProductRowDeleting" msprop:Generator_RowChangingName="DimProductRowChanging" msprop:Generator_RowEvHandlerName="DimProductRowChangeEventHandler" msprop:Generator_RowDeletedName="DimProductRowDeleted" msprop:Generator_UserTableName="DimProduct" msprop:Generator_RowChangedName="DimProductRowChanged" msprop:Generator_RowEvArgName="DimProductRowChangeEvent" msprop:Generator_RowClassName="DimProductRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductKey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductKey" msprop:Generator_ColumnPropNameInRow="ProductKey" msprop:Generator_ColumnPropNameInTable="ProductKeyColumn" msprop:Generator_UserColumnName="ProductKey" type="xs:int" />
              <xs:element name="ProductAlternateKey" msprop:Generator_ColumnVarNameInTable="columnProductAlternateKey" msprop:Generator_ColumnPropNameInRow="ProductAlternateKey" msprop:Generator_ColumnPropNameInTable="ProductAlternateKeyColumn" msprop:Generator_UserColumnName="ProductAlternateKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductSubcategoryKey" msprop:Generator_ColumnVarNameInTable="columnProductSubcategoryKey" msprop:Generator_ColumnPropNameInRow="ProductSubcategoryKey" msprop:Generator_ColumnPropNameInTable="ProductSubcategoryKeyColumn" msprop:Generator_UserColumnName="ProductSubcategoryKey" type="xs:int" minOccurs="0" />
              <xs:element name="WeightUnitMeasureCode" msprop:Generator_ColumnVarNameInTable="columnWeightUnitMeasureCode" msprop:Generator_ColumnPropNameInRow="WeightUnitMeasureCode" msprop:Generator_ColumnPropNameInTable="WeightUnitMeasureCodeColumn" msprop:Generator_UserColumnName="WeightUnitMeasureCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SizeUnitMeasureCode" msprop:Generator_ColumnVarNameInTable="columnSizeUnitMeasureCode" msprop:Generator_ColumnPropNameInRow="SizeUnitMeasureCode" msprop:Generator_ColumnPropNameInTable="SizeUnitMeasureCodeColumn" msprop:Generator_UserColumnName="SizeUnitMeasureCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EnglishProductName" msprop:Generator_ColumnVarNameInTable="columnEnglishProductName" msprop:Generator_ColumnPropNameInRow="EnglishProductName" msprop:Generator_ColumnPropNameInTable="EnglishProductNameColumn" msprop:Generator_UserColumnName="EnglishProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SpanishProductName" msprop:Generator_ColumnVarNameInTable="columnSpanishProductName" msprop:Generator_ColumnPropNameInRow="SpanishProductName" msprop:Generator_ColumnPropNameInTable="SpanishProductNameColumn" msprop:Generator_UserColumnName="SpanishProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrenchProductName" msprop:Generator_ColumnVarNameInTable="columnFrenchProductName" msprop:Generator_ColumnPropNameInRow="FrenchProductName" msprop:Generator_ColumnPropNameInTable="FrenchProductNameColumn" msprop:Generator_UserColumnName="FrenchProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StandardCost" msprop:Generator_ColumnVarNameInTable="columnStandardCost" msprop:Generator_ColumnPropNameInRow="StandardCost" msprop:Generator_ColumnPropNameInTable="StandardCostColumn" msprop:Generator_UserColumnName="StandardCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="FinishedGoodsFlag" msprop:Generator_ColumnVarNameInTable="columnFinishedGoodsFlag" msprop:Generator_ColumnPropNameInRow="FinishedGoodsFlag" msprop:Generator_ColumnPropNameInTable="FinishedGoodsFlagColumn" msprop:Generator_UserColumnName="FinishedGoodsFlag" type="xs:boolean" />
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SafetyStockLevel" msprop:Generator_ColumnVarNameInTable="columnSafetyStockLevel" msprop:Generator_ColumnPropNameInRow="SafetyStockLevel" msprop:Generator_ColumnPropNameInTable="SafetyStockLevelColumn" msprop:Generator_UserColumnName="SafetyStockLevel" type="xs:short" minOccurs="0" />
              <xs:element name="ReorderPoint" msprop:Generator_ColumnVarNameInTable="columnReorderPoint" msprop:Generator_ColumnPropNameInRow="ReorderPoint" msprop:Generator_ColumnPropNameInTable="ReorderPointColumn" msprop:Generator_UserColumnName="ReorderPoint" type="xs:short" minOccurs="0" />
              <xs:element name="ListPrice" msprop:Generator_ColumnVarNameInTable="columnListPrice" msprop:Generator_ColumnPropNameInRow="ListPrice" msprop:Generator_ColumnPropNameInTable="ListPriceColumn" msprop:Generator_UserColumnName="ListPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="Size" msprop:Generator_ColumnVarNameInTable="columnSize" msprop:Generator_ColumnPropNameInRow="Size" msprop:Generator_ColumnPropNameInTable="SizeColumn" msprop:Generator_UserColumnName="Size" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SizeRange" msprop:Generator_ColumnVarNameInTable="columnSizeRange" msprop:Generator_ColumnPropNameInRow="SizeRange" msprop:Generator_ColumnPropNameInTable="SizeRangeColumn" msprop:Generator_UserColumnName="SizeRange" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Weight" msprop:Generator_ColumnVarNameInTable="columnWeight" msprop:Generator_ColumnPropNameInRow="Weight" msprop:Generator_ColumnPropNameInTable="WeightColumn" msprop:Generator_UserColumnName="Weight" type="xs:double" minOccurs="0" />
              <xs:element name="DaysToManufacture" msprop:Generator_ColumnVarNameInTable="columnDaysToManufacture" msprop:Generator_ColumnPropNameInRow="DaysToManufacture" msprop:Generator_ColumnPropNameInTable="DaysToManufactureColumn" msprop:Generator_UserColumnName="DaysToManufacture" type="xs:int" minOccurs="0" />
              <xs:element name="ProductLine" msprop:Generator_ColumnVarNameInTable="columnProductLine" msprop:Generator_ColumnPropNameInRow="ProductLine" msprop:Generator_ColumnPropNameInTable="ProductLineColumn" msprop:Generator_UserColumnName="ProductLine" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DealerPrice" msprop:Generator_ColumnVarNameInTable="columnDealerPrice" msprop:Generator_ColumnPropNameInRow="DealerPrice" msprop:Generator_ColumnPropNameInTable="DealerPriceColumn" msprop:Generator_UserColumnName="DealerPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Style" msprop:Generator_ColumnVarNameInTable="columnStyle" msprop:Generator_ColumnPropNameInRow="Style" msprop:Generator_ColumnPropNameInTable="StyleColumn" msprop:Generator_UserColumnName="Style" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModelName" msprop:Generator_ColumnVarNameInTable="columnModelName" msprop:Generator_ColumnPropNameInRow="ModelName" msprop:Generator_ColumnPropNameInTable="ModelNameColumn" msprop:Generator_UserColumnName="ModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LargePhoto" msprop:Generator_ColumnVarNameInTable="columnLargePhoto" msprop:Generator_ColumnPropNameInRow="LargePhoto" msprop:Generator_ColumnPropNameInTable="LargePhotoColumn" msprop:Generator_UserColumnName="LargePhoto" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="EnglishDescription" msprop:Generator_ColumnVarNameInTable="columnEnglishDescription" msprop:Generator_ColumnPropNameInRow="EnglishDescription" msprop:Generator_ColumnPropNameInTable="EnglishDescriptionColumn" msprop:Generator_UserColumnName="EnglishDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrenchDescription" msprop:Generator_ColumnVarNameInTable="columnFrenchDescription" msprop:Generator_ColumnPropNameInRow="FrenchDescription" msprop:Generator_ColumnPropNameInTable="FrenchDescriptionColumn" msprop:Generator_UserColumnName="FrenchDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChineseDescription" msprop:Generator_ColumnVarNameInTable="columnChineseDescription" msprop:Generator_ColumnPropNameInRow="ChineseDescription" msprop:Generator_ColumnPropNameInTable="ChineseDescriptionColumn" msprop:Generator_UserColumnName="ChineseDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArabicDescription" msprop:Generator_ColumnVarNameInTable="columnArabicDescription" msprop:Generator_ColumnPropNameInRow="ArabicDescription" msprop:Generator_ColumnPropNameInTable="ArabicDescriptionColumn" msprop:Generator_UserColumnName="ArabicDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HebrewDescription" msprop:Generator_ColumnVarNameInTable="columnHebrewDescription" msprop:Generator_ColumnPropNameInRow="HebrewDescription" msprop:Generator_ColumnPropNameInTable="HebrewDescriptionColumn" msprop:Generator_UserColumnName="HebrewDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ThaiDescription" msprop:Generator_ColumnVarNameInTable="columnThaiDescription" msprop:Generator_ColumnPropNameInRow="ThaiDescription" msprop:Generator_ColumnPropNameInTable="ThaiDescriptionColumn" msprop:Generator_UserColumnName="ThaiDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GermanDescription" msprop:Generator_ColumnVarNameInTable="columnGermanDescription" msprop:Generator_ColumnPropNameInRow="GermanDescription" msprop:Generator_ColumnPropNameInTable="GermanDescriptionColumn" msprop:Generator_UserColumnName="GermanDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JapaneseDescription" msprop:Generator_ColumnVarNameInTable="columnJapaneseDescription" msprop:Generator_ColumnPropNameInRow="JapaneseDescription" msprop:Generator_ColumnPropNameInTable="JapaneseDescriptionColumn" msprop:Generator_UserColumnName="JapaneseDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TurkishDescription" msprop:Generator_ColumnVarNameInTable="columnTurkishDescription" msprop:Generator_ColumnPropNameInRow="TurkishDescription" msprop:Generator_ColumnPropNameInTable="TurkishDescriptionColumn" msprop:Generator_UserColumnName="TurkishDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DimProductCategory" msprop:Generator_TableClassName="DimProductCategoryDataTable" msprop:Generator_TableVarName="tableDimProductCategory" msprop:Generator_TablePropName="DimProductCategory" msprop:Generator_RowDeletingName="DimProductCategoryRowDeleting" msprop:Generator_RowChangingName="DimProductCategoryRowChanging" msprop:Generator_RowEvHandlerName="DimProductCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="DimProductCategoryRowDeleted" msprop:Generator_UserTableName="DimProductCategory" msprop:Generator_RowChangedName="DimProductCategoryRowChanged" msprop:Generator_RowEvArgName="DimProductCategoryRowChangeEvent" msprop:Generator_RowClassName="DimProductCategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductCategoryKey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductCategoryKey" msprop:Generator_ColumnPropNameInRow="ProductCategoryKey" msprop:Generator_ColumnPropNameInTable="ProductCategoryKeyColumn" msprop:Generator_UserColumnName="ProductCategoryKey" type="xs:int" />
              <xs:element name="ProductCategoryAlternateKey" msprop:Generator_ColumnVarNameInTable="columnProductCategoryAlternateKey" msprop:Generator_ColumnPropNameInRow="ProductCategoryAlternateKey" msprop:Generator_ColumnPropNameInTable="ProductCategoryAlternateKeyColumn" msprop:Generator_UserColumnName="ProductCategoryAlternateKey" type="xs:int" minOccurs="0" />
              <xs:element name="EnglishProductCategoryName" msprop:Generator_ColumnVarNameInTable="columnEnglishProductCategoryName" msprop:Generator_ColumnPropNameInRow="EnglishProductCategoryName" msprop:Generator_ColumnPropNameInTable="EnglishProductCategoryNameColumn" msprop:Generator_UserColumnName="EnglishProductCategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SpanishProductCategoryName" msprop:Generator_ColumnVarNameInTable="columnSpanishProductCategoryName" msprop:Generator_ColumnPropNameInRow="SpanishProductCategoryName" msprop:Generator_ColumnPropNameInTable="SpanishProductCategoryNameColumn" msprop:Generator_UserColumnName="SpanishProductCategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrenchProductCategoryName" msprop:Generator_ColumnVarNameInTable="columnFrenchProductCategoryName" msprop:Generator_ColumnPropNameInRow="FrenchProductCategoryName" msprop:Generator_ColumnPropNameInTable="FrenchProductCategoryNameColumn" msprop:Generator_UserColumnName="FrenchProductCategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DimProductSubcategory" msprop:Generator_TableClassName="DimProductSubcategoryDataTable" msprop:Generator_TableVarName="tableDimProductSubcategory" msprop:Generator_TablePropName="DimProductSubcategory" msprop:Generator_RowDeletingName="DimProductSubcategoryRowDeleting" msprop:Generator_RowChangingName="DimProductSubcategoryRowChanging" msprop:Generator_RowEvHandlerName="DimProductSubcategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="DimProductSubcategoryRowDeleted" msprop:Generator_UserTableName="DimProductSubcategory" msprop:Generator_RowChangedName="DimProductSubcategoryRowChanged" msprop:Generator_RowEvArgName="DimProductSubcategoryRowChangeEvent" msprop:Generator_RowClassName="DimProductSubcategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductSubcategoryKey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductSubcategoryKey" msprop:Generator_ColumnPropNameInRow="ProductSubcategoryKey" msprop:Generator_ColumnPropNameInTable="ProductSubcategoryKeyColumn" msprop:Generator_UserColumnName="ProductSubcategoryKey" type="xs:int" />
              <xs:element name="ProductSubcategoryAlternateKey" msprop:Generator_ColumnVarNameInTable="columnProductSubcategoryAlternateKey" msprop:Generator_ColumnPropNameInRow="ProductSubcategoryAlternateKey" msprop:Generator_ColumnPropNameInTable="ProductSubcategoryAlternateKeyColumn" msprop:Generator_UserColumnName="ProductSubcategoryAlternateKey" type="xs:int" minOccurs="0" />
              <xs:element name="EnglishProductSubcategoryName" msprop:Generator_ColumnVarNameInTable="columnEnglishProductSubcategoryName" msprop:Generator_ColumnPropNameInRow="EnglishProductSubcategoryName" msprop:Generator_ColumnPropNameInTable="EnglishProductSubcategoryNameColumn" msprop:Generator_UserColumnName="EnglishProductSubcategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SpanishProductSubcategoryName" msprop:Generator_ColumnVarNameInTable="columnSpanishProductSubcategoryName" msprop:Generator_ColumnPropNameInRow="SpanishProductSubcategoryName" msprop:Generator_ColumnPropNameInTable="SpanishProductSubcategoryNameColumn" msprop:Generator_UserColumnName="SpanishProductSubcategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrenchProductSubcategoryName" msprop:Generator_ColumnVarNameInTable="columnFrenchProductSubcategoryName" msprop:Generator_ColumnPropNameInRow="FrenchProductSubcategoryName" msprop:Generator_ColumnPropNameInTable="FrenchProductSubcategoryNameColumn" msprop:Generator_UserColumnName="FrenchProductSubcategoryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductCategoryKey" msprop:Generator_ColumnVarNameInTable="columnProductCategoryKey" msprop:Generator_ColumnPropNameInRow="ProductCategoryKey" msprop:Generator_ColumnPropNameInTable="ProductCategoryKeyColumn" msprop:Generator_UserColumnName="ProductCategoryKey" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DimSalesTerritory" msprop:Generator_TableClassName="DimSalesTerritoryDataTable" msprop:Generator_TableVarName="tableDimSalesTerritory" msprop:Generator_TablePropName="DimSalesTerritory" msprop:Generator_RowDeletingName="DimSalesTerritoryRowDeleting" msprop:Generator_RowChangingName="DimSalesTerritoryRowChanging" msprop:Generator_RowEvHandlerName="DimSalesTerritoryRowChangeEventHandler" msprop:Generator_RowDeletedName="DimSalesTerritoryRowDeleted" msprop:Generator_UserTableName="DimSalesTerritory" msprop:Generator_RowChangedName="DimSalesTerritoryRowChanged" msprop:Generator_RowEvArgName="DimSalesTerritoryRowChangeEvent" msprop:Generator_RowClassName="DimSalesTerritoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesTerritoryKey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryKey" msprop:Generator_ColumnPropNameInRow="SalesTerritoryKey" msprop:Generator_ColumnPropNameInTable="SalesTerritoryKeyColumn" msprop:Generator_UserColumnName="SalesTerritoryKey" type="xs:int" />
              <xs:element name="SalesTerritoryAlternateKey" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryAlternateKey" msprop:Generator_ColumnPropNameInRow="SalesTerritoryAlternateKey" msprop:Generator_ColumnPropNameInTable="SalesTerritoryAlternateKeyColumn" msprop:Generator_UserColumnName="SalesTerritoryAlternateKey" type="xs:int" minOccurs="0" />
              <xs:element name="SalesTerritoryRegion" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryRegion" msprop:Generator_ColumnPropNameInRow="SalesTerritoryRegion" msprop:Generator_ColumnPropNameInTable="SalesTerritoryRegionColumn" msprop:Generator_UserColumnName="SalesTerritoryRegion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalesTerritoryCountry" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryCountry" msprop:Generator_ColumnPropNameInRow="SalesTerritoryCountry" msprop:Generator_ColumnPropNameInTable="SalesTerritoryCountryColumn" msprop:Generator_UserColumnName="SalesTerritoryCountry">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalesTerritoryGroup" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryGroup" msprop:Generator_ColumnPropNameInRow="SalesTerritoryGroup" msprop:Generator_ColumnPropNameInTable="SalesTerritoryGroupColumn" msprop:Generator_UserColumnName="SalesTerritoryGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalesTerritoryImage" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryImage" msprop:Generator_ColumnPropNameInRow="SalesTerritoryImage" msprop:Generator_ColumnPropNameInTable="SalesTerritoryImageColumn" msprop:Generator_UserColumnName="SalesTerritoryImage" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FactInternetSales" msprop:Generator_TableClassName="FactInternetSalesDataTable" msprop:Generator_TableVarName="tableFactInternetSales" msprop:Generator_TablePropName="FactInternetSales" msprop:Generator_RowDeletingName="FactInternetSalesRowDeleting" msprop:Generator_RowChangingName="FactInternetSalesRowChanging" msprop:Generator_RowEvHandlerName="FactInternetSalesRowChangeEventHandler" msprop:Generator_RowDeletedName="FactInternetSalesRowDeleted" msprop:Generator_UserTableName="FactInternetSales" msprop:Generator_RowChangedName="FactInternetSalesRowChanged" msprop:Generator_RowEvArgName="FactInternetSalesRowChangeEvent" msprop:Generator_RowClassName="FactInternetSalesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductKey" msprop:Generator_ColumnVarNameInTable="columnProductKey" msprop:Generator_ColumnPropNameInRow="ProductKey" msprop:Generator_ColumnPropNameInTable="ProductKeyColumn" msprop:Generator_UserColumnName="ProductKey" type="xs:int" />
              <xs:element name="OrderDateKey" msprop:Generator_ColumnVarNameInTable="columnOrderDateKey" msprop:Generator_ColumnPropNameInRow="OrderDateKey" msprop:Generator_ColumnPropNameInTable="OrderDateKeyColumn" msprop:Generator_UserColumnName="OrderDateKey" type="xs:int" />
              <xs:element name="DueDateKey" msprop:Generator_ColumnVarNameInTable="columnDueDateKey" msprop:Generator_ColumnPropNameInRow="DueDateKey" msprop:Generator_ColumnPropNameInTable="DueDateKeyColumn" msprop:Generator_UserColumnName="DueDateKey" type="xs:int" />
              <xs:element name="ShipDateKey" msprop:Generator_ColumnVarNameInTable="columnShipDateKey" msprop:Generator_ColumnPropNameInRow="ShipDateKey" msprop:Generator_ColumnPropNameInTable="ShipDateKeyColumn" msprop:Generator_UserColumnName="ShipDateKey" type="xs:int" />
              <xs:element name="CustomerKey" msprop:Generator_ColumnVarNameInTable="columnCustomerKey" msprop:Generator_ColumnPropNameInRow="CustomerKey" msprop:Generator_ColumnPropNameInTable="CustomerKeyColumn" msprop:Generator_UserColumnName="CustomerKey" type="xs:int" />
              <xs:element name="PromotionKey" msprop:Generator_ColumnVarNameInTable="columnPromotionKey" msprop:Generator_ColumnPropNameInRow="PromotionKey" msprop:Generator_ColumnPropNameInTable="PromotionKeyColumn" msprop:Generator_UserColumnName="PromotionKey" type="xs:int" />
              <xs:element name="CurrencyKey" msprop:Generator_ColumnVarNameInTable="columnCurrencyKey" msprop:Generator_ColumnPropNameInRow="CurrencyKey" msprop:Generator_ColumnPropNameInTable="CurrencyKeyColumn" msprop:Generator_UserColumnName="CurrencyKey" type="xs:int" />
              <xs:element name="SalesTerritoryKey" msprop:Generator_ColumnVarNameInTable="columnSalesTerritoryKey" msprop:Generator_ColumnPropNameInRow="SalesTerritoryKey" msprop:Generator_ColumnPropNameInTable="SalesTerritoryKeyColumn" msprop:Generator_UserColumnName="SalesTerritoryKey" type="xs:int" />
              <xs:element name="SalesOrderNumber" msprop:Generator_ColumnVarNameInTable="columnSalesOrderNumber" msprop:Generator_ColumnPropNameInRow="SalesOrderNumber" msprop:Generator_ColumnPropNameInTable="SalesOrderNumberColumn" msprop:Generator_UserColumnName="SalesOrderNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalesOrderLineNumber" msprop:Generator_ColumnVarNameInTable="columnSalesOrderLineNumber" msprop:Generator_ColumnPropNameInRow="SalesOrderLineNumber" msprop:Generator_ColumnPropNameInTable="SalesOrderLineNumberColumn" msprop:Generator_UserColumnName="SalesOrderLineNumber" type="xs:unsignedByte" />
              <xs:element name="RevisionNumber" msprop:Generator_ColumnVarNameInTable="columnRevisionNumber" msprop:Generator_ColumnPropNameInRow="RevisionNumber" msprop:Generator_ColumnPropNameInTable="RevisionNumberColumn" msprop:Generator_UserColumnName="RevisionNumber" type="xs:unsignedByte" />
              <xs:element name="OrderQuantity" msprop:Generator_ColumnVarNameInTable="columnOrderQuantity" msprop:Generator_ColumnPropNameInRow="OrderQuantity" msprop:Generator_ColumnPropNameInTable="OrderQuantityColumn" msprop:Generator_UserColumnName="OrderQuantity" type="xs:short" />
              <xs:element name="UnitPrice" msprop:Generator_ColumnVarNameInTable="columnUnitPrice" msprop:Generator_ColumnPropNameInRow="UnitPrice" msprop:Generator_ColumnPropNameInTable="UnitPriceColumn" msprop:Generator_UserColumnName="UnitPrice" type="xs:decimal" />
              <xs:element name="ExtendedAmount" msprop:Generator_ColumnVarNameInTable="columnExtendedAmount" msprop:Generator_ColumnPropNameInRow="ExtendedAmount" msprop:Generator_ColumnPropNameInTable="ExtendedAmountColumn" msprop:Generator_UserColumnName="ExtendedAmount" type="xs:decimal" />
              <xs:element name="UnitPriceDiscountPct" msprop:Generator_ColumnVarNameInTable="columnUnitPriceDiscountPct" msprop:Generator_ColumnPropNameInRow="UnitPriceDiscountPct" msprop:Generator_ColumnPropNameInTable="UnitPriceDiscountPctColumn" msprop:Generator_UserColumnName="UnitPriceDiscountPct" type="xs:double" />
              <xs:element name="DiscountAmount" msprop:Generator_ColumnVarNameInTable="columnDiscountAmount" msprop:Generator_ColumnPropNameInRow="DiscountAmount" msprop:Generator_ColumnPropNameInTable="DiscountAmountColumn" msprop:Generator_UserColumnName="DiscountAmount" type="xs:double" />
              <xs:element name="ProductStandardCost" msprop:Generator_ColumnVarNameInTable="columnProductStandardCost" msprop:Generator_ColumnPropNameInRow="ProductStandardCost" msprop:Generator_ColumnPropNameInTable="ProductStandardCostColumn" msprop:Generator_UserColumnName="ProductStandardCost" type="xs:decimal" />
              <xs:element name="TotalProductCost" msprop:Generator_ColumnVarNameInTable="columnTotalProductCost" msprop:Generator_ColumnPropNameInRow="TotalProductCost" msprop:Generator_ColumnPropNameInTable="TotalProductCostColumn" msprop:Generator_UserColumnName="TotalProductCost" type="xs:decimal" />
              <xs:element name="SalesAmount" msprop:Generator_ColumnVarNameInTable="columnSalesAmount" msprop:Generator_ColumnPropNameInRow="SalesAmount" msprop:Generator_ColumnPropNameInTable="SalesAmountColumn" msprop:Generator_UserColumnName="SalesAmount" type="xs:decimal" />
              <xs:element name="TaxAmt" msprop:Generator_ColumnVarNameInTable="columnTaxAmt" msprop:Generator_ColumnPropNameInRow="TaxAmt" msprop:Generator_ColumnPropNameInTable="TaxAmtColumn" msprop:Generator_UserColumnName="TaxAmt" type="xs:decimal" />
              <xs:element name="Freight" msprop:Generator_ColumnVarNameInTable="columnFreight" msprop:Generator_ColumnPropNameInRow="Freight" msprop:Generator_ColumnPropNameInTable="FreightColumn" msprop:Generator_UserColumnName="Freight" type="xs:decimal" />
              <xs:element name="CarrierTrackingNumber" msprop:Generator_ColumnVarNameInTable="columnCarrierTrackingNumber" msprop:Generator_ColumnPropNameInRow="CarrierTrackingNumber" msprop:Generator_ColumnPropNameInTable="CarrierTrackingNumberColumn" msprop:Generator_UserColumnName="CarrierTrackingNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomerPONumber" msprop:Generator_ColumnVarNameInTable="columnCustomerPONumber" msprop:Generator_ColumnPropNameInRow="CustomerPONumber" msprop:Generator_ColumnPropNameInTable="CustomerPONumberColumn" msprop:Generator_UserColumnName="CustomerPONumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderDate" msprop:Generator_ColumnVarNameInTable="columnOrderDate" msprop:Generator_ColumnPropNameInRow="OrderDate" msprop:Generator_ColumnPropNameInTable="OrderDateColumn" msprop:Generator_UserColumnName="OrderDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShipDate" msprop:Generator_ColumnVarNameInTable="columnShipDate" msprop:Generator_ColumnPropNameInRow="ShipDate" msprop:Generator_ColumnPropNameInTable="ShipDateColumn" msprop:Generator_UserColumnName="ShipDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DimProduct" />
      <xs:field xpath="mstns:ProductKey" />
    </xs:unique>
    <xs:unique name="DimProductCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DimProductCategory" />
      <xs:field xpath="mstns:ProductCategoryKey" />
    </xs:unique>
    <xs:unique name="DimProductSubcategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DimProductSubcategory" />
      <xs:field xpath="mstns:ProductSubcategoryKey" />
    </xs:unique>
    <xs:unique name="DimSalesTerritory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DimSalesTerritory" />
      <xs:field xpath="mstns:SalesTerritoryKey" />
    </xs:unique>
    <xs:unique name="FactInternetSales_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FactInternetSales" />
      <xs:field xpath="mstns:SalesOrderNumber" />
      <xs:field xpath="mstns:SalesOrderLineNumber" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_DimProduct_DimProductSubcategory" msdata:parent="DimProductSubcategory" msdata:child="DimProduct" msdata:parentkey="ProductSubcategoryKey" msdata:childkey="ProductSubcategoryKey" msprop:Generator_UserChildTable="DimProduct" msprop:Generator_ChildPropName="GetDimProductRows" msprop:Generator_UserRelationName="FK_DimProduct_DimProductSubcategory" msprop:Generator_RelationVarName="relationFK_DimProduct_DimProductSubcategory" msprop:Generator_UserParentTable="DimProductSubcategory" msprop:Generator_ParentPropName="DimProductSubcategoryRow" />
      <msdata:Relationship name="FK_DimProductSubcategory_DimProductCategory" msdata:parent="DimProductCategory" msdata:child="DimProductSubcategory" msdata:parentkey="ProductCategoryKey" msdata:childkey="ProductCategoryKey" msprop:Generator_UserChildTable="DimProductSubcategory" msprop:Generator_ChildPropName="GetDimProductSubcategoryRows" msprop:Generator_UserRelationName="FK_DimProductSubcategory_DimProductCategory" msprop:Generator_ParentPropName="DimProductCategoryRow" msprop:Generator_RelationVarName="relationFK_DimProductSubcategory_DimProductCategory" msprop:Generator_UserParentTable="DimProductCategory" />
      <msdata:Relationship name="FK_FactInternetSales_DimProduct" msdata:parent="DimProduct" msdata:child="FactInternetSales" msdata:parentkey="ProductKey" msdata:childkey="ProductKey" msprop:Generator_UserChildTable="FactInternetSales" msprop:Generator_ChildPropName="GetFactInternetSalesRows" msprop:Generator_UserRelationName="FK_FactInternetSales_DimProduct" msprop:Generator_ParentPropName="DimProductRow" msprop:Generator_RelationVarName="relationFK_FactInternetSales_DimProduct" msprop:Generator_UserParentTable="DimProduct" />
      <msdata:Relationship name="FK_FactInternetSales_DimSalesTerritory" msdata:parent="DimSalesTerritory" msdata:child="FactInternetSales" msdata:parentkey="SalesTerritoryKey" msdata:childkey="SalesTerritoryKey" msprop:Generator_UserChildTable="FactInternetSales" msprop:Generator_ChildPropName="GetFactInternetSalesRows" msprop:Generator_UserRelationName="FK_FactInternetSales_DimSalesTerritory" msprop:Generator_ParentPropName="DimSalesTerritoryRow" msprop:Generator_RelationVarName="relationFK_FactInternetSales_DimSalesTerritory" msprop:Generator_UserParentTable="DimSalesTerritory" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>