Model1.msl 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  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="Хранилище ModelContainer" CdmEntityContainer="Gayduk_pr2Entities1">
  4. <EntitySetMapping Name="Client">
  5. <EntityTypeMapping TypeName="Model.Client">
  6. <MappingFragment StoreEntitySet="Client">
  7. <ScalarProperty Name="id" ColumnName="id" />
  8. <ScalarProperty Name="Фамилия" ColumnName="Фамилия" />
  9. <ScalarProperty Name="Имя" ColumnName="Имя" />
  10. <ScalarProperty Name="Отчество" ColumnName="Отчество" />
  11. <ScalarProperty Name="Пол" ColumnName="Пол" />
  12. <ScalarProperty Name="Телефон" ColumnName="Телефон" />
  13. <ScalarProperty Name="Дата_рождения" ColumnName="Дата_рождения" />
  14. <ScalarProperty Name="Email" ColumnName="Email" />
  15. <ScalarProperty Name="Дата_регистрации" ColumnName="Дата_регистрации" />
  16. </MappingFragment>
  17. </EntityTypeMapping>
  18. </EntitySetMapping>
  19. <EntitySetMapping Name="DocumentByService">
  20. <EntityTypeMapping TypeName="Model.DocumentByService">
  21. <MappingFragment StoreEntitySet="DocumentByService">
  22. <ScalarProperty Name="ID" ColumnName="ID" />
  23. <ScalarProperty Name="ClientServiceID" ColumnName="ClientServiceID" />
  24. <ScalarProperty Name="DocumentPath" ColumnName="DocumentPath" />
  25. </MappingFragment>
  26. </EntityTypeMapping>
  27. </EntitySetMapping>
  28. <EntitySetMapping Name="Gender">
  29. <EntityTypeMapping TypeName="Model.Gender">
  30. <MappingFragment StoreEntitySet="Gender">
  31. <ScalarProperty Name="Code" ColumnName="Code" />
  32. <ScalarProperty Name="Name" ColumnName="Name" />
  33. </MappingFragment>
  34. </EntityTypeMapping>
  35. </EntitySetMapping>
  36. <EntitySetMapping Name="Manufacturer">
  37. <EntityTypeMapping TypeName="Model.Manufacturer">
  38. <MappingFragment StoreEntitySet="Manufacturer">
  39. <ScalarProperty Name="ID" ColumnName="ID" />
  40. <ScalarProperty Name="Name" ColumnName="Name" />
  41. <ScalarProperty Name="StartDate" ColumnName="StartDate" />
  42. </MappingFragment>
  43. </EntityTypeMapping>
  44. </EntitySetMapping>
  45. <EntitySetMapping Name="Product">
  46. <EntityTypeMapping TypeName="Model.Product">
  47. <MappingFragment StoreEntitySet="Product">
  48. <ScalarProperty Name="ID" ColumnName="ID" />
  49. <ScalarProperty Name="Title" ColumnName="Title" />
  50. <ScalarProperty Name="Cost" ColumnName="Cost" />
  51. <ScalarProperty Name="Description" ColumnName="Description" />
  52. <ScalarProperty Name="MainImagePath" ColumnName="MainImagePath" />
  53. <ScalarProperty Name="IsActive" ColumnName="IsActive" />
  54. <ScalarProperty Name="ManufacturerID" ColumnName="ManufacturerID" />
  55. </MappingFragment>
  56. </EntityTypeMapping>
  57. </EntitySetMapping>
  58. <EntitySetMapping Name="ProductPhoto">
  59. <EntityTypeMapping TypeName="Model.ProductPhoto">
  60. <MappingFragment StoreEntitySet="ProductPhoto">
  61. <ScalarProperty Name="ID" ColumnName="ID" />
  62. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  63. <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
  64. </MappingFragment>
  65. </EntityTypeMapping>
  66. </EntitySetMapping>
  67. <EntitySetMapping Name="ProductSale">
  68. <EntityTypeMapping TypeName="Model.ProductSale">
  69. <MappingFragment StoreEntitySet="ProductSale">
  70. <ScalarProperty Name="ID" ColumnName="ID" />
  71. <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
  72. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  73. <ScalarProperty Name="Quantity" ColumnName="Quantity" />
  74. <ScalarProperty Name="ClientServiceID" ColumnName="ClientServiceID" />
  75. </MappingFragment>
  76. </EntityTypeMapping>
  77. </EntitySetMapping>
  78. <EntitySetMapping Name="Service">
  79. <EntityTypeMapping TypeName="Model.Service">
  80. <MappingFragment StoreEntitySet="Service">
  81. <ScalarProperty Name="id" ColumnName="id" />
  82. <ScalarProperty Name="Наименование_услуги" ColumnName="Наименование_услуги" />
  83. <ScalarProperty Name="Главное_изображение" ColumnName="Главное_изображение" />
  84. <ScalarProperty Name="Длительность" ColumnName="Длительность" />
  85. <ScalarProperty Name="Стоимость" ColumnName="Стоимость" />
  86. <ScalarProperty Name="Действующая_скидка" ColumnName="Действующая_скидка" />
  87. </MappingFragment>
  88. </EntityTypeMapping>
  89. </EntitySetMapping>
  90. <EntitySetMapping Name="Serviceclient">
  91. <EntityTypeMapping TypeName="Model.Serviceclient">
  92. <MappingFragment StoreEntitySet="Serviceclient">
  93. <ScalarProperty Name="id" ColumnName="id" />
  94. <ScalarProperty Name="услуга" ColumnName="услуга" />
  95. <ScalarProperty Name="дата" ColumnName="дата" />
  96. <ScalarProperty Name="клиент" ColumnName="клиент" />
  97. <ScalarProperty Name="описания" ColumnName="описания" />
  98. </MappingFragment>
  99. </EntityTypeMapping>
  100. </EntitySetMapping>
  101. <EntitySetMapping Name="ServicePhoto">
  102. <EntityTypeMapping TypeName="Model.ServicePhoto">
  103. <MappingFragment StoreEntitySet="ServicePhoto">
  104. <ScalarProperty Name="ID" ColumnName="ID" />
  105. <ScalarProperty Name="ServiceID" ColumnName="ServiceID" />
  106. <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
  107. </MappingFragment>
  108. </EntityTypeMapping>
  109. </EntitySetMapping>
  110. <EntitySetMapping Name="sysdiagrams">
  111. <EntityTypeMapping TypeName="Model.sysdiagrams">
  112. <MappingFragment StoreEntitySet="sysdiagrams">
  113. <ScalarProperty Name="name" ColumnName="name" />
  114. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  115. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  116. <ScalarProperty Name="version" ColumnName="version" />
  117. <ScalarProperty Name="definition" ColumnName="definition" />
  118. </MappingFragment>
  119. </EntityTypeMapping>
  120. </EntitySetMapping>
  121. <EntitySetMapping Name="Tag">
  122. <EntityTypeMapping TypeName="Model.Tag">
  123. <MappingFragment StoreEntitySet="Tag">
  124. <ScalarProperty Name="ID" ColumnName="ID" />
  125. <ScalarProperty Name="Title" ColumnName="Title" />
  126. <ScalarProperty Name="Color" ColumnName="Color" />
  127. </MappingFragment>
  128. </EntityTypeMapping>
  129. </EntitySetMapping>
  130. <EntitySetMapping Name="учетка">
  131. <EntityTypeMapping TypeName="Model.учетка">
  132. <MappingFragment StoreEntitySet="учетка">
  133. <ScalarProperty Name="login" ColumnName="login" />
  134. <ScalarProperty Name="pass" ColumnName="pass" />
  135. </MappingFragment>
  136. </EntityTypeMapping>
  137. </EntitySetMapping>
  138. <AssociationSetMapping Name="AttachedProduct" TypeName="Model.AttachedProduct" StoreEntitySet="AttachedProduct">
  139. <EndProperty Name="Product">
  140. <ScalarProperty Name="ID" ColumnName="MainProductID" />
  141. </EndProperty>
  142. <EndProperty Name="Product1">
  143. <ScalarProperty Name="ID" ColumnName="AttachedProductID" />
  144. </EndProperty>
  145. </AssociationSetMapping>
  146. <AssociationSetMapping Name="TagOfClient" TypeName="Model.TagOfClient" StoreEntitySet="TagOfClient">
  147. <EndProperty Name="Client">
  148. <ScalarProperty Name="id" ColumnName="ClientID" />
  149. </EndProperty>
  150. <EndProperty Name="Tag">
  151. <ScalarProperty Name="ID" ColumnName="TagID" />
  152. </EndProperty>
  153. </AssociationSetMapping>
  154. </EntityContainerMapping>
  155. </Mapping>