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