BaseModel.msl 9.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
  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="Хранилище KarpovTuriModelContainer" CdmEntityContainer="KarpovTuriEntities1">
  4. <EntitySetMapping Name="Country">
  5. <EntityTypeMapping TypeName="KarpovTuriModel.Country">
  6. <MappingFragment StoreEntitySet="Country">
  7. <ScalarProperty Name="id_country" ColumnName="id_country" />
  8. <ScalarProperty Name="Name" ColumnName="Name" />
  9. </MappingFragment>
  10. </EntityTypeMapping>
  11. </EntitySetMapping>
  12. <EntitySetMapping Name="Hotel">
  13. <EntityTypeMapping TypeName="KarpovTuriModel.Hotel">
  14. <MappingFragment StoreEntitySet="Hotel">
  15. <ScalarProperty Name="id_hotel" ColumnName="id_hotel" />
  16. <ScalarProperty Name="Name" ColumnName="Name" />
  17. <ScalarProperty Name="CountOfStars" ColumnName="CountOfStars" />
  18. <ScalarProperty Name="id_country" ColumnName="id_country" />
  19. </MappingFragment>
  20. </EntityTypeMapping>
  21. </EntitySetMapping>
  22. <EntitySetMapping Name="HotelComment">
  23. <EntityTypeMapping TypeName="KarpovTuriModel.HotelComment">
  24. <MappingFragment StoreEntitySet="HotelComment">
  25. <ScalarProperty Name="Id_com" ColumnName="Id_com" />
  26. <ScalarProperty Name="id_hotel" ColumnName="id_hotel" />
  27. <ScalarProperty Name="Text" ColumnName="Text" />
  28. <ScalarProperty Name="Author" ColumnName="Author" />
  29. <ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
  30. </MappingFragment>
  31. </EntityTypeMapping>
  32. </EntitySetMapping>
  33. <EntitySetMapping Name="HotelImage">
  34. <EntityTypeMapping TypeName="KarpovTuriModel.HotelImage">
  35. <MappingFragment StoreEntitySet="HotelImage">
  36. <ScalarProperty Name="id_img" ColumnName="id_img" />
  37. <ScalarProperty Name="id_hotel" ColumnName="id_hotel" />
  38. <ScalarProperty Name="ImageSource" ColumnName="ImageSource" />
  39. </MappingFragment>
  40. </EntityTypeMapping>
  41. </EntitySetMapping>
  42. <EntitySetMapping Name="sysdiagrams">
  43. <EntityTypeMapping TypeName="KarpovTuriModel.sysdiagrams">
  44. <MappingFragment StoreEntitySet="sysdiagrams">
  45. <ScalarProperty Name="name" ColumnName="name" />
  46. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  47. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  48. <ScalarProperty Name="version" ColumnName="version" />
  49. <ScalarProperty Name="definition" ColumnName="definition" />
  50. </MappingFragment>
  51. </EntityTypeMapping>
  52. </EntitySetMapping>
  53. <EntitySetMapping Name="Tour">
  54. <EntityTypeMapping TypeName="KarpovTuriModel.Tour">
  55. <MappingFragment StoreEntitySet="Tour">
  56. <ScalarProperty Name="id_tour" ColumnName="id_tour" />
  57. <ScalarProperty Name="TicketNum" ColumnName="TicketNum" />
  58. <ScalarProperty Name="Name" ColumnName="Name" />
  59. <ScalarProperty Name="Description" ColumnName="Description" />
  60. <ScalarProperty Name="ImagePreview" ColumnName="ImagePreview" />
  61. <ScalarProperty Name="Price" ColumnName="Price" />
  62. <ScalarProperty Name="IsActual" ColumnName="IsActual" />
  63. </MappingFragment>
  64. </EntityTypeMapping>
  65. </EntitySetMapping>
  66. <EntitySetMapping Name="Type">
  67. <EntityTypeMapping TypeName="KarpovTuriModel.Type">
  68. <MappingFragment StoreEntitySet="Type">
  69. <ScalarProperty Name="id_type" ColumnName="id_type" />
  70. <ScalarProperty Name="Name" ColumnName="Name" />
  71. <ScalarProperty Name="Description" ColumnName="Description" />
  72. </MappingFragment>
  73. </EntityTypeMapping>
  74. </EntitySetMapping>
  75. <EntitySetMapping Name="Count_hotel">
  76. <EntityTypeMapping TypeName="KarpovTuriModel.Count_hotel">
  77. <MappingFragment StoreEntitySet="Count_hotel">
  78. <ScalarProperty Name="Название_отеля" ColumnName="Название отеля" />
  79. <ScalarProperty Name="Количество_звёзд" ColumnName="Количество звёзд" />
  80. <ScalarProperty Name="Страна" ColumnName="Страна" />
  81. </MappingFragment>
  82. </EntityTypeMapping>
  83. </EntitySetMapping>
  84. <EntitySetMapping Name="Description">
  85. <EntityTypeMapping TypeName="KarpovTuriModel.Description">
  86. <MappingFragment StoreEntitySet="Description">
  87. <ScalarProperty Name="Название_тура" ColumnName="Название тура" />
  88. <ScalarProperty Name="Превью" ColumnName="Превью" />
  89. <ScalarProperty Name="Цена" ColumnName="Цена" />
  90. <ScalarProperty Name="Тип" ColumnName="Тип" />
  91. <ScalarProperty Name="Описание" ColumnName="Описание" />
  92. </MappingFragment>
  93. </EntityTypeMapping>
  94. </EntitySetMapping>
  95. <EntitySetMapping Name="Hotel_Desc">
  96. <EntityTypeMapping TypeName="KarpovTuriModel.Hotel_Desc">
  97. <MappingFragment StoreEntitySet="Hotel_Desc">
  98. <ScalarProperty Name="Название_отеля" ColumnName="Название отеля" />
  99. <ScalarProperty Name="Картинка" ColumnName="Картинка" />
  100. <ScalarProperty Name="Автор" ColumnName="Автор" />
  101. <ScalarProperty Name="Описание" ColumnName="Описание" />
  102. </MappingFragment>
  103. </EntityTypeMapping>
  104. </EntitySetMapping>
  105. <EntitySetMapping Name="TourView">
  106. <EntityTypeMapping TypeName="KarpovTuriModel.TourView">
  107. <MappingFragment StoreEntitySet="TourView">
  108. <ScalarProperty Name="Название_страны" ColumnName="Название страны" />
  109. <ScalarProperty Name="Название_отеля" ColumnName="Название отеля" />
  110. <ScalarProperty Name="Количество_звёзд" ColumnName="Количество звёзд" />
  111. <ScalarProperty Name="Номер_билета" ColumnName="Номер билета" />
  112. <ScalarProperty Name="Название_тура" ColumnName="Название тура" />
  113. <ScalarProperty Name="Превью" ColumnName="Превью" />
  114. <ScalarProperty Name="Цена" ColumnName="Цена" />
  115. <ScalarProperty Name="Актуальность" ColumnName="Актуальность" />
  116. <ScalarProperty Name="Тип_тура" ColumnName="Тип тура" />
  117. <ScalarProperty Name="Описание" ColumnName="Описание" />
  118. </MappingFragment>
  119. </EntityTypeMapping>
  120. </EntitySetMapping>
  121. <AssociationSetMapping Name="HotelOfTour" TypeName="KarpovTuriModel.HotelOfTour" StoreEntitySet="HotelOfTour">
  122. <EndProperty Name="Hotel">
  123. <ScalarProperty Name="id_hotel" ColumnName="id_hotel" />
  124. </EndProperty>
  125. <EndProperty Name="Tour">
  126. <ScalarProperty Name="id_tour" ColumnName="id_tour" />
  127. </EndProperty>
  128. </AssociationSetMapping>
  129. <AssociationSetMapping Name="TypeOfTour" TypeName="KarpovTuriModel.TypeOfTour" StoreEntitySet="TypeOfTour">
  130. <EndProperty Name="Tour">
  131. <ScalarProperty Name="id_tour" ColumnName="id_tour" />
  132. </EndProperty>
  133. <EndProperty Name="Type">
  134. <ScalarProperty Name="id_type" ColumnName="id_type" />
  135. </EndProperty>
  136. </AssociationSetMapping>
  137. <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Хранилище KarpovTuriModel.sp_alterdiagram" />
  138. <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Хранилище KarpovTuriModel.sp_creatediagram" />
  139. <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Хранилище KarpovTuriModel.sp_dropdiagram" />
  140. <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Хранилище KarpovTuriModel.sp_helpdiagramdefinition">
  141. <ResultMapping>
  142. <ComplexTypeMapping TypeName="KarpovTuriModel.sp_helpdiagramdefinition_Result">
  143. <ScalarProperty Name="version" ColumnName="version" />
  144. <ScalarProperty Name="definition" ColumnName="definition" />
  145. </ComplexTypeMapping>
  146. </ResultMapping>
  147. </FunctionImportMapping>
  148. <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Хранилище KarpovTuriModel.sp_helpdiagrams">
  149. <ResultMapping>
  150. <ComplexTypeMapping TypeName="KarpovTuriModel.sp_helpdiagrams_Result">
  151. <ScalarProperty Name="Database" ColumnName="Database" />
  152. <ScalarProperty Name="Name" ColumnName="Name" />
  153. <ScalarProperty Name="ID" ColumnName="ID" />
  154. <ScalarProperty Name="Owner" ColumnName="Owner" />
  155. <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
  156. </ComplexTypeMapping>
  157. </ResultMapping>
  158. </FunctionImportMapping>
  159. <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Хранилище KarpovTuriModel.sp_renamediagram" />
  160. <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Хранилище KarpovTuriModel.sp_upgraddiagrams" />
  161. </EntityContainerMapping>
  162. </Mapping>