SaloonModel.msl 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  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="Хранилище beauty_saloonModelContainer" CdmEntityContainer="beauty_saloonEntities">
  4. <EntitySetMapping Name="Client">
  5. <EntityTypeMapping TypeName="beauty_saloonModel.Client">
  6. <MappingFragment StoreEntitySet="Client">
  7. <ScalarProperty Name="ID" ColumnName="ID" />
  8. <ScalarProperty Name="FirstName" ColumnName="FirstName" />
  9. <ScalarProperty Name="LastName" ColumnName="LastName" />
  10. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  11. <ScalarProperty Name="Birthday" ColumnName="Birthday" />
  12. <ScalarProperty Name="RegistrationDate" ColumnName="RegistrationDate" />
  13. <ScalarProperty Name="Email" ColumnName="Email" />
  14. <ScalarProperty Name="Phone" ColumnName="Phone" />
  15. <ScalarProperty Name="GenderCode" ColumnName="GenderCode" />
  16. <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
  17. </MappingFragment>
  18. </EntityTypeMapping>
  19. </EntitySetMapping>
  20. <EntitySetMapping Name="ClientService">
  21. <EntityTypeMapping TypeName="beauty_saloonModel.ClientService">
  22. <MappingFragment StoreEntitySet="ClientService">
  23. <ScalarProperty Name="ID" ColumnName="ID" />
  24. <ScalarProperty Name="ClientID" ColumnName="ClientID" />
  25. <ScalarProperty Name="ServiceID" ColumnName="ServiceID" />
  26. <ScalarProperty Name="StartTime" ColumnName="StartTime" />
  27. <ScalarProperty Name="Comment" ColumnName="Comment" />
  28. </MappingFragment>
  29. </EntityTypeMapping>
  30. </EntitySetMapping>
  31. <EntitySetMapping Name="DocumentByService">
  32. <EntityTypeMapping TypeName="beauty_saloonModel.DocumentByService">
  33. <MappingFragment StoreEntitySet="DocumentByService">
  34. <ScalarProperty Name="ID" ColumnName="ID" />
  35. <ScalarProperty Name="ClientServiceID" ColumnName="ClientServiceID" />
  36. <ScalarProperty Name="DocumentPath" ColumnName="DocumentPath" />
  37. </MappingFragment>
  38. </EntityTypeMapping>
  39. </EntitySetMapping>
  40. <EntitySetMapping Name="Gender">
  41. <EntityTypeMapping TypeName="beauty_saloonModel.Gender">
  42. <MappingFragment StoreEntitySet="Gender">
  43. <ScalarProperty Name="Code" ColumnName="Code" />
  44. <ScalarProperty Name="Name" ColumnName="Name" />
  45. </MappingFragment>
  46. </EntityTypeMapping>
  47. </EntitySetMapping>
  48. <EntitySetMapping Name="Manufacturer">
  49. <EntityTypeMapping TypeName="beauty_saloonModel.Manufacturer">
  50. <MappingFragment StoreEntitySet="Manufacturer">
  51. <ScalarProperty Name="ID" ColumnName="ID" />
  52. <ScalarProperty Name="Name" ColumnName="Name" />
  53. <ScalarProperty Name="StartDate" ColumnName="StartDate" />
  54. </MappingFragment>
  55. </EntityTypeMapping>
  56. </EntitySetMapping>
  57. <EntitySetMapping Name="Product">
  58. <EntityTypeMapping TypeName="beauty_saloonModel.Product">
  59. <MappingFragment StoreEntitySet="Product">
  60. <ScalarProperty Name="ID" ColumnName="ID" />
  61. <ScalarProperty Name="Title" ColumnName="Title" />
  62. <ScalarProperty Name="Cost" ColumnName="Cost" />
  63. <ScalarProperty Name="Description" ColumnName="Description" />
  64. <ScalarProperty Name="MainImagePath" ColumnName="MainImagePath" />
  65. <ScalarProperty Name="IsActive" ColumnName="IsActive" />
  66. <ScalarProperty Name="ManufacturerID" ColumnName="ManufacturerID" />
  67. </MappingFragment>
  68. </EntityTypeMapping>
  69. </EntitySetMapping>
  70. <EntitySetMapping Name="ProductPhoto">
  71. <EntityTypeMapping TypeName="beauty_saloonModel.ProductPhoto">
  72. <MappingFragment StoreEntitySet="ProductPhoto">
  73. <ScalarProperty Name="ID" ColumnName="ID" />
  74. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  75. <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
  76. </MappingFragment>
  77. </EntityTypeMapping>
  78. </EntitySetMapping>
  79. <EntitySetMapping Name="ProductSale">
  80. <EntityTypeMapping TypeName="beauty_saloonModel.ProductSale">
  81. <MappingFragment StoreEntitySet="ProductSale">
  82. <ScalarProperty Name="ID" ColumnName="ID" />
  83. <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
  84. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  85. <ScalarProperty Name="Quantity" ColumnName="Quantity" />
  86. <ScalarProperty Name="ClientServiceID" ColumnName="ClientServiceID" />
  87. </MappingFragment>
  88. </EntityTypeMapping>
  89. </EntitySetMapping>
  90. <EntitySetMapping Name="Service">
  91. <EntityTypeMapping TypeName="beauty_saloonModel.Service">
  92. <MappingFragment StoreEntitySet="Service">
  93. <ScalarProperty Name="ID" ColumnName="ID" />
  94. <ScalarProperty Name="Title" ColumnName="Title" />
  95. <ScalarProperty Name="Cost" ColumnName="Cost" />
  96. <ScalarProperty Name="DurationInSeconds" ColumnName="DurationInSeconds" />
  97. <ScalarProperty Name="Description" ColumnName="Description" />
  98. <ScalarProperty Name="Discount" ColumnName="Discount" />
  99. <ScalarProperty Name="MainImagePath" ColumnName="MainImagePath" />
  100. </MappingFragment>
  101. </EntityTypeMapping>
  102. </EntitySetMapping>
  103. <EntitySetMapping Name="ServicePhoto">
  104. <EntityTypeMapping TypeName="beauty_saloonModel.ServicePhoto">
  105. <MappingFragment StoreEntitySet="ServicePhoto">
  106. <ScalarProperty Name="ID" ColumnName="ID" />
  107. <ScalarProperty Name="ServiceID" ColumnName="ServiceID" />
  108. <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
  109. </MappingFragment>
  110. </EntityTypeMapping>
  111. </EntitySetMapping>
  112. <EntitySetMapping Name="sysdiagrams">
  113. <EntityTypeMapping TypeName="beauty_saloonModel.sysdiagrams">
  114. <MappingFragment StoreEntitySet="sysdiagrams">
  115. <ScalarProperty Name="name" ColumnName="name" />
  116. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  117. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  118. <ScalarProperty Name="version" ColumnName="version" />
  119. <ScalarProperty Name="definition" ColumnName="definition" />
  120. </MappingFragment>
  121. </EntityTypeMapping>
  122. </EntitySetMapping>
  123. <EntitySetMapping Name="Tag">
  124. <EntityTypeMapping TypeName="beauty_saloonModel.Tag">
  125. <MappingFragment StoreEntitySet="Tag">
  126. <ScalarProperty Name="ID" ColumnName="ID" />
  127. <ScalarProperty Name="Title" ColumnName="Title" />
  128. <ScalarProperty Name="Color" ColumnName="Color" />
  129. </MappingFragment>
  130. </EntityTypeMapping>
  131. </EntitySetMapping>
  132. <AssociationSetMapping Name="AttachedProduct" TypeName="beauty_saloonModel.AttachedProduct" StoreEntitySet="AttachedProduct">
  133. <EndProperty Name="Product">
  134. <ScalarProperty Name="ID" ColumnName="MainProductID" />
  135. </EndProperty>
  136. <EndProperty Name="Product1">
  137. <ScalarProperty Name="ID" ColumnName="AttachedProductID" />
  138. </EndProperty>
  139. </AssociationSetMapping>
  140. <AssociationSetMapping Name="TagOfClient" TypeName="beauty_saloonModel.TagOfClient" StoreEntitySet="TagOfClient">
  141. <EndProperty Name="Client">
  142. <ScalarProperty Name="ID" ColumnName="ClientID" />
  143. </EndProperty>
  144. <EndProperty Name="Tag">
  145. <ScalarProperty Name="ID" ColumnName="TagID" />
  146. </EndProperty>
  147. </AssociationSetMapping>
  148. <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Хранилище beauty_saloonModel.sp_alterdiagram" />
  149. <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Хранилище beauty_saloonModel.sp_creatediagram" />
  150. <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Хранилище beauty_saloonModel.sp_dropdiagram" />
  151. <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Хранилище beauty_saloonModel.sp_helpdiagramdefinition">
  152. <ResultMapping>
  153. <ComplexTypeMapping TypeName="beauty_saloonModel.sp_helpdiagramdefinition_Result">
  154. <ScalarProperty Name="version" ColumnName="version" />
  155. <ScalarProperty Name="definition" ColumnName="definition" />
  156. </ComplexTypeMapping>
  157. </ResultMapping>
  158. </FunctionImportMapping>
  159. <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Хранилище beauty_saloonModel.sp_helpdiagrams">
  160. <ResultMapping>
  161. <ComplexTypeMapping TypeName="beauty_saloonModel.sp_helpdiagrams_Result">
  162. <ScalarProperty Name="Database" ColumnName="Database" />
  163. <ScalarProperty Name="Name" ColumnName="Name" />
  164. <ScalarProperty Name="ID" ColumnName="ID" />
  165. <ScalarProperty Name="Owner" ColumnName="Owner" />
  166. <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
  167. </ComplexTypeMapping>
  168. </ResultMapping>
  169. </FunctionImportMapping>
  170. <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Хранилище beauty_saloonModel.sp_renamediagram" />
  171. <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Хранилище beauty_saloonModel.sp_upgraddiagrams" />
  172. </EntityContainerMapping>
  173. </Mapping>