Поделиться через


Полная схема сопоставления AdventureWorks (модель EDM)

Эта схема на языке MSL сопоставляет программную модель объектов соответствующим таблицам в базы данных Adventureworks. Эта схема сопоставляет схемы, определенные в предыдущих разделах: Полная концептуальная схема AdventureWorks (модель EDM) и Полная схема хранения AdventureWorks (модель EDM).

Следующая схема была создана автоматически средством EdmGen.exe вместе с хранилищем и концептуальными схемами, как показано в разделе Полная модель AdventureWorks (модель EDM).

Следующая схема содержит все сопоставления, необходимые для использования типов Adventureworks и ассоциаций в языке C#.

<?xml version="1.0" encoding="utf-8"?>
<Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
  <EntityContainerMapping StorageEntityContainer="Production" CdmEntityContainer="AdventureWorksContext">
    <EntitySetMapping Name="AWBuildVersion" StoreEntitySet="AWBuildVersion" TypeName="AdventureWorks.AWBuildVersion">
      <ScalarProperty Name="SystemInformationID" ColumnName="SystemInformationID" />
      <ScalarProperty Name="Database_Version" ColumnName="Database Version" />
      <ScalarProperty Name="VersionDate" ColumnName="VersionDate" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="DatabaseLog" StoreEntitySet="DatabaseLog" TypeName="AdventureWorks.DatabaseLog">
      <ScalarProperty Name="DatabaseLogID" ColumnName="DatabaseLogID" />
      <ScalarProperty Name="PostTime" ColumnName="PostTime" />
      <ScalarProperty Name="DatabaseUser" ColumnName="DatabaseUser" />
      <ScalarProperty Name="Event" ColumnName="Event" />
      <ScalarProperty Name="Schema" ColumnName="Schema" />
      <ScalarProperty Name="Object" ColumnName="Object" />
      <ScalarProperty Name="TSQL" ColumnName="TSQL" />
      <ScalarProperty Name="XmlEvent" ColumnName="XmlEvent" />
    </EntitySetMapping>
    <EntitySetMapping Name="ErrorLog" StoreEntitySet="ErrorLog" TypeName="AdventureWorks.ErrorLog">
      <ScalarProperty Name="ErrorLogID" ColumnName="ErrorLogID" />
      <ScalarProperty Name="ErrorTime" ColumnName="ErrorTime" />
      <ScalarProperty Name="UserName" ColumnName="UserName" />
      <ScalarProperty Name="ErrorNumber" ColumnName="ErrorNumber" />
      <ScalarProperty Name="ErrorSeverity" ColumnName="ErrorSeverity" />
      <ScalarProperty Name="ErrorState" ColumnName="ErrorState" />
      <ScalarProperty Name="ErrorProcedure" ColumnName="ErrorProcedure" />
      <ScalarProperty Name="ErrorLine" ColumnName="ErrorLine" />
      <ScalarProperty Name="ErrorMessage" ColumnName="ErrorMessage" />
    </EntitySetMapping>
    <EntitySetMapping Name="Department" StoreEntitySet="Department" TypeName="AdventureWorks.Department">
      <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="GroupName" ColumnName="GroupName" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Employee" StoreEntitySet="Employee" TypeName="AdventureWorks.Employee">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="NationalIDNumber" ColumnName="NationalIDNumber" />
      <ScalarProperty Name="LoginID" ColumnName="LoginID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
      <ScalarProperty Name="MaritalStatus" ColumnName="MaritalStatus" />
      <ScalarProperty Name="Gender" ColumnName="Gender" />
      <ScalarProperty Name="HireDate" ColumnName="HireDate" />
      <ScalarProperty Name="SalariedFlag" ColumnName="SalariedFlag" />
      <ScalarProperty Name="VacationHours" ColumnName="VacationHours" />
      <ScalarProperty Name="SickLeaveHours" ColumnName="SickLeaveHours" />
      <ScalarProperty Name="CurrentFlag" ColumnName="CurrentFlag" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="EmployeeAddress" StoreEntitySet="EmployeeAddress" TypeName="AdventureWorks.EmployeeAddress">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="EmployeeDepartmentHistory" StoreEntitySet="EmployeeDepartmentHistory" TypeName="AdventureWorks.EmployeeDepartmentHistory">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
      <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="EmployeePayHistory" StoreEntitySet="EmployeePayHistory" TypeName="AdventureWorks.EmployeePayHistory">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="RateChangeDate" ColumnName="RateChangeDate" />
      <ScalarProperty Name="Rate" ColumnName="Rate" />
      <ScalarProperty Name="PayFrequency" ColumnName="PayFrequency" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="JobCandidate" StoreEntitySet="JobCandidate" TypeName="AdventureWorks.JobCandidate">
      <ScalarProperty Name="JobCandidateID" ColumnName="JobCandidateID" />
      <ScalarProperty Name="Resume" ColumnName="Resume" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesEmployee" StoreEntitySet="SalesEmployee" TypeName="AdventureWorks.SalesEmployee">
      <ScalarProperty Name="ID" ColumnName="ID" />
      <ScalarProperty Name="ExpenseAcctNumber" ColumnName="ExpenseAcctNumber" />
      <ScalarProperty Name="CarLicenseNumber" ColumnName="CarLicenseNumber" />
    </EntitySetMapping>
    <EntitySetMapping Name="Shift" StoreEntitySet="Shift" TypeName="AdventureWorks.Shift">
      <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="StartTime" ColumnName="StartTime" />
      <ScalarProperty Name="EndTime" ColumnName="EndTime" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Address" StoreEntitySet="Address" TypeName="AdventureWorks.Address">
      <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="AddressType" StoreEntitySet="AddressType" TypeName="AdventureWorks.AddressType">
      <ScalarProperty Name="AddressTypeID" ColumnName="AddressTypeID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Contact" StoreEntitySet="Contact" TypeName="AdventureWorks.Contact">
      <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      <ScalarProperty Name="NameStyle" ColumnName="NameStyle" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="PasswordHash" ColumnName="PasswordHash" />
      <ScalarProperty Name="PasswordSalt" ColumnName="PasswordSalt" />
      <ScalarProperty Name="AdditionalContactInfo" ColumnName="AdditionalContactInfo" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ContactType" StoreEntitySet="ContactType" TypeName="AdventureWorks.ContactType">
      <ScalarProperty Name="ContactTypeID" ColumnName="ContactTypeID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="CountryRegion" StoreEntitySet="CountryRegion" TypeName="AdventureWorks.CountryRegion">
      <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="StateProvince" StoreEntitySet="StateProvince" TypeName="AdventureWorks.StateProvince">
      <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      <ScalarProperty Name="StateProvinceCode" ColumnName="StateProvinceCode" />
      <ScalarProperty Name="IsOnlyStateProvinceFlag" ColumnName="IsOnlyStateProvinceFlag" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="BillOfMaterials" StoreEntitySet="BillOfMaterials" TypeName="AdventureWorks.BillOfMaterials">
      <ScalarProperty Name="BillOfMaterialsID" ColumnName="BillOfMaterialsID" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="BOMLevel" ColumnName="BOMLevel" />
      <ScalarProperty Name="PerAssemblyQty" ColumnName="PerAssemblyQty" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Culture" StoreEntitySet="Culture" TypeName="AdventureWorks.Culture">
      <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Document" StoreEntitySet="Document" TypeName="AdventureWorks.Document">
      <ScalarProperty Name="DocumentID" ColumnName="DocumentID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FileName" ColumnName="FileName" />
      <ScalarProperty Name="FileExtension" ColumnName="FileExtension" />
      <ScalarProperty Name="Revision" ColumnName="Revision" />
      <ScalarProperty Name="ChangeNumber" ColumnName="ChangeNumber" />
      <ScalarProperty Name="Status" ColumnName="Status" />
      <ScalarProperty Name="DocumentSummary" ColumnName="DocumentSummary" />
      <ScalarProperty Name="Document1" ColumnName="Document" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Illustration" StoreEntitySet="Illustration" TypeName="AdventureWorks.Illustration">
      <ScalarProperty Name="IllustrationID" ColumnName="IllustrationID" />
      <ScalarProperty Name="Diagram" ColumnName="Diagram" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Location" StoreEntitySet="Location" TypeName="AdventureWorks.Location">
      <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="CostRate" ColumnName="CostRate" />
      <ScalarProperty Name="Availability" ColumnName="Availability" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Product" StoreEntitySet="Product" TypeName="AdventureWorks.Product">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ProductNumber" ColumnName="ProductNumber" />
      <ScalarProperty Name="MakeFlag" ColumnName="MakeFlag" />
      <ScalarProperty Name="FinishedGoodsFlag" ColumnName="FinishedGoodsFlag" />
      <ScalarProperty Name="Color" ColumnName="Color" />
      <ScalarProperty Name="SafetyStockLevel" ColumnName="SafetyStockLevel" />
      <ScalarProperty Name="ReorderPoint" ColumnName="ReorderPoint" />
      <ScalarProperty Name="StandardCost" ColumnName="StandardCost" />
      <ScalarProperty Name="ListPrice" ColumnName="ListPrice" />
      <ScalarProperty Name="Size" ColumnName="Size" />
      <ScalarProperty Name="Weight" ColumnName="Weight" />
      <ScalarProperty Name="DaysToManufacture" ColumnName="DaysToManufacture" />
      <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
      <ScalarProperty Name="Class" ColumnName="Class" />
      <ScalarProperty Name="Style" ColumnName="Style" />
      <ScalarProperty Name="SellStartDate" ColumnName="SellStartDate" />
      <ScalarProperty Name="SellEndDate" ColumnName="SellEndDate" />
      <ScalarProperty Name="DiscontinuedDate" ColumnName="DiscontinuedDate" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductCategory" StoreEntitySet="ProductCategory" TypeName="AdventureWorks.ProductCategory">
      <ScalarProperty Name="ProductCategoryID" ColumnName="ProductCategoryID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductCostHistory" StoreEntitySet="ProductCostHistory" TypeName="AdventureWorks.ProductCostHistory">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="StandardCost" ColumnName="StandardCost" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductDescription" StoreEntitySet="ProductDescription" TypeName="AdventureWorks.ProductDescription">
      <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
      <ScalarProperty Name="Description" ColumnName="Description" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductDocument" StoreEntitySet="ProductDocument" TypeName="AdventureWorks.ProductDocument">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="DocumentID" ColumnName="DocumentID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductInventory" StoreEntitySet="ProductInventory" TypeName="AdventureWorks.ProductInventory">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      <ScalarProperty Name="Shelf" ColumnName="Shelf" />
      <ScalarProperty Name="Bin" ColumnName="Bin" />
      <ScalarProperty Name="Quantity" ColumnName="Quantity" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductListPriceHistory" StoreEntitySet="ProductListPriceHistory" TypeName="AdventureWorks.ProductListPriceHistory">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="ListPrice" ColumnName="ListPrice" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductModel" StoreEntitySet="ProductModel" TypeName="AdventureWorks.ProductModel">
      <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="CatalogDescription" ColumnName="CatalogDescription" />
      <ScalarProperty Name="Instructions" ColumnName="Instructions" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductModelIllustration" StoreEntitySet="ProductModelIllustration" TypeName="AdventureWorks.ProductModelIllustration">
      <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      <ScalarProperty Name="IllustrationID" ColumnName="IllustrationID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductModelProductDescriptionCulture" StoreEntitySet="ProductModelProductDescriptionCulture" TypeName="AdventureWorks.ProductModelProductDescriptionCulture">
      <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
      <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductPhoto" StoreEntitySet="ProductPhoto" TypeName="AdventureWorks.ProductPhoto">
      <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      <ScalarProperty Name="ThumbNailPhoto" ColumnName="ThumbNailPhoto" />
      <ScalarProperty Name="ThumbnailPhotoFileName" ColumnName="ThumbnailPhotoFileName" />
      <ScalarProperty Name="LargePhoto" ColumnName="LargePhoto" />
      <ScalarProperty Name="LargePhotoFileName" ColumnName="LargePhotoFileName" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductProductPhoto" StoreEntitySet="ProductProductPhoto" TypeName="AdventureWorks.ProductProductPhoto">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      <ScalarProperty Name="Primary" ColumnName="Primary" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductReview" StoreEntitySet="ProductReview" TypeName="AdventureWorks.ProductReview">
      <ScalarProperty Name="ProductReviewID" ColumnName="ProductReviewID" />
      <ScalarProperty Name="ReviewerName" ColumnName="ReviewerName" />
      <ScalarProperty Name="ReviewDate" ColumnName="ReviewDate" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="Rating" ColumnName="Rating" />
      <ScalarProperty Name="Comments" ColumnName="Comments" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductSubcategory" StoreEntitySet="ProductSubcategory" TypeName="AdventureWorks.ProductSubcategory">
      <ScalarProperty Name="ProductSubcategoryID" ColumnName="ProductSubcategoryID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ScrapReason" StoreEntitySet="ScrapReason" TypeName="AdventureWorks.ScrapReason">
      <ScalarProperty Name="ScrapReasonID" ColumnName="ScrapReasonID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="TransactionHistory" StoreEntitySet="TransactionHistory" TypeName="AdventureWorks.TransactionHistory">
      <ScalarProperty Name="TransactionID" ColumnName="TransactionID" />
      <ScalarProperty Name="ReferenceOrderID" ColumnName="ReferenceOrderID" />
      <ScalarProperty Name="ReferenceOrderLineID" ColumnName="ReferenceOrderLineID" />
      <ScalarProperty Name="TransactionDate" ColumnName="TransactionDate" />
      <ScalarProperty Name="TransactionType" ColumnName="TransactionType" />
      <ScalarProperty Name="Quantity" ColumnName="Quantity" />
      <ScalarProperty Name="ActualCost" ColumnName="ActualCost" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="TransactionHistoryArchive" StoreEntitySet="TransactionHistoryArchive" TypeName="AdventureWorks.TransactionHistoryArchive">
      <ScalarProperty Name="TransactionID" ColumnName="TransactionID" />
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="ReferenceOrderID" ColumnName="ReferenceOrderID" />
      <ScalarProperty Name="ReferenceOrderLineID" ColumnName="ReferenceOrderLineID" />
      <ScalarProperty Name="TransactionDate" ColumnName="TransactionDate" />
      <ScalarProperty Name="TransactionType" ColumnName="TransactionType" />
      <ScalarProperty Name="Quantity" ColumnName="Quantity" />
      <ScalarProperty Name="ActualCost" ColumnName="ActualCost" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="UnitMeasure" StoreEntitySet="UnitMeasure" TypeName="AdventureWorks.UnitMeasure">
      <ScalarProperty Name="UnitMeasureCode" ColumnName="UnitMeasureCode" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="WorkOrder" StoreEntitySet="WorkOrder" TypeName="AdventureWorks.WorkOrder">
      <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
      <ScalarProperty Name="OrderQty" ColumnName="OrderQty" />
      <ScalarProperty Name="StockedQty" ColumnName="StockedQty" />
      <ScalarProperty Name="ScrappedQty" ColumnName="ScrappedQty" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="DueDate" ColumnName="DueDate" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="WorkOrderRouting" StoreEntitySet="WorkOrderRouting" TypeName="AdventureWorks.WorkOrderRouting">
      <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="OperationSequence" ColumnName="OperationSequence" />
      <ScalarProperty Name="ScheduledStartDate" ColumnName="ScheduledStartDate" />
      <ScalarProperty Name="ScheduledEndDate" ColumnName="ScheduledEndDate" />
      <ScalarProperty Name="ActualStartDate" ColumnName="ActualStartDate" />
      <ScalarProperty Name="ActualEndDate" ColumnName="ActualEndDate" />
      <ScalarProperty Name="ActualResourceHrs" ColumnName="ActualResourceHrs" />
      <ScalarProperty Name="PlannedCost" ColumnName="PlannedCost" />
      <ScalarProperty Name="ActualCost" ColumnName="ActualCost" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ProductVendor" StoreEntitySet="ProductVendor" TypeName="AdventureWorks.ProductVendor">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      <ScalarProperty Name="AverageLeadTime" ColumnName="AverageLeadTime" />
      <ScalarProperty Name="StandardPrice" ColumnName="StandardPrice" />
      <ScalarProperty Name="LastReceiptCost" ColumnName="LastReceiptCost" />
      <ScalarProperty Name="LastReceiptDate" ColumnName="LastReceiptDate" />
      <ScalarProperty Name="MinOrderQty" ColumnName="MinOrderQty" />
      <ScalarProperty Name="MaxOrderQty" ColumnName="MaxOrderQty" />
      <ScalarProperty Name="OnOrderQty" ColumnName="OnOrderQty" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="PurchaseOrderDetail" StoreEntitySet="PurchaseOrderDetail" TypeName="AdventureWorks.PurchaseOrderDetail">
      <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      <ScalarProperty Name="PurchaseOrderDetailID" ColumnName="PurchaseOrderDetailID" />
      <ScalarProperty Name="DueDate" ColumnName="DueDate" />
      <ScalarProperty Name="OrderQty" ColumnName="OrderQty" />
      <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
      <ScalarProperty Name="LineTotal" ColumnName="LineTotal" />
      <ScalarProperty Name="ReceivedQty" ColumnName="ReceivedQty" />
      <ScalarProperty Name="RejectedQty" ColumnName="RejectedQty" />
      <ScalarProperty Name="StockedQty" ColumnName="StockedQty" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="PurchaseOrderHeader" StoreEntitySet="PurchaseOrderHeader" TypeName="AdventureWorks.PurchaseOrderHeader">
      <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      <ScalarProperty Name="RevisionNumber" ColumnName="RevisionNumber" />
      <ScalarProperty Name="Status" ColumnName="Status" />
      <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
      <ScalarProperty Name="ShipDate" ColumnName="ShipDate" />
      <ScalarProperty Name="SubTotal" ColumnName="SubTotal" />
      <ScalarProperty Name="TaxAmt" ColumnName="TaxAmt" />
      <ScalarProperty Name="Freight" ColumnName="Freight" />
      <ScalarProperty Name="TotalDue" ColumnName="TotalDue" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ShipMethod" StoreEntitySet="ShipMethod" TypeName="AdventureWorks.ShipMethod">
      <ScalarProperty Name="ShipMethodID" ColumnName="ShipMethodID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ShipBase" ColumnName="ShipBase" />
      <ScalarProperty Name="ShipRate" ColumnName="ShipRate" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Vendor" StoreEntitySet="Vendor" TypeName="AdventureWorks.Vendor">
      <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="CreditRating" ColumnName="CreditRating" />
      <ScalarProperty Name="PreferredVendorStatus" ColumnName="PreferredVendorStatus" />
      <ScalarProperty Name="ActiveFlag" ColumnName="ActiveFlag" />
      <ScalarProperty Name="PurchasingWebServiceURL" ColumnName="PurchasingWebServiceURL" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="VendorAddress" StoreEntitySet="VendorAddress" TypeName="AdventureWorks.VendorAddress">
      <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="VendorContact" StoreEntitySet="VendorContact" TypeName="AdventureWorks.VendorContact">
      <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ContactCreditCard" StoreEntitySet="ContactCreditCard" TypeName="AdventureWorks.ContactCreditCard">
      <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="CountryRegionCurrency" StoreEntitySet="CountryRegionCurrency" TypeName="AdventureWorks.CountryRegionCurrency">
      <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="CreditCard" StoreEntitySet="CreditCard" TypeName="AdventureWorks.CreditCard">
      <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      <ScalarProperty Name="CardType" ColumnName="CardType" />
      <ScalarProperty Name="CardNumber" ColumnName="CardNumber" />
      <ScalarProperty Name="ExpMonth" ColumnName="ExpMonth" />
      <ScalarProperty Name="ExpYear" ColumnName="ExpYear" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Currency" StoreEntitySet="Currency" TypeName="AdventureWorks.Currency">
      <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="CurrencyRate" StoreEntitySet="CurrencyRate" TypeName="AdventureWorks.CurrencyRate">
      <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
      <ScalarProperty Name="CurrencyRateDate" ColumnName="CurrencyRateDate" />
      <ScalarProperty Name="AverageRate" ColumnName="AverageRate" />
      <ScalarProperty Name="EndOfDayRate" ColumnName="EndOfDayRate" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Customer" StoreEntitySet="Customer" TypeName="AdventureWorks.Customer">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" />
      <ScalarProperty Name="CustomerType" ColumnName="CustomerType" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="CustomerAddress" StoreEntitySet="CustomerAddress" TypeName="AdventureWorks.CustomerAddress">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Individual" StoreEntitySet="Individual" TypeName="AdventureWorks.Individual">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="Demographics" ColumnName="Demographics" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesOrderDetail" StoreEntitySet="SalesOrderDetail" TypeName="AdventureWorks.SalesOrderDetail">
      <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      <ScalarProperty Name="SalesOrderDetailID" ColumnName="SalesOrderDetailID" />
      <ScalarProperty Name="CarrierTrackingNumber" ColumnName="CarrierTrackingNumber" />
      <ScalarProperty Name="OrderQty" ColumnName="OrderQty" />
      <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
      <ScalarProperty Name="UnitPriceDiscount" ColumnName="UnitPriceDiscount" />
      <ScalarProperty Name="LineTotal" ColumnName="LineTotal" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesOrderHeader" StoreEntitySet="SalesOrderHeader" TypeName="AdventureWorks.SalesOrderHeader">
      <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      <ScalarProperty Name="RevisionNumber" ColumnName="RevisionNumber" />
      <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
      <ScalarProperty Name="DueDate" ColumnName="DueDate" />
      <ScalarProperty Name="ShipDate" ColumnName="ShipDate" />
      <ScalarProperty Name="Status" ColumnName="Status" />
      <ScalarProperty Name="OnlineOrderFlag" ColumnName="OnlineOrderFlag" />
      <ScalarProperty Name="SalesOrderNumber" ColumnName="SalesOrderNumber" />
      <ScalarProperty Name="PurchaseOrderNumber" ColumnName="PurchaseOrderNumber" />
      <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" />
      <ScalarProperty Name="CreditCardApprovalCode" ColumnName="CreditCardApprovalCode" />
      <ScalarProperty Name="SubTotal" ColumnName="SubTotal" />
      <ScalarProperty Name="TaxAmt" ColumnName="TaxAmt" />
      <ScalarProperty Name="Freight" ColumnName="Freight" />
      <ScalarProperty Name="TotalDue" ColumnName="TotalDue" />
      <ScalarProperty Name="Comment" ColumnName="Comment" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesOrderHeaderSalesReason" StoreEntitySet="SalesOrderHeaderSalesReason" TypeName="AdventureWorks.SalesOrderHeaderSalesReason">
      <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      <ScalarProperty Name="SalesReasonID" ColumnName="SalesReasonID" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesPerson" StoreEntitySet="SalesPerson" TypeName="AdventureWorks.SalesPerson">
      <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      <ScalarProperty Name="SalesQuota" ColumnName="SalesQuota" />
      <ScalarProperty Name="Bonus" ColumnName="Bonus" />
      <ScalarProperty Name="CommissionPct" ColumnName="CommissionPct" />
      <ScalarProperty Name="SalesYTD" ColumnName="SalesYTD" />
      <ScalarProperty Name="SalesLastYear" ColumnName="SalesLastYear" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesPersonQuotaHistory" StoreEntitySet="SalesPersonQuotaHistory" TypeName="AdventureWorks.SalesPersonQuotaHistory">
      <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      <ScalarProperty Name="QuotaDate" ColumnName="QuotaDate" />
      <ScalarProperty Name="SalesQuota" ColumnName="SalesQuota" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesReason" StoreEntitySet="SalesReason" TypeName="AdventureWorks.SalesReason">
      <ScalarProperty Name="SalesReasonID" ColumnName="SalesReasonID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ReasonType" ColumnName="ReasonType" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesTaxRate" StoreEntitySet="SalesTaxRate" TypeName="AdventureWorks.SalesTaxRate">
      <ScalarProperty Name="SalesTaxRateID" ColumnName="SalesTaxRateID" />
      <ScalarProperty Name="TaxType" ColumnName="TaxType" />
      <ScalarProperty Name="TaxRate" ColumnName="TaxRate" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesTerritory" StoreEntitySet="SalesTerritory" TypeName="AdventureWorks.SalesTerritory">
      <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      <ScalarProperty Name="Group" ColumnName="Group" />
      <ScalarProperty Name="SalesYTD" ColumnName="SalesYTD" />
      <ScalarProperty Name="SalesLastYear" ColumnName="SalesLastYear" />
      <ScalarProperty Name="CostYTD" ColumnName="CostYTD" />
      <ScalarProperty Name="CostLastYear" ColumnName="CostLastYear" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SalesTerritoryHistory" StoreEntitySet="SalesTerritoryHistory" TypeName="AdventureWorks.SalesTerritoryHistory">
      <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="ShoppingCartItem" StoreEntitySet="ShoppingCartItem" TypeName="AdventureWorks.ShoppingCartItem">
      <ScalarProperty Name="ShoppingCartItemID" ColumnName="ShoppingCartItemID" />
      <ScalarProperty Name="ShoppingCartID" ColumnName="ShoppingCartID" />
      <ScalarProperty Name="Quantity" ColumnName="Quantity" />
      <ScalarProperty Name="DateCreated" ColumnName="DateCreated" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SpecialOffer" StoreEntitySet="SpecialOffer" TypeName="AdventureWorks.SpecialOffer">
      <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
      <ScalarProperty Name="Description" ColumnName="Description" />
      <ScalarProperty Name="DiscountPct" ColumnName="DiscountPct" />
      <ScalarProperty Name="Type" ColumnName="Type" />
      <ScalarProperty Name="Category" ColumnName="Category" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
      <ScalarProperty Name="MinQty" ColumnName="MinQty" />
      <ScalarProperty Name="MaxQty" ColumnName="MaxQty" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="SpecialOfferProduct" StoreEntitySet="SpecialOfferProduct" TypeName="AdventureWorks.SpecialOfferProduct">
      <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="Store" StoreEntitySet="Store" TypeName="AdventureWorks.Store">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="Demographics" ColumnName="Demographics" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="StoreContact" StoreEntitySet="StoreContact" TypeName="AdventureWorks.StoreContact">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vEmployee" StoreEntitySet="vEmployee" TypeName="AdventureWorks.vEmployee">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="JobTitle" ColumnName="JobTitle" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
      <ScalarProperty Name="AdditionalContactInfo" ColumnName="AdditionalContactInfo" />
    </EntitySetMapping>
    <EntitySetMapping Name="vEmployeeDepartment" StoreEntitySet="vEmployeeDepartment" TypeName="AdventureWorks.vEmployeeDepartment">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="JobTitle" ColumnName="JobTitle" />
      <ScalarProperty Name="Department" ColumnName="Department" />
      <ScalarProperty Name="GroupName" ColumnName="GroupName" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vEmployeeDepartmentHistory" StoreEntitySet="vEmployeeDepartmentHistory" TypeName="AdventureWorks.vEmployeeDepartmentHistory">
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="Shift" ColumnName="Shift" />
      <ScalarProperty Name="Department" ColumnName="Department" />
      <ScalarProperty Name="GroupName" ColumnName="GroupName" />
      <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      <ScalarProperty Name="EndDate" ColumnName="EndDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vJobCandidate" StoreEntitySet="vJobCandidate" TypeName="AdventureWorks.vJobCandidate">
      <ScalarProperty Name="JobCandidateID" ColumnName="JobCandidateID" />
      <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      <ScalarProperty Name="Name_Prefix" ColumnName="Name.Prefix" />
      <ScalarProperty Name="Name_First" ColumnName="Name.First" />
      <ScalarProperty Name="Name_Middle" ColumnName="Name.Middle" />
      <ScalarProperty Name="Name_Last" ColumnName="Name.Last" />
      <ScalarProperty Name="Name_Suffix" ColumnName="Name.Suffix" />
      <ScalarProperty Name="Skills" ColumnName="Skills" />
      <ScalarProperty Name="Addr_Type" ColumnName="Addr.Type" />
      <ScalarProperty Name="Addr_Loc_CountryRegion" ColumnName="Addr.Loc.CountryRegion" />
      <ScalarProperty Name="Addr_Loc_State" ColumnName="Addr.Loc.State" />
      <ScalarProperty Name="Addr_Loc_City" ColumnName="Addr.Loc.City" />
      <ScalarProperty Name="Addr_PostalCode" ColumnName="Addr.PostalCode" />
      <ScalarProperty Name="EMail" ColumnName="EMail" />
      <ScalarProperty Name="WebSite" ColumnName="WebSite" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vJobCandidateEducation" StoreEntitySet="vJobCandidateEducation" TypeName="AdventureWorks.vJobCandidateEducation">
      <ScalarProperty Name="JobCandidateID" ColumnName="JobCandidateID" />
      <ScalarProperty Name="Edu_Level" ColumnName="Edu.Level" />
      <ScalarProperty Name="Edu_StartDate" ColumnName="Edu.StartDate" />
      <ScalarProperty Name="Edu_EndDate" ColumnName="Edu.EndDate" />
      <ScalarProperty Name="Edu_Degree" ColumnName="Edu.Degree" />
      <ScalarProperty Name="Edu_Major" ColumnName="Edu.Major" />
      <ScalarProperty Name="Edu_Minor" ColumnName="Edu.Minor" />
      <ScalarProperty Name="Edu_GPA" ColumnName="Edu.GPA" />
      <ScalarProperty Name="Edu_GPAScale" ColumnName="Edu.GPAScale" />
      <ScalarProperty Name="Edu_School" ColumnName="Edu.School" />
      <ScalarProperty Name="Edu_Loc_CountryRegion" ColumnName="Edu.Loc.CountryRegion" />
      <ScalarProperty Name="Edu_Loc_State" ColumnName="Edu.Loc.State" />
      <ScalarProperty Name="Edu_Loc_City" ColumnName="Edu.Loc.City" />
    </EntitySetMapping>
    <EntitySetMapping Name="vJobCandidateEmployment" StoreEntitySet="vJobCandidateEmployment" TypeName="AdventureWorks.vJobCandidateEmployment">
      <ScalarProperty Name="JobCandidateID" ColumnName="JobCandidateID" />
      <ScalarProperty Name="Emp_StartDate" ColumnName="Emp.StartDate" />
      <ScalarProperty Name="Emp_EndDate" ColumnName="Emp.EndDate" />
      <ScalarProperty Name="Emp_OrgName" ColumnName="Emp.OrgName" />
      <ScalarProperty Name="Emp_JobTitle" ColumnName="Emp.JobTitle" />
      <ScalarProperty Name="Emp_Responsibility" ColumnName="Emp.Responsibility" />
      <ScalarProperty Name="Emp_FunctionCategory" ColumnName="Emp.FunctionCategory" />
      <ScalarProperty Name="Emp_IndustryCategory" ColumnName="Emp.IndustryCategory" />
      <ScalarProperty Name="Emp_Loc_CountryRegion" ColumnName="Emp.Loc.CountryRegion" />
      <ScalarProperty Name="Emp_Loc_State" ColumnName="Emp.Loc.State" />
      <ScalarProperty Name="Emp_Loc_City" ColumnName="Emp.Loc.City" />
    </EntitySetMapping>
    <EntitySetMapping Name="vAdditionalContactInfo" StoreEntitySet="vAdditionalContactInfo" TypeName="AdventureWorks.vAdditionalContactInfo">
      <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="TelephoneNumber" ColumnName="TelephoneNumber" />
      <ScalarProperty Name="TelephoneSpecialInstructions" ColumnName="TelephoneSpecialInstructions" />
      <ScalarProperty Name="Street" ColumnName="Street" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvince" ColumnName="StateProvince" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegion" ColumnName="CountryRegion" />
      <ScalarProperty Name="HomeAddressSpecialInstructions" ColumnName="HomeAddressSpecialInstructions" />
      <ScalarProperty Name="EMailAddress" ColumnName="EMailAddress" />
      <ScalarProperty Name="EMailSpecialInstructions" ColumnName="EMailSpecialInstructions" />
      <ScalarProperty Name="EMailTelephoneNumber" ColumnName="EMailTelephoneNumber" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vStateProvinceCountryRegion" StoreEntitySet="vStateProvinceCountryRegion" TypeName="AdventureWorks.vStateProvinceCountryRegion">
      <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      <ScalarProperty Name="StateProvinceCode" ColumnName="StateProvinceCode" />
      <ScalarProperty Name="IsOnlyStateProvinceFlag" ColumnName="IsOnlyStateProvinceFlag" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
    </EntitySetMapping>
    <EntitySetMapping Name="vProductAndDescription" StoreEntitySet="vProductAndDescription" TypeName="AdventureWorks.vProductAndDescription">
      <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ProductModel" ColumnName="ProductModel" />
      <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      <ScalarProperty Name="Description" ColumnName="Description" />
    </EntitySetMapping>
    <EntitySetMapping Name="vProductModelCatalogDescription" StoreEntitySet="vProductModelCatalogDescription" TypeName="AdventureWorks.vProductModelCatalogDescription">
      <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="Summary" ColumnName="Summary" />
      <ScalarProperty Name="Manufacturer" ColumnName="Manufacturer" />
      <ScalarProperty Name="Copyright" ColumnName="Copyright" />
      <ScalarProperty Name="ProductURL" ColumnName="ProductURL" />
      <ScalarProperty Name="WarrantyPeriod" ColumnName="WarrantyPeriod" />
      <ScalarProperty Name="WarrantyDescription" ColumnName="WarrantyDescription" />
      <ScalarProperty Name="NoOfYears" ColumnName="NoOfYears" />
      <ScalarProperty Name="MaintenanceDescription" ColumnName="MaintenanceDescription" />
      <ScalarProperty Name="Wheel" ColumnName="Wheel" />
      <ScalarProperty Name="Saddle" ColumnName="Saddle" />
      <ScalarProperty Name="Pedal" ColumnName="Pedal" />
      <ScalarProperty Name="BikeFrame" ColumnName="BikeFrame" />
      <ScalarProperty Name="Crankset" ColumnName="Crankset" />
      <ScalarProperty Name="PictureAngle" ColumnName="PictureAngle" />
      <ScalarProperty Name="PictureSize" ColumnName="PictureSize" />
      <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      <ScalarProperty Name="Material" ColumnName="Material" />
      <ScalarProperty Name="Color" ColumnName="Color" />
      <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
      <ScalarProperty Name="Style" ColumnName="Style" />
      <ScalarProperty Name="RiderExperience" ColumnName="RiderExperience" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vProductModelInstructions" StoreEntitySet="vProductModelInstructions" TypeName="AdventureWorks.vProductModelInstructions">
      <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="Instructions" ColumnName="Instructions" />
      <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      <ScalarProperty Name="SetupHours" ColumnName="SetupHours" />
      <ScalarProperty Name="MachineHours" ColumnName="MachineHours" />
      <ScalarProperty Name="LaborHours" ColumnName="LaborHours" />
      <ScalarProperty Name="LotSize" ColumnName="LotSize" />
      <ScalarProperty Name="Step" ColumnName="Step" />
      <ScalarProperty Name="rowguid" ColumnName="rowguid" />
      <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
    </EntitySetMapping>
    <EntitySetMapping Name="vVendor" StoreEntitySet="vVendor" TypeName="AdventureWorks.vVendor">
      <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ContactType" ColumnName="ContactType" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
    </EntitySetMapping>
    <EntitySetMapping Name="vIndividualCustomer" StoreEntitySet="vIndividualCustomer" TypeName="AdventureWorks.vIndividualCustomer">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="AddressType" ColumnName="AddressType" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
      <ScalarProperty Name="Demographics" ColumnName="Demographics" />
    </EntitySetMapping>
    <EntitySetMapping Name="vIndividualDemographics" StoreEntitySet="vIndividualDemographics" TypeName="AdventureWorks.vIndividualDemographics">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="TotalPurchaseYTD" ColumnName="TotalPurchaseYTD" />
      <ScalarProperty Name="DateFirstPurchase" ColumnName="DateFirstPurchase" />
      <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
      <ScalarProperty Name="MaritalStatus" ColumnName="MaritalStatus" />
      <ScalarProperty Name="YearlyIncome" ColumnName="YearlyIncome" />
      <ScalarProperty Name="Gender" ColumnName="Gender" />
      <ScalarProperty Name="TotalChildren" ColumnName="TotalChildren" />
      <ScalarProperty Name="NumberChildrenAtHome" ColumnName="NumberChildrenAtHome" />
      <ScalarProperty Name="Education" ColumnName="Education" />
      <ScalarProperty Name="Occupation" ColumnName="Occupation" />
      <ScalarProperty Name="HomeOwnerFlag" ColumnName="HomeOwnerFlag" />
      <ScalarProperty Name="NumberCarsOwned" ColumnName="NumberCarsOwned" />
    </EntitySetMapping>
    <EntitySetMapping Name="vSalesPerson" StoreEntitySet="vSalesPerson" TypeName="AdventureWorks.vSalesPerson">
      <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="JobTitle" ColumnName="JobTitle" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
      <ScalarProperty Name="TerritoryName" ColumnName="TerritoryName" />
      <ScalarProperty Name="TerritoryGroup" ColumnName="TerritoryGroup" />
      <ScalarProperty Name="SalesQuota" ColumnName="SalesQuota" />
      <ScalarProperty Name="SalesYTD" ColumnName="SalesYTD" />
      <ScalarProperty Name="SalesLastYear" ColumnName="SalesLastYear" />
    </EntitySetMapping>
    <EntitySetMapping Name="vSalesPersonSalesByFiscalYears" StoreEntitySet="vSalesPersonSalesByFiscalYears" TypeName="AdventureWorks.vSalesPersonSalesByFiscalYears">
      <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      <ScalarProperty Name="FullName" ColumnName="FullName" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="SalesTerritory" ColumnName="SalesTerritory" />
      <ScalarProperty Name="C2002" ColumnName="2002" />
      <ScalarProperty Name="C2003" ColumnName="2003" />
      <ScalarProperty Name="C2004" ColumnName="2004" />
    </EntitySetMapping>
    <EntitySetMapping Name="vStoreWithDemographics" StoreEntitySet="vStoreWithDemographics" TypeName="AdventureWorks.vStoreWithDemographics">
      <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      <ScalarProperty Name="Name" ColumnName="Name" />
      <ScalarProperty Name="ContactType" ColumnName="ContactType" />
      <ScalarProperty Name="Title" ColumnName="Title" />
      <ScalarProperty Name="FirstName" ColumnName="FirstName" />
      <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
      <ScalarProperty Name="LastName" ColumnName="LastName" />
      <ScalarProperty Name="Suffix" ColumnName="Suffix" />
      <ScalarProperty Name="Phone" ColumnName="Phone" />
      <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
      <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
      <ScalarProperty Name="AddressType" ColumnName="AddressType" />
      <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
      <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
      <ScalarProperty Name="City" ColumnName="City" />
      <ScalarProperty Name="StateProvinceName" ColumnName="StateProvinceName" />
      <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
      <ScalarProperty Name="CountryRegionName" ColumnName="CountryRegionName" />
      <ScalarProperty Name="AnnualSales" ColumnName="AnnualSales" />
      <ScalarProperty Name="AnnualRevenue" ColumnName="AnnualRevenue" />
      <ScalarProperty Name="BankName" ColumnName="BankName" />
      <ScalarProperty Name="BusinessType" ColumnName="BusinessType" />
      <ScalarProperty Name="YearOpened" ColumnName="YearOpened" />
      <ScalarProperty Name="Specialty" ColumnName="Specialty" />
      <ScalarProperty Name="SquareFeet" ColumnName="SquareFeet" />
      <ScalarProperty Name="Brands" ColumnName="Brands" />
      <ScalarProperty Name="Internet" ColumnName="Internet" />
      <ScalarProperty Name="NumberEmployees" ColumnName="NumberEmployees" />
    </EntitySetMapping>
    <AssociationSetMapping Name="FK_EmployeeDepartmentHistory_Department_DepartmentID" TypeName="AdventureWorks.FK_EmployeeDepartmentHistory_Department_DepartmentID" StoreEntitySet="EmployeeDepartmentHistory">
      <EndProperty Name="Department">
        <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
      </EndProperty>
      <EndProperty Name="EmployeeDepartmentHistory">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
        <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Employee_Contact_ContactID" TypeName="AdventureWorks.FK_Employee_Contact_ContactID" StoreEntitySet="Employee">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Employee_Employee_ManagerID" TypeName="AdventureWorks.FK_Employee_Employee_ManagerID" StoreEntitySet="Employee">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="ManagerID" />
      </EndProperty>
      <EndProperty Name="Employee1">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <Condition ColumnName="ManagerID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_EmployeeAddress_Employee_EmployeeID" TypeName="AdventureWorks.FK_EmployeeAddress_Employee_EmployeeID" StoreEntitySet="EmployeeAddress">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <EndProperty Name="EmployeeAddress">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_EmployeeDepartmentHistory_Employee_EmployeeID" TypeName="AdventureWorks.FK_EmployeeDepartmentHistory_Employee_EmployeeID" StoreEntitySet="EmployeeDepartmentHistory">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <EndProperty Name="EmployeeDepartmentHistory">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
        <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_EmployeePayHistory_Employee_EmployeeID" TypeName="AdventureWorks.FK_EmployeePayHistory_Employee_EmployeeID" StoreEntitySet="EmployeePayHistory">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <EndProperty Name="EmployeePayHistory">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="RateChangeDate" ColumnName="RateChangeDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_JobCandidate_Employee_EmployeeID" TypeName="AdventureWorks.FK_JobCandidate_Employee_EmployeeID" StoreEntitySet="JobCandidate">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <EndProperty Name="JobCandidate">
        <ScalarProperty Name="JobCandidateID" ColumnName="JobCandidateID" />
      </EndProperty>
      <Condition ColumnName="EmployeeID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_PurchaseOrderHeader_Employee_EmployeeID" TypeName="AdventureWorks.FK_PurchaseOrderHeader_Employee_EmployeeID" StoreEntitySet="PurchaseOrderHeader">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
      </EndProperty>
      <EndProperty Name="PurchaseOrderHeader">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesPerson_Employee_SalesPersonID" TypeName="AdventureWorks.FK_SalesPerson_Employee_SalesPersonID" StoreEntitySet="SalesPerson">
      <EndProperty Name="Employee">
        <ScalarProperty Name="EmployeeID" ColumnName="SalesPersonID" />
      </EndProperty>
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_EmployeeAddress_Address_AddressID" TypeName="AdventureWorks.FK_EmployeeAddress_Address_AddressID" StoreEntitySet="EmployeeAddress">
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
      <EndProperty Name="EmployeeAddress">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_EmployeeDepartmentHistory_Shift_ShiftID" TypeName="AdventureWorks.FK_EmployeeDepartmentHistory_Shift_ShiftID" StoreEntitySet="EmployeeDepartmentHistory">
      <EndProperty Name="Shift">
        <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
      </EndProperty>
      <EndProperty Name="EmployeeDepartmentHistory">
        <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
        <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
        <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Address_StateProvince_StateProvinceID" TypeName="AdventureWorks.FK_Address_StateProvince_StateProvinceID" StoreEntitySet="Address">
      <EndProperty Name="StateProvince">
        <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      </EndProperty>
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CustomerAddress_Address_AddressID" TypeName="AdventureWorks.FK_CustomerAddress_Address_AddressID" StoreEntitySet="CustomerAddress">
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
      <EndProperty Name="CustomerAddress">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_Address_BillToAddressID" TypeName="AdventureWorks.FK_SalesOrderHeader_Address_BillToAddressID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="BillToAddressID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_Address_ShipToAddressID" TypeName="AdventureWorks.FK_SalesOrderHeader_Address_ShipToAddressID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="ShipToAddressID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorAddress_Address_AddressID" TypeName="AdventureWorks.FK_VendorAddress_Address_AddressID" StoreEntitySet="VendorAddress">
      <EndProperty Name="Address">
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
      <EndProperty Name="VendorAddress">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CustomerAddress_AddressType_AddressTypeID" TypeName="AdventureWorks.FK_CustomerAddress_AddressType_AddressTypeID" StoreEntitySet="CustomerAddress">
      <EndProperty Name="AddressType">
        <ScalarProperty Name="AddressTypeID" ColumnName="AddressTypeID" />
      </EndProperty>
      <EndProperty Name="CustomerAddress">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorAddress_AddressType_AddressTypeID" TypeName="AdventureWorks.FK_VendorAddress_AddressType_AddressTypeID" StoreEntitySet="VendorAddress">
      <EndProperty Name="AddressType">
        <ScalarProperty Name="AddressTypeID" ColumnName="AddressTypeID" />
      </EndProperty>
      <EndProperty Name="VendorAddress">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ContactCreditCard_Contact_ContactID" TypeName="AdventureWorks.FK_ContactCreditCard_Contact_ContactID" StoreEntitySet="ContactCreditCard">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="ContactCreditCard">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
        <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Individual_Contact_ContactID" TypeName="AdventureWorks.FK_Individual_Contact_ContactID" StoreEntitySet="Individual">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="Individual">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_Contact_ContactID" TypeName="AdventureWorks.FK_SalesOrderHeader_Contact_ContactID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_StoreContact_Contact_ContactID" TypeName="AdventureWorks.FK_StoreContact_Contact_ContactID" StoreEntitySet="StoreContact">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="StoreContact">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorContact_Contact_ContactID" TypeName="AdventureWorks.FK_VendorContact_Contact_ContactID" StoreEntitySet="VendorContact">
      <EndProperty Name="Contact">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
      <EndProperty Name="VendorContact">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_StoreContact_ContactType_ContactTypeID" TypeName="AdventureWorks.FK_StoreContact_ContactType_ContactTypeID" StoreEntitySet="StoreContact">
      <EndProperty Name="ContactType">
        <ScalarProperty Name="ContactTypeID" ColumnName="ContactTypeID" />
      </EndProperty>
      <EndProperty Name="StoreContact">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorContact_ContactType_ContactTypeID" TypeName="AdventureWorks.FK_VendorContact_ContactType_ContactTypeID" StoreEntitySet="VendorContact">
      <EndProperty Name="ContactType">
        <ScalarProperty Name="ContactTypeID" ColumnName="ContactTypeID" />
      </EndProperty>
      <EndProperty Name="VendorContact">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CountryRegionCurrency_CountryRegion_CountryRegionCode" TypeName="AdventureWorks.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode" StoreEntitySet="CountryRegionCurrency">
      <EndProperty Name="CountryRegion">
        <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      </EndProperty>
      <EndProperty Name="CountryRegionCurrency">
        <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
        <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_StateProvince_CountryRegion_CountryRegionCode" TypeName="AdventureWorks.FK_StateProvince_CountryRegion_CountryRegionCode" StoreEntitySet="StateProvince">
      <EndProperty Name="CountryRegion">
        <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
      </EndProperty>
      <EndProperty Name="StateProvince">
        <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesTaxRate_StateProvince_StateProvinceID" TypeName="AdventureWorks.FK_SalesTaxRate_StateProvince_StateProvinceID" StoreEntitySet="SalesTaxRate">
      <EndProperty Name="StateProvince">
        <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      </EndProperty>
      <EndProperty Name="SalesTaxRate">
        <ScalarProperty Name="SalesTaxRateID" ColumnName="SalesTaxRateID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_StateProvince_SalesTerritory_TerritoryID" TypeName="AdventureWorks.FK_StateProvince_SalesTerritory_TerritoryID" StoreEntitySet="StateProvince">
      <EndProperty Name="SalesTerritory">
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      </EndProperty>
      <EndProperty Name="StateProvince">
        <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_BillOfMaterials_Product_ComponentID" TypeName="AdventureWorks.FK_BillOfMaterials_Product_ComponentID" StoreEntitySet="BillOfMaterials">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ComponentID" />
      </EndProperty>
      <EndProperty Name="BillOfMaterials">
        <ScalarProperty Name="BillOfMaterialsID" ColumnName="BillOfMaterialsID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_BillOfMaterials_Product_ProductAssemblyID" TypeName="AdventureWorks.FK_BillOfMaterials_Product_ProductAssemblyID" StoreEntitySet="BillOfMaterials">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductAssemblyID" />
      </EndProperty>
      <EndProperty Name="BillOfMaterials">
        <ScalarProperty Name="BillOfMaterialsID" ColumnName="BillOfMaterialsID" />
      </EndProperty>
      <Condition ColumnName="ProductAssemblyID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_BillOfMaterials_UnitMeasure_UnitMeasureCode" TypeName="AdventureWorks.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode" StoreEntitySet="BillOfMaterials">
      <EndProperty Name="UnitMeasure">
        <ScalarProperty Name="UnitMeasureCode" ColumnName="UnitMeasureCode" />
      </EndProperty>
      <EndProperty Name="BillOfMaterials">
        <ScalarProperty Name="BillOfMaterialsID" ColumnName="BillOfMaterialsID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductModelProductDescriptionCulture_Culture_CultureID" TypeName="AdventureWorks.FK_ProductModelProductDescriptionCulture_Culture_CultureID" StoreEntitySet="ProductModelProductDescriptionCulture">
      <EndProperty Name="Culture">
        <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      </EndProperty>
      <EndProperty Name="ProductModelProductDescriptionCulture">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
        <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
        <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductDocument_Document_DocumentID" TypeName="AdventureWorks.FK_ProductDocument_Document_DocumentID" StoreEntitySet="ProductDocument">
      <EndProperty Name="Document">
        <ScalarProperty Name="DocumentID" ColumnName="DocumentID" />
      </EndProperty>
      <EndProperty Name="ProductDocument">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="DocumentID" ColumnName="DocumentID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductModelIllustration_Illustration_IllustrationID" TypeName="AdventureWorks.FK_ProductModelIllustration_Illustration_IllustrationID" StoreEntitySet="ProductModelIllustration">
      <EndProperty Name="Illustration">
        <ScalarProperty Name="IllustrationID" ColumnName="IllustrationID" />
      </EndProperty>
      <EndProperty Name="ProductModelIllustration">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
        <ScalarProperty Name="IllustrationID" ColumnName="IllustrationID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductInventory_Location_LocationID" TypeName="AdventureWorks.FK_ProductInventory_Location_LocationID" StoreEntitySet="ProductInventory">
      <EndProperty Name="Location">
        <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      </EndProperty>
      <EndProperty Name="ProductInventory">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_WorkOrderRouting_Location_LocationID" TypeName="AdventureWorks.FK_WorkOrderRouting_Location_LocationID" StoreEntitySet="WorkOrderRouting">
      <EndProperty Name="Location">
        <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      </EndProperty>
      <EndProperty Name="WorkOrderRouting">
        <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="OperationSequence" ColumnName="OperationSequence" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Product_ProductModel_ProductModelID" TypeName="AdventureWorks.FK_Product_ProductModel_ProductModelID" StoreEntitySet="Product">
      <EndProperty Name="ProductModel">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      </EndProperty>
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <Condition ColumnName="ProductModelID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Product_ProductSubcategory_ProductSubcategoryID" TypeName="AdventureWorks.FK_Product_ProductSubcategory_ProductSubcategoryID" StoreEntitySet="Product">
      <EndProperty Name="ProductSubcategory">
        <ScalarProperty Name="ProductSubcategoryID" ColumnName="ProductSubcategoryID" />
      </EndProperty>
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <Condition ColumnName="ProductSubcategoryID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Product_UnitMeasure_SizeUnitMeasureCode" TypeName="AdventureWorks.FK_Product_UnitMeasure_SizeUnitMeasureCode" StoreEntitySet="Product">
      <EndProperty Name="UnitMeasure">
        <ScalarProperty Name="UnitMeasureCode" ColumnName="SizeUnitMeasureCode" />
      </EndProperty>
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <Condition ColumnName="SizeUnitMeasureCode" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Product_UnitMeasure_WeightUnitMeasureCode" TypeName="AdventureWorks.FK_Product_UnitMeasure_WeightUnitMeasureCode" StoreEntitySet="Product">
      <EndProperty Name="UnitMeasure">
        <ScalarProperty Name="UnitMeasureCode" ColumnName="WeightUnitMeasureCode" />
      </EndProperty>
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <Condition ColumnName="WeightUnitMeasureCode" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductCostHistory_Product_ProductID" TypeName="AdventureWorks.FK_ProductCostHistory_Product_ProductID" StoreEntitySet="ProductCostHistory">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductCostHistory">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductDocument_Product_ProductID" TypeName="AdventureWorks.FK_ProductDocument_Product_ProductID" StoreEntitySet="ProductDocument">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductDocument">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="DocumentID" ColumnName="DocumentID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductInventory_Product_ProductID" TypeName="AdventureWorks.FK_ProductInventory_Product_ProductID" StoreEntitySet="ProductInventory">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductInventory">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="LocationID" ColumnName="LocationID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductListPriceHistory_Product_ProductID" TypeName="AdventureWorks.FK_ProductListPriceHistory_Product_ProductID" StoreEntitySet="ProductListPriceHistory">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductListPriceHistory">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductProductPhoto_Product_ProductID" TypeName="AdventureWorks.FK_ProductProductPhoto_Product_ProductID" StoreEntitySet="ProductProductPhoto">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductProductPhoto">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductReview_Product_ProductID" TypeName="AdventureWorks.FK_ProductReview_Product_ProductID" StoreEntitySet="ProductReview">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductReview">
        <ScalarProperty Name="ProductReviewID" ColumnName="ProductReviewID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductVendor_Product_ProductID" TypeName="AdventureWorks.FK_ProductVendor_Product_ProductID" StoreEntitySet="ProductVendor">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ProductVendor">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_PurchaseOrderDetail_Product_ProductID" TypeName="AdventureWorks.FK_PurchaseOrderDetail_Product_ProductID" StoreEntitySet="PurchaseOrderDetail">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="PurchaseOrderDetail">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
        <ScalarProperty Name="PurchaseOrderDetailID" ColumnName="PurchaseOrderDetailID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ShoppingCartItem_Product_ProductID" TypeName="AdventureWorks.FK_ShoppingCartItem_Product_ProductID" StoreEntitySet="ShoppingCartItem">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="ShoppingCartItem">
        <ScalarProperty Name="ShoppingCartItemID" ColumnName="ShoppingCartItemID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SpecialOfferProduct_Product_ProductID" TypeName="AdventureWorks.FK_SpecialOfferProduct_Product_ProductID" StoreEntitySet="SpecialOfferProduct">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="SpecialOfferProduct">
        <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_TransactionHistory_Product_ProductID" TypeName="AdventureWorks.FK_TransactionHistory_Product_ProductID" StoreEntitySet="TransactionHistory">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="TransactionHistory">
        <ScalarProperty Name="TransactionID" ColumnName="TransactionID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_WorkOrder_Product_ProductID" TypeName="AdventureWorks.FK_WorkOrder_Product_ProductID" StoreEntitySet="WorkOrder">
      <EndProperty Name="Product">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="WorkOrder">
        <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductSubcategory_ProductCategory_ProductCategoryID" TypeName="AdventureWorks.FK_ProductSubcategory_ProductCategory_ProductCategoryID" StoreEntitySet="ProductSubcategory">
      <EndProperty Name="ProductCategory">
        <ScalarProperty Name="ProductCategoryID" ColumnName="ProductCategoryID" />
      </EndProperty>
      <EndProperty Name="ProductSubcategory">
        <ScalarProperty Name="ProductSubcategoryID" ColumnName="ProductSubcategoryID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID" TypeName="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID" StoreEntitySet="ProductModelProductDescriptionCulture">
      <EndProperty Name="ProductDescription">
        <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
      </EndProperty>
      <EndProperty Name="ProductModelProductDescriptionCulture">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
        <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
        <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductModelIllustration_ProductModel_ProductModelID" TypeName="AdventureWorks.FK_ProductModelIllustration_ProductModel_ProductModelID" StoreEntitySet="ProductModelIllustration">
      <EndProperty Name="ProductModel">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      </EndProperty>
      <EndProperty Name="ProductModelIllustration">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
        <ScalarProperty Name="IllustrationID" ColumnName="IllustrationID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID" TypeName="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID" StoreEntitySet="ProductModelProductDescriptionCulture">
      <EndProperty Name="ProductModel">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
      </EndProperty>
      <EndProperty Name="ProductModelProductDescriptionCulture">
        <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
        <ScalarProperty Name="ProductDescriptionID" ColumnName="ProductDescriptionID" />
        <ScalarProperty Name="CultureID" ColumnName="CultureID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" TypeName="AdventureWorks.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" StoreEntitySet="ProductProductPhoto">
      <EndProperty Name="ProductPhoto">
        <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      </EndProperty>
      <EndProperty Name="ProductProductPhoto">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="ProductPhotoID" ColumnName="ProductPhotoID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_WorkOrder_ScrapReason_ScrapReasonID" TypeName="AdventureWorks.FK_WorkOrder_ScrapReason_ScrapReasonID" StoreEntitySet="WorkOrder">
      <EndProperty Name="ScrapReason">
        <ScalarProperty Name="ScrapReasonID" ColumnName="ScrapReasonID" />
      </EndProperty>
      <EndProperty Name="WorkOrder">
        <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
      </EndProperty>
      <Condition ColumnName="ScrapReasonID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductVendor_UnitMeasure_UnitMeasureCode" TypeName="AdventureWorks.FK_ProductVendor_UnitMeasure_UnitMeasureCode" StoreEntitySet="ProductVendor">
      <EndProperty Name="UnitMeasure">
        <ScalarProperty Name="UnitMeasureCode" ColumnName="UnitMeasureCode" />
      </EndProperty>
      <EndProperty Name="ProductVendor">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_WorkOrderRouting_WorkOrder_WorkOrderID" TypeName="AdventureWorks.FK_WorkOrderRouting_WorkOrder_WorkOrderID" StoreEntitySet="WorkOrderRouting">
      <EndProperty Name="WorkOrder">
        <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
      </EndProperty>
      <EndProperty Name="WorkOrderRouting">
        <ScalarProperty Name="WorkOrderID" ColumnName="WorkOrderID" />
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="OperationSequence" ColumnName="OperationSequence" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ProductVendor_Vendor_VendorID" TypeName="AdventureWorks.FK_ProductVendor_Vendor_VendorID" StoreEntitySet="ProductVendor">
      <EndProperty Name="Vendor">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
      <EndProperty Name="ProductVendor">
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID" TypeName="AdventureWorks.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID" StoreEntitySet="PurchaseOrderDetail">
      <EndProperty Name="PurchaseOrderHeader">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      </EndProperty>
      <EndProperty Name="PurchaseOrderDetail">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
        <ScalarProperty Name="PurchaseOrderDetailID" ColumnName="PurchaseOrderDetailID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_PurchaseOrderHeader_ShipMethod_ShipMethodID" TypeName="AdventureWorks.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID" StoreEntitySet="PurchaseOrderHeader">
      <EndProperty Name="ShipMethod">
        <ScalarProperty Name="ShipMethodID" ColumnName="ShipMethodID" />
      </EndProperty>
      <EndProperty Name="PurchaseOrderHeader">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_PurchaseOrderHeader_Vendor_VendorID" TypeName="AdventureWorks.FK_PurchaseOrderHeader_Vendor_VendorID" StoreEntitySet="PurchaseOrderHeader">
      <EndProperty Name="Vendor">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
      <EndProperty Name="PurchaseOrderHeader">
        <ScalarProperty Name="PurchaseOrderID" ColumnName="PurchaseOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_ShipMethod_ShipMethodID" TypeName="AdventureWorks.FK_SalesOrderHeader_ShipMethod_ShipMethodID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="ShipMethod">
        <ScalarProperty Name="ShipMethodID" ColumnName="ShipMethodID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorAddress_Vendor_VendorID" TypeName="AdventureWorks.FK_VendorAddress_Vendor_VendorID" StoreEntitySet="VendorAddress">
      <EndProperty Name="Vendor">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
      <EndProperty Name="VendorAddress">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_VendorContact_Vendor_VendorID" TypeName="AdventureWorks.FK_VendorContact_Vendor_VendorID" StoreEntitySet="VendorContact">
      <EndProperty Name="Vendor">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
      </EndProperty>
      <EndProperty Name="VendorContact">
        <ScalarProperty Name="VendorID" ColumnName="VendorID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_ContactCreditCard_CreditCard_CreditCardID" TypeName="AdventureWorks.FK_ContactCreditCard_CreditCard_CreditCardID" StoreEntitySet="ContactCreditCard">
      <EndProperty Name="CreditCard">
        <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      </EndProperty>
      <EndProperty Name="ContactCreditCard">
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
        <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CountryRegionCurrency_Currency_CurrencyCode" TypeName="AdventureWorks.FK_CountryRegionCurrency_Currency_CurrencyCode" StoreEntitySet="CountryRegionCurrency">
      <EndProperty Name="Currency">
        <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
      </EndProperty>
      <EndProperty Name="CountryRegionCurrency">
        <ScalarProperty Name="CountryRegionCode" ColumnName="CountryRegionCode" />
        <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_CreditCard_CreditCardID" TypeName="AdventureWorks.FK_SalesOrderHeader_CreditCard_CreditCardID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="CreditCard">
        <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <Condition ColumnName="CreditCardID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CurrencyRate_Currency_FromCurrencyCode" TypeName="AdventureWorks.FK_CurrencyRate_Currency_FromCurrencyCode" StoreEntitySet="CurrencyRate">
      <EndProperty Name="Currency">
        <ScalarProperty Name="CurrencyCode" ColumnName="FromCurrencyCode" />
      </EndProperty>
      <EndProperty Name="CurrencyRate">
        <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CurrencyRate_Currency_ToCurrencyCode" TypeName="AdventureWorks.FK_CurrencyRate_Currency_ToCurrencyCode" StoreEntitySet="CurrencyRate">
      <EndProperty Name="Currency">
        <ScalarProperty Name="CurrencyCode" ColumnName="ToCurrencyCode" />
      </EndProperty>
      <EndProperty Name="CurrencyRate">
        <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_CurrencyRate_CurrencyRateID" TypeName="AdventureWorks.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="CurrencyRate">
        <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <Condition ColumnName="CurrencyRateID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Customer_SalesTerritory_TerritoryID" TypeName="AdventureWorks.FK_Customer_SalesTerritory_TerritoryID" StoreEntitySet="Customer">
      <EndProperty Name="SalesTerritory">
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      </EndProperty>
      <EndProperty Name="Customer">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <Condition ColumnName="TerritoryID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_CustomerAddress_Customer_CustomerID" TypeName="AdventureWorks.FK_CustomerAddress_Customer_CustomerID" StoreEntitySet="CustomerAddress">
      <EndProperty Name="Customer">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <EndProperty Name="CustomerAddress">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="AddressID" ColumnName="AddressID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Individual_Customer_CustomerID" TypeName="AdventureWorks.FK_Individual_Customer_CustomerID" StoreEntitySet="Individual">
      <EndProperty Name="Customer">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <EndProperty Name="Individual">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_Customer_CustomerID" TypeName="AdventureWorks.FK_SalesOrderHeader_Customer_CustomerID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="Customer">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Store_Customer_CustomerID" TypeName="AdventureWorks.FK_Store_Customer_CustomerID" StoreEntitySet="Store">
      <EndProperty Name="Customer">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <EndProperty Name="Store">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" TypeName="AdventureWorks.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" StoreEntitySet="SalesOrderDetail">
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <EndProperty Name="SalesOrderDetail">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
        <ScalarProperty Name="SalesOrderDetailID" ColumnName="SalesOrderDetailID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID" TypeName="AdventureWorks.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID" StoreEntitySet="SalesOrderDetail">
      <EndProperty Name="SpecialOfferProduct">
        <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
      <EndProperty Name="SalesOrderDetail">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
        <ScalarProperty Name="SalesOrderDetailID" ColumnName="SalesOrderDetailID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_SalesPerson_SalesPersonID" TypeName="AdventureWorks.FK_SalesOrderHeader_SalesPerson_SalesPersonID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <Condition ColumnName="SalesPersonID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeader_SalesTerritory_TerritoryID" TypeName="AdventureWorks.FK_SalesOrderHeader_SalesTerritory_TerritoryID" StoreEntitySet="SalesOrderHeader">
      <EndProperty Name="SalesTerritory">
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <Condition ColumnName="TerritoryID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID" TypeName="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID" StoreEntitySet="SalesOrderHeaderSalesReason">
      <EndProperty Name="SalesOrderHeader">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeaderSalesReason">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
        <ScalarProperty Name="SalesReasonID" ColumnName="SalesReasonID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID" TypeName="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID" StoreEntitySet="SalesOrderHeaderSalesReason">
      <EndProperty Name="SalesReason">
        <ScalarProperty Name="SalesReasonID" ColumnName="SalesReasonID" />
      </EndProperty>
      <EndProperty Name="SalesOrderHeaderSalesReason">
        <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
        <ScalarProperty Name="SalesReasonID" ColumnName="SalesReasonID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesPerson_SalesTerritory_TerritoryID" TypeName="AdventureWorks.FK_SalesPerson_SalesTerritory_TerritoryID" StoreEntitySet="SalesPerson">
      <EndProperty Name="SalesTerritory">
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      </EndProperty>
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
      <Condition ColumnName="TerritoryID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID" TypeName="AdventureWorks.FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID" StoreEntitySet="SalesPersonQuotaHistory">
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
      <EndProperty Name="SalesPersonQuotaHistory">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
        <ScalarProperty Name="QuotaDate" ColumnName="QuotaDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesTerritoryHistory_SalesPerson_SalesPersonID" TypeName="AdventureWorks.FK_SalesTerritoryHistory_SalesPerson_SalesPersonID" StoreEntitySet="SalesTerritoryHistory">
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
      <EndProperty Name="SalesTerritoryHistory">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_Store_SalesPerson_SalesPersonID" TypeName="AdventureWorks.FK_Store_SalesPerson_SalesPersonID" StoreEntitySet="Store">
      <EndProperty Name="SalesPerson">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
      </EndProperty>
      <EndProperty Name="Store">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <Condition ColumnName="SalesPersonID" IsNull="false" />
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SalesTerritoryHistory_SalesTerritory_TerritoryID" TypeName="AdventureWorks.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID" StoreEntitySet="SalesTerritoryHistory">
      <EndProperty Name="SalesTerritory">
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
      </EndProperty>
      <EndProperty Name="SalesTerritoryHistory">
        <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
        <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
        <ScalarProperty Name="StartDate" ColumnName="StartDate" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID" TypeName="AdventureWorks.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID" StoreEntitySet="SpecialOfferProduct">
      <EndProperty Name="SpecialOffer">
        <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
      </EndProperty>
      <EndProperty Name="SpecialOfferProduct">
        <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
        <ScalarProperty Name="ProductID" ColumnName="ProductID" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FK_StoreContact_Store_CustomerID" TypeName="AdventureWorks.FK_StoreContact_Store_CustomerID" StoreEntitySet="StoreContact">
      <EndProperty Name="Store">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
      </EndProperty>
      <EndProperty Name="StoreContact">
        <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
        <ScalarProperty Name="ContactID" ColumnName="ContactID" />
      </EndProperty>
    </AssociationSetMapping>
  </EntityContainerMapping>
</Mapping>