Vollständiges Mappingschema für AdventureWorks (EDM)
Dieses Schema in Mapping-Spezifikationssprache (Mapping Specification Language, MSL) ordnet ein programmierbares Objektmodell entsprechenden Tabellen in der AdventureWorks-Datenbank zu. Dieses Schema ordnet Schemas zu, die in den folgenden vorherigen Themen definiert werden: Vollständiges konzeptionelles Schema für AdventureWorks (EDM) und Vollständiges Speicherschema für AdventureWorks (EDM)
Das folgende Schema wurde zusammen mit dem Speicherschema und dem konzeptionellen Schema mithilfe des Tools EdmGen.exe generiert. Dies ist in AdventureWorks Complete Model (EDM) dargestellt.
Das folgende Schema enthält sämtliche für die Verwendung der AdventureWorks-Typen und -Zuordnungen in der Programmiersprache C# benötigten Mappings.
<?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>