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