ModelStore.msl 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  3. <EntityContainerMapping StorageEntityContainer="gr672_pgvModelStoreContainer" CdmEntityContainer="gr672_pgvEntities">
  4. <EntitySetMapping Name="Employee">
  5. <EntityTypeMapping TypeName="gr672_pgvModel.Employee">
  6. <MappingFragment StoreEntitySet="Employee">
  7. <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
  8. <ScalarProperty Name="LastName" ColumnName="LastName" />
  9. <ScalarProperty Name="Name" ColumnName="Name" />
  10. <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
  11. <ScalarProperty Name="Code" ColumnName="Code" />
  12. </MappingFragment>
  13. </EntityTypeMapping>
  14. </EntitySetMapping>
  15. <EntitySetMapping Name="Order">
  16. <EntityTypeMapping TypeName="gr672_pgvModel.Order">
  17. <MappingFragment StoreEntitySet="Order">
  18. <ScalarProperty Name="OrderID" ColumnName="OrderID" />
  19. <ScalarProperty Name="Date" ColumnName="Date" />
  20. <ScalarProperty Name="IDWorkShift" ColumnName="IDWorkShift" />
  21. <ScalarProperty Name="State" ColumnName="State" />
  22. </MappingFragment>
  23. </EntityTypeMapping>
  24. </EntitySetMapping>
  25. <EntitySetMapping Name="PaymentMetod">
  26. <EntityTypeMapping TypeName="gr672_pgvModel.PaymentMetod">
  27. <MappingFragment StoreEntitySet="PaymentMetod">
  28. <ScalarProperty Name="PaymentMetodID" ColumnName="PaymentMetodID" />
  29. <ScalarProperty Name="PaymentMetodName" ColumnName="PaymentMetodName" />
  30. </MappingFragment>
  31. </EntityTypeMapping>
  32. </EntitySetMapping>
  33. <EntitySetMapping Name="PaymentOrder">
  34. <EntityTypeMapping TypeName="gr672_pgvModel.PaymentOrder">
  35. <MappingFragment StoreEntitySet="PaymentOrder">
  36. <ScalarProperty Name="PaymentID" ColumnName="PaymentID" />
  37. <ScalarProperty Name="IDPaymentMetod" ColumnName="IDPaymentMetod" />
  38. <ScalarProperty Name="IDOrder" ColumnName="IDOrder" />
  39. </MappingFragment>
  40. </EntityTypeMapping>
  41. </EntitySetMapping>
  42. <EntitySetMapping Name="Product">
  43. <EntityTypeMapping TypeName="gr672_pgvModel.Product">
  44. <MappingFragment StoreEntitySet="Product">
  45. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  46. <ScalarProperty Name="NameProduct" ColumnName="NameProduct" />
  47. <ScalarProperty Name="Weight" ColumnName="Weight" />
  48. <ScalarProperty Name="Packaging" ColumnName="Packaging" />
  49. <ScalarProperty Name="PriceOfOne" ColumnName="PriceOfOne" />
  50. <ScalarProperty Name="BarCode" ColumnName="BarCode" />
  51. </MappingFragment>
  52. </EntityTypeMapping>
  53. </EntitySetMapping>
  54. <EntitySetMapping Name="ProductInOrder">
  55. <EntityTypeMapping TypeName="gr672_pgvModel.ProductInOrder">
  56. <MappingFragment StoreEntitySet="ProductInOrder">
  57. <ScalarProperty Name="IDOrder" ColumnName="IDOrder" />
  58. <ScalarProperty Name="IDProduct" ColumnName="IDProduct" />
  59. <ScalarProperty Name="AmountProduct" ColumnName="AmountProduct" />
  60. </MappingFragment>
  61. </EntityTypeMapping>
  62. </EntitySetMapping>
  63. <EntitySetMapping Name="ProductInStore">
  64. <EntityTypeMapping TypeName="gr672_pgvModel.ProductInStore">
  65. <MappingFragment StoreEntitySet="ProductInStore">
  66. <ScalarProperty Name="ProductInStoreID" ColumnName="ProductInStoreID" />
  67. <ScalarProperty Name="IDStore" ColumnName="IDStore" />
  68. <ScalarProperty Name="IDProduct" ColumnName="IDProduct" />
  69. <ScalarProperty Name="RemainsProduct" ColumnName="RemainsProduct" />
  70. </MappingFragment>
  71. </EntityTypeMapping>
  72. </EntitySetMapping>
  73. <EntitySetMapping Name="Store">
  74. <EntityTypeMapping TypeName="gr672_pgvModel.Store">
  75. <MappingFragment StoreEntitySet="Store">
  76. <ScalarProperty Name="StoreID" ColumnName="StoreID" />
  77. <ScalarProperty Name="Address" ColumnName="Address" />
  78. </MappingFragment>
  79. </EntityTypeMapping>
  80. </EntitySetMapping>
  81. <EntitySetMapping Name="Cashier">
  82. <EntityTypeMapping TypeName="gr672_pgvModel.Cashier">
  83. <MappingFragment StoreEntitySet="Cashier">
  84. <ScalarProperty Name="IDStore" ColumnName="IDStore" />
  85. <ScalarProperty Name="CashierID" ColumnName="CashierID" />
  86. </MappingFragment>
  87. </EntityTypeMapping>
  88. </EntitySetMapping>
  89. <EntitySetMapping Name="EmployeeInStore">
  90. <EntityTypeMapping TypeName="gr672_pgvModel.EmployeeInStore">
  91. <MappingFragment StoreEntitySet="EmployeeInStore">
  92. <ScalarProperty Name="IDEmployeeInStore" ColumnName="IDEmployeeInStore" />
  93. <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
  94. <ScalarProperty Name="IDStore" ColumnName="IDStore" />
  95. </MappingFragment>
  96. </EntityTypeMapping>
  97. </EntitySetMapping>
  98. <EntitySetMapping Name="WorkShift">
  99. <EntityTypeMapping TypeName="gr672_pgvModel.WorkShift">
  100. <MappingFragment StoreEntitySet="WorkShift">
  101. <ScalarProperty Name="EndDateAndTimeWork" ColumnName="EndDateAndTimeWork" />
  102. <ScalarProperty Name="StartDateAndTimeWork" ColumnName="StartDateAndTimeWork" />
  103. <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
  104. <ScalarProperty Name="IDCashier" ColumnName="IDCashier" />
  105. <ScalarProperty Name="WorkShiftID" ColumnName="WorkShiftID" />
  106. </MappingFragment>
  107. </EntityTypeMapping>
  108. </EntitySetMapping>
  109. </EntityContainerMapping>
  110. </Mapping>