Export (0) Print
Expand All

AdventureWorks Complete Mapping Schema (EDM)

.NET Framework 3.5

This schema in mapping specification language (MSL) maps a programmable object model to corresponding tables in the Adventureworks database. This schema maps schemas defined in the previous topics: AdventureWorks Complete Conceptual Schema (EDM) and AdventureWorks Complete Storage Schema (EDM).

The following schema was generated along with the storage and conceptual schemas by using the tool EdmGen.exe as shown in AdventureWorks Complete Model (EDM).

The following schema contains all the mappings required to use Adventureworks types and associations in the C# language.

<?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>


Community Additions

Show:
© 2015 Microsoft