Model1.edmx 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="Хранилище Savelev_ToursModel" Provider="System.Data.SqlClient" ProviderManifestToken="2008" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityType Name="Country">
  9. <Key>
  10. <PropertyRef Name="Code" />
  11. </Key>
  12. <Property Name="Code" Type="nchar" MaxLength="2" Nullable="false" />
  13. <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
  14. </EntityType>
  15. <EntityType Name="Hotel">
  16. <Key>
  17. <PropertyRef Name="Id" />
  18. </Key>
  19. <Property Name="Id" Type="int" Nullable="false" />
  20. <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
  21. <Property Name="CountOfStars" Type="int" Nullable="false" />
  22. <Property Name="CountryCode" Type="nchar" MaxLength="2" Nullable="false" />
  23. </EntityType>
  24. <EntityType Name="HotelComment">
  25. <Key>
  26. <PropertyRef Name="Id" />
  27. </Key>
  28. <Property Name="Id" Type="int" Nullable="false" />
  29. <Property Name="HotelId" Type="int" Nullable="false" />
  30. <Property Name="Text" Type="nvarchar(max)" Nullable="false" />
  31. <Property Name="Author" Type="nvarchar" MaxLength="100" Nullable="false" />
  32. <Property Name="CreationDate" Type="datetime" Nullable="false" />
  33. </EntityType>
  34. <EntityType Name="HotelImage">
  35. <Key>
  36. <PropertyRef Name="Id" />
  37. </Key>
  38. <Property Name="Id" Type="int" Nullable="false" />
  39. <Property Name="HotelId" Type="int" Nullable="false" />
  40. <Property Name="ImageSource" Type="varbinary(max)" Nullable="false" />
  41. </EntityType>
  42. <EntityType Name="HotelOfTour">
  43. <Key>
  44. <PropertyRef Name="HotelId" />
  45. <PropertyRef Name="TourId" />
  46. </Key>
  47. <Property Name="HotelId" Type="int" Nullable="false" />
  48. <Property Name="TourId" Type="int" Nullable="false" />
  49. </EntityType>
  50. <EntityType Name="sysdiagrams">
  51. <Key>
  52. <PropertyRef Name="diagram_id" />
  53. </Key>
  54. <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
  55. <Property Name="principal_id" Type="int" Nullable="false" />
  56. <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  57. <Property Name="version" Type="int" />
  58. <Property Name="definition" Type="varbinary(max)" />
  59. </EntityType>
  60. <EntityType Name="Tour">
  61. <Key>
  62. <PropertyRef Name="Id" />
  63. </Key>
  64. <Property Name="Id" Type="int" Nullable="false" />
  65. <Property Name="TicketCount" Type="int" Nullable="false" />
  66. <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
  67. <Property Name="Description" Type="nvarchar(max)" />
  68. <Property Name="ImagePreview" Type="varbinary(max)" />
  69. <Property Name="Price" Type="money" Nullable="false" />
  70. <Property Name="IsActual" Type="bit" Nullable="false" />
  71. </EntityType>
  72. <EntityType Name="Type">
  73. <Key>
  74. <PropertyRef Name="Id" />
  75. </Key>
  76. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  77. <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
  78. <Property Name="Description" Type="nvarchar(max)" />
  79. </EntityType>
  80. <EntityType Name="TypeOfTour">
  81. <Key>
  82. <PropertyRef Name="TourId" />
  83. <PropertyRef Name="TypeId" />
  84. </Key>
  85. <Property Name="TourId" Type="int" Nullable="false" />
  86. <Property Name="TypeId" Type="int" Nullable="false" />
  87. </EntityType>
  88. <Association Name="FK_Hotel_Country">
  89. <End Role="Country" Type="Self.Country" Multiplicity="1" />
  90. <End Role="Hotel" Type="Self.Hotel" Multiplicity="*" />
  91. <ReferentialConstraint>
  92. <Principal Role="Country">
  93. <PropertyRef Name="Code" />
  94. </Principal>
  95. <Dependent Role="Hotel">
  96. <PropertyRef Name="CountryCode" />
  97. </Dependent>
  98. </ReferentialConstraint>
  99. </Association>
  100. <Association Name="FK_HotelComment_Hotel">
  101. <End Role="Hotel" Type="Self.Hotel" Multiplicity="1" />
  102. <End Role="HotelComment" Type="Self.HotelComment" Multiplicity="*" />
  103. <ReferentialConstraint>
  104. <Principal Role="Hotel">
  105. <PropertyRef Name="Id" />
  106. </Principal>
  107. <Dependent Role="HotelComment">
  108. <PropertyRef Name="HotelId" />
  109. </Dependent>
  110. </ReferentialConstraint>
  111. </Association>
  112. <Association Name="FK_HotelImage_Hotel">
  113. <End Role="Hotel" Type="Self.Hotel" Multiplicity="1" />
  114. <End Role="HotelImage" Type="Self.HotelImage" Multiplicity="*" />
  115. <ReferentialConstraint>
  116. <Principal Role="Hotel">
  117. <PropertyRef Name="Id" />
  118. </Principal>
  119. <Dependent Role="HotelImage">
  120. <PropertyRef Name="HotelId" />
  121. </Dependent>
  122. </ReferentialConstraint>
  123. </Association>
  124. <Association Name="FK_HotelOfTour_Hotel">
  125. <End Role="Hotel" Type="Self.Hotel" Multiplicity="1" />
  126. <End Role="HotelOfTour" Type="Self.HotelOfTour" Multiplicity="*" />
  127. <ReferentialConstraint>
  128. <Principal Role="Hotel">
  129. <PropertyRef Name="Id" />
  130. </Principal>
  131. <Dependent Role="HotelOfTour">
  132. <PropertyRef Name="HotelId" />
  133. </Dependent>
  134. </ReferentialConstraint>
  135. </Association>
  136. <Association Name="FK_HotelOfTour_Tour">
  137. <End Role="Tour" Type="Self.Tour" Multiplicity="1" />
  138. <End Role="HotelOfTour" Type="Self.HotelOfTour" Multiplicity="*" />
  139. <ReferentialConstraint>
  140. <Principal Role="Tour">
  141. <PropertyRef Name="Id" />
  142. </Principal>
  143. <Dependent Role="HotelOfTour">
  144. <PropertyRef Name="TourId" />
  145. </Dependent>
  146. </ReferentialConstraint>
  147. </Association>
  148. <Association Name="FK_TypeOfTour_Tour">
  149. <End Role="Tour" Type="Self.Tour" Multiplicity="1" />
  150. <End Role="TypeOfTour" Type="Self.TypeOfTour" Multiplicity="*" />
  151. <ReferentialConstraint>
  152. <Principal Role="Tour">
  153. <PropertyRef Name="Id" />
  154. </Principal>
  155. <Dependent Role="TypeOfTour">
  156. <PropertyRef Name="TourId" />
  157. </Dependent>
  158. </ReferentialConstraint>
  159. </Association>
  160. <Association Name="FK_TypeOfTour_Type">
  161. <End Role="Type" Type="Self.Type" Multiplicity="1" />
  162. <End Role="TypeOfTour" Type="Self.TypeOfTour" Multiplicity="*" />
  163. <ReferentialConstraint>
  164. <Principal Role="Type">
  165. <PropertyRef Name="Id" />
  166. </Principal>
  167. <Dependent Role="TypeOfTour">
  168. <PropertyRef Name="TypeId" />
  169. </Dependent>
  170. </ReferentialConstraint>
  171. </Association>
  172. <EntityContainer Name="Хранилище Savelev_ToursModelContainer">
  173. <EntitySet Name="Country" EntityType="Self.Country" Schema="dbo" store:Type="Tables" />
  174. <EntitySet Name="Hotel" EntityType="Self.Hotel" Schema="dbo" store:Type="Tables" />
  175. <EntitySet Name="HotelComment" EntityType="Self.HotelComment" Schema="dbo" store:Type="Tables" />
  176. <EntitySet Name="HotelImage" EntityType="Self.HotelImage" Schema="dbo" store:Type="Tables" />
  177. <EntitySet Name="HotelOfTour" EntityType="Self.HotelOfTour" Schema="dbo" store:Type="Tables" />
  178. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
  179. <EntitySet Name="Tour" EntityType="Self.Tour" Schema="dbo" store:Type="Tables" />
  180. <EntitySet Name="Type" EntityType="Self.Type" Schema="dbo" store:Type="Tables" />
  181. <EntitySet Name="TypeOfTour" EntityType="Self.TypeOfTour" Schema="dbo" store:Type="Tables" />
  182. <AssociationSet Name="FK_Hotel_Country" Association="Self.FK_Hotel_Country">
  183. <End Role="Country" EntitySet="Country" />
  184. <End Role="Hotel" EntitySet="Hotel" />
  185. </AssociationSet>
  186. <AssociationSet Name="FK_HotelComment_Hotel" Association="Self.FK_HotelComment_Hotel">
  187. <End Role="Hotel" EntitySet="Hotel" />
  188. <End Role="HotelComment" EntitySet="HotelComment" />
  189. </AssociationSet>
  190. <AssociationSet Name="FK_HotelImage_Hotel" Association="Self.FK_HotelImage_Hotel">
  191. <End Role="Hotel" EntitySet="Hotel" />
  192. <End Role="HotelImage" EntitySet="HotelImage" />
  193. </AssociationSet>
  194. <AssociationSet Name="FK_HotelOfTour_Hotel" Association="Self.FK_HotelOfTour_Hotel">
  195. <End Role="Hotel" EntitySet="Hotel" />
  196. <End Role="HotelOfTour" EntitySet="HotelOfTour" />
  197. </AssociationSet>
  198. <AssociationSet Name="FK_HotelOfTour_Tour" Association="Self.FK_HotelOfTour_Tour">
  199. <End Role="Tour" EntitySet="Tour" />
  200. <End Role="HotelOfTour" EntitySet="HotelOfTour" />
  201. </AssociationSet>
  202. <AssociationSet Name="FK_TypeOfTour_Tour" Association="Self.FK_TypeOfTour_Tour">
  203. <End Role="Tour" EntitySet="Tour" />
  204. <End Role="TypeOfTour" EntitySet="TypeOfTour" />
  205. </AssociationSet>
  206. <AssociationSet Name="FK_TypeOfTour_Type" Association="Self.FK_TypeOfTour_Type">
  207. <End Role="Type" EntitySet="Type" />
  208. <End Role="TypeOfTour" EntitySet="TypeOfTour" />
  209. </AssociationSet>
  210. </EntityContainer>
  211. </Schema>
  212. </edmx:StorageModels>
  213. <!-- CSDL content -->
  214. <edmx:ConceptualModels>
  215. <Schema Namespace="Savelev_ToursModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  216. <EntityType Name="Country">
  217. <Key>
  218. <PropertyRef Name="Code" />
  219. </Key>
  220. <Property Name="Code" Type="String" MaxLength="2" FixedLength="true" Unicode="true" Nullable="false" />
  221. <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  222. <NavigationProperty Name="Hotel" Relationship="Self.FK_Hotel_Country" FromRole="Country" ToRole="Hotel" />
  223. </EntityType>
  224. <EntityType Name="Hotel">
  225. <Key>
  226. <PropertyRef Name="Id" />
  227. </Key>
  228. <Property Name="Id" Type="Int32" Nullable="false" />
  229. <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  230. <Property Name="CountOfStars" Type="Int32" Nullable="false" />
  231. <Property Name="CountryCode" Type="String" MaxLength="2" FixedLength="true" Unicode="true" Nullable="false" />
  232. <NavigationProperty Name="Country" Relationship="Self.FK_Hotel_Country" FromRole="Hotel" ToRole="Country" />
  233. <NavigationProperty Name="HotelComment" Relationship="Self.FK_HotelComment_Hotel" FromRole="Hotel" ToRole="HotelComment" />
  234. <NavigationProperty Name="HotelImage" Relationship="Self.FK_HotelImage_Hotel" FromRole="Hotel" ToRole="HotelImage" />
  235. <NavigationProperty Name="Tour" Relationship="Self.HotelOfTour" FromRole="Hotel" ToRole="Tour" />
  236. </EntityType>
  237. <EntityType Name="HotelComment">
  238. <Key>
  239. <PropertyRef Name="Id" />
  240. </Key>
  241. <Property Name="Id" Type="Int32" Nullable="false" />
  242. <Property Name="HotelId" Type="Int32" Nullable="false" />
  243. <Property Name="Text" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
  244. <Property Name="Author" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  245. <Property Name="CreationDate" Type="DateTime" Nullable="false" Precision="3" />
  246. <NavigationProperty Name="Hotel" Relationship="Self.FK_HotelComment_Hotel" FromRole="HotelComment" ToRole="Hotel" />
  247. </EntityType>
  248. <EntityType Name="HotelImage">
  249. <Key>
  250. <PropertyRef Name="Id" />
  251. </Key>
  252. <Property Name="Id" Type="Int32" Nullable="false" />
  253. <Property Name="HotelId" Type="Int32" Nullable="false" />
  254. <Property Name="ImageSource" Type="Binary" MaxLength="Max" FixedLength="false" Nullable="false" />
  255. <NavigationProperty Name="Hotel" Relationship="Self.FK_HotelImage_Hotel" FromRole="HotelImage" ToRole="Hotel" />
  256. </EntityType>
  257. <EntityType Name="sysdiagrams">
  258. <Key>
  259. <PropertyRef Name="diagram_id" />
  260. </Key>
  261. <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
  262. <Property Name="principal_id" Type="Int32" Nullable="false" />
  263. <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  264. <Property Name="version" Type="Int32" />
  265. <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
  266. </EntityType>
  267. <EntityType Name="Tour">
  268. <Key>
  269. <PropertyRef Name="Id" />
  270. </Key>
  271. <Property Name="Id" Type="Int32" Nullable="false" />
  272. <Property Name="TicketCount" Type="Int32" Nullable="false" />
  273. <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  274. <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  275. <Property Name="ImagePreview" Type="Binary" MaxLength="Max" FixedLength="false" />
  276. <Property Name="Price" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
  277. <Property Name="IsActual" Type="Boolean" Nullable="false" />
  278. <NavigationProperty Name="Hotel" Relationship="Self.HotelOfTour" FromRole="Tour" ToRole="Hotel" />
  279. <NavigationProperty Name="Type" Relationship="Self.TypeOfTour" FromRole="Tour" ToRole="Type" />
  280. </EntityType>
  281. <EntityType Name="Type">
  282. <Key>
  283. <PropertyRef Name="Id" />
  284. </Key>
  285. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  286. <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
  287. <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  288. <NavigationProperty Name="Tour" Relationship="Self.TypeOfTour" FromRole="Type" ToRole="Tour" />
  289. </EntityType>
  290. <Association Name="FK_Hotel_Country">
  291. <End Role="Country" Type="Self.Country" Multiplicity="1" />
  292. <End Role="Hotel" Type="Self.Hotel" Multiplicity="*" />
  293. <ReferentialConstraint>
  294. <Principal Role="Country">
  295. <PropertyRef Name="Code" />
  296. </Principal>
  297. <Dependent Role="Hotel">
  298. <PropertyRef Name="CountryCode" />
  299. </Dependent>
  300. </ReferentialConstraint>
  301. </Association>
  302. <Association Name="FK_HotelComment_Hotel">
  303. <End Role="Hotel" Type="Self.Hotel" Multiplicity="1" />
  304. <End Role="HotelComment" Type="Self.HotelComment" Multiplicity="*" />
  305. <ReferentialConstraint>
  306. <Principal Role="Hotel">
  307. <PropertyRef Name="Id" />
  308. </Principal>
  309. <Dependent Role="HotelComment">
  310. <PropertyRef Name="HotelId" />
  311. </Dependent>
  312. </ReferentialConstraint>
  313. </Association>
  314. <Association Name="FK_HotelImage_Hotel">
  315. <End Role="Hotel" Type="Self.Hotel" Multiplicity="1" />
  316. <End Role="HotelImage" Type="Self.HotelImage" Multiplicity="*" />
  317. <ReferentialConstraint>
  318. <Principal Role="Hotel">
  319. <PropertyRef Name="Id" />
  320. </Principal>
  321. <Dependent Role="HotelImage">
  322. <PropertyRef Name="HotelId" />
  323. </Dependent>
  324. </ReferentialConstraint>
  325. </Association>
  326. <Association Name="HotelOfTour">
  327. <End Role="Hotel" Type="Self.Hotel" Multiplicity="*" />
  328. <End Role="Tour" Type="Self.Tour" Multiplicity="*" />
  329. </Association>
  330. <Association Name="TypeOfTour">
  331. <End Role="Tour" Type="Self.Tour" Multiplicity="*" />
  332. <End Role="Type" Type="Self.Type" Multiplicity="*" />
  333. </Association>
  334. <EntityContainer Name="Savelev_ToursEntities" annotation:LazyLoadingEnabled="true">
  335. <EntitySet Name="Country" EntityType="Self.Country" />
  336. <EntitySet Name="Hotel" EntityType="Self.Hotel" />
  337. <EntitySet Name="HotelComment" EntityType="Self.HotelComment" />
  338. <EntitySet Name="HotelImage" EntityType="Self.HotelImage" />
  339. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
  340. <EntitySet Name="Tour" EntityType="Self.Tour" />
  341. <EntitySet Name="Type" EntityType="Self.Type" />
  342. <AssociationSet Name="FK_Hotel_Country" Association="Self.FK_Hotel_Country">
  343. <End Role="Country" EntitySet="Country" />
  344. <End Role="Hotel" EntitySet="Hotel" />
  345. </AssociationSet>
  346. <AssociationSet Name="FK_HotelComment_Hotel" Association="Self.FK_HotelComment_Hotel">
  347. <End Role="Hotel" EntitySet="Hotel" />
  348. <End Role="HotelComment" EntitySet="HotelComment" />
  349. </AssociationSet>
  350. <AssociationSet Name="FK_HotelImage_Hotel" Association="Self.FK_HotelImage_Hotel">
  351. <End Role="Hotel" EntitySet="Hotel" />
  352. <End Role="HotelImage" EntitySet="HotelImage" />
  353. </AssociationSet>
  354. <AssociationSet Name="HotelOfTour" Association="Self.HotelOfTour">
  355. <End Role="Hotel" EntitySet="Hotel" />
  356. <End Role="Tour" EntitySet="Tour" />
  357. </AssociationSet>
  358. <AssociationSet Name="TypeOfTour" Association="Self.TypeOfTour">
  359. <End Role="Tour" EntitySet="Tour" />
  360. <End Role="Type" EntitySet="Type" />
  361. </AssociationSet>
  362. </EntityContainer>
  363. </Schema>
  364. </edmx:ConceptualModels>
  365. <!-- C-S mapping content -->
  366. <edmx:Mappings>
  367. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  368. <EntityContainerMapping StorageEntityContainer="Хранилище Savelev_ToursModelContainer" CdmEntityContainer="Savelev_ToursEntities">
  369. <EntitySetMapping Name="Country">
  370. <EntityTypeMapping TypeName="Savelev_ToursModel.Country">
  371. <MappingFragment StoreEntitySet="Country">
  372. <ScalarProperty Name="Code" ColumnName="Code" />
  373. <ScalarProperty Name="Name" ColumnName="Name" />
  374. </MappingFragment>
  375. </EntityTypeMapping>
  376. </EntitySetMapping>
  377. <EntitySetMapping Name="Hotel">
  378. <EntityTypeMapping TypeName="Savelev_ToursModel.Hotel">
  379. <MappingFragment StoreEntitySet="Hotel">
  380. <ScalarProperty Name="Id" ColumnName="Id" />
  381. <ScalarProperty Name="Name" ColumnName="Name" />
  382. <ScalarProperty Name="CountOfStars" ColumnName="CountOfStars" />
  383. <ScalarProperty Name="CountryCode" ColumnName="CountryCode" />
  384. </MappingFragment>
  385. </EntityTypeMapping>
  386. </EntitySetMapping>
  387. <EntitySetMapping Name="HotelComment">
  388. <EntityTypeMapping TypeName="Savelev_ToursModel.HotelComment">
  389. <MappingFragment StoreEntitySet="HotelComment">
  390. <ScalarProperty Name="Id" ColumnName="Id" />
  391. <ScalarProperty Name="HotelId" ColumnName="HotelId" />
  392. <ScalarProperty Name="Text" ColumnName="Text" />
  393. <ScalarProperty Name="Author" ColumnName="Author" />
  394. <ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
  395. </MappingFragment>
  396. </EntityTypeMapping>
  397. </EntitySetMapping>
  398. <EntitySetMapping Name="HotelImage">
  399. <EntityTypeMapping TypeName="Savelev_ToursModel.HotelImage">
  400. <MappingFragment StoreEntitySet="HotelImage">
  401. <ScalarProperty Name="Id" ColumnName="Id" />
  402. <ScalarProperty Name="HotelId" ColumnName="HotelId" />
  403. <ScalarProperty Name="ImageSource" ColumnName="ImageSource" />
  404. </MappingFragment>
  405. </EntityTypeMapping>
  406. </EntitySetMapping>
  407. <EntitySetMapping Name="sysdiagrams">
  408. <EntityTypeMapping TypeName="Savelev_ToursModel.sysdiagrams">
  409. <MappingFragment StoreEntitySet="sysdiagrams">
  410. <ScalarProperty Name="name" ColumnName="name" />
  411. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  412. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  413. <ScalarProperty Name="version" ColumnName="version" />
  414. <ScalarProperty Name="definition" ColumnName="definition" />
  415. </MappingFragment>
  416. </EntityTypeMapping>
  417. </EntitySetMapping>
  418. <EntitySetMapping Name="Tour">
  419. <EntityTypeMapping TypeName="Savelev_ToursModel.Tour">
  420. <MappingFragment StoreEntitySet="Tour">
  421. <ScalarProperty Name="Id" ColumnName="Id" />
  422. <ScalarProperty Name="TicketCount" ColumnName="TicketCount" />
  423. <ScalarProperty Name="Name" ColumnName="Name" />
  424. <ScalarProperty Name="Description" ColumnName="Description" />
  425. <ScalarProperty Name="ImagePreview" ColumnName="ImagePreview" />
  426. <ScalarProperty Name="Price" ColumnName="Price" />
  427. <ScalarProperty Name="IsActual" ColumnName="IsActual" />
  428. </MappingFragment>
  429. </EntityTypeMapping>
  430. </EntitySetMapping>
  431. <EntitySetMapping Name="Type">
  432. <EntityTypeMapping TypeName="Savelev_ToursModel.Type">
  433. <MappingFragment StoreEntitySet="Type">
  434. <ScalarProperty Name="Id" ColumnName="Id" />
  435. <ScalarProperty Name="Name" ColumnName="Name" />
  436. <ScalarProperty Name="Description" ColumnName="Description" />
  437. </MappingFragment>
  438. </EntityTypeMapping>
  439. </EntitySetMapping>
  440. <AssociationSetMapping Name="HotelOfTour" TypeName="Savelev_ToursModel.HotelOfTour" StoreEntitySet="HotelOfTour">
  441. <EndProperty Name="Hotel">
  442. <ScalarProperty Name="Id" ColumnName="HotelId" />
  443. </EndProperty>
  444. <EndProperty Name="Tour">
  445. <ScalarProperty Name="Id" ColumnName="TourId" />
  446. </EndProperty>
  447. </AssociationSetMapping>
  448. <AssociationSetMapping Name="TypeOfTour" TypeName="Savelev_ToursModel.TypeOfTour" StoreEntitySet="TypeOfTour">
  449. <EndProperty Name="Tour">
  450. <ScalarProperty Name="Id" ColumnName="TourId" />
  451. </EndProperty>
  452. <EndProperty Name="Type">
  453. <ScalarProperty Name="Id" ColumnName="TypeId" />
  454. </EndProperty>
  455. </AssociationSetMapping>
  456. </EntityContainerMapping>
  457. </Mapping>
  458. </edmx:Mappings>
  459. </edmx:Runtime>
  460. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  461. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  462. <Connection>
  463. <DesignerInfoPropertySet>
  464. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  465. </DesignerInfoPropertySet>
  466. </Connection>
  467. <Options>
  468. <DesignerInfoPropertySet>
  469. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  470. <DesignerProperty Name="EnablePluralization" Value="false" />
  471. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  472. <DesignerProperty Name="UseLegacyProvider" Value="true" />
  473. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  474. </DesignerInfoPropertySet>
  475. </Options>
  476. <!-- Diagram content (shape and connector positions) -->
  477. <Diagrams></Diagrams>
  478. </Designer>
  479. </edmx:Edmx>