Model1.edmx 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463
  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="Хранилище Model" Provider="System.Data.SqlClient" ProviderManifestToken="2012" 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="Brand">
  9. <Key>
  10. <PropertyRef Name="id_Brand" />
  11. </Key>
  12. <Property Name="id_Brand" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="Label" Type="varchar" MaxLength="50" Nullable="false" />
  14. <Property Name="Country_of_origin" Type="varchar" MaxLength="50" Nullable="false" />
  15. </EntityType>
  16. <EntityType Name="Cheque">
  17. <Key>
  18. <PropertyRef Name="id_Cheque" />
  19. </Key>
  20. <Property Name="id_Cheque" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  21. <Property Name="Date_of_formation" Type="date" Nullable="false" />
  22. </EntityType>
  23. <EntityType Name="Components_of_Cheque">
  24. <Key>
  25. <PropertyRef Name="id_Components_of_the_cheque" />
  26. </Key>
  27. <Property Name="id_Components_of_the_cheque" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  28. <Property Name="id_Cheque" Type="int" Nullable="false" />
  29. <Property Name="id_Sneakers" Type="int" Nullable="false" />
  30. <Property Name="Quantity" Type="varchar" MaxLength="50" Nullable="false" />
  31. <Property Name="id_Users" Type="int" Nullable="false" />
  32. </EntityType>
  33. <EntityType Name="Gender">
  34. <Key>
  35. <PropertyRef Name="id_Gender" />
  36. </Key>
  37. <Property Name="id_Gender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  38. <Property Name="Gender" Type="varchar" MaxLength="50" />
  39. </EntityType>
  40. <EntityType Name="Role">
  41. <Key>
  42. <PropertyRef Name="id_Role" />
  43. </Key>
  44. <Property Name="id_Role" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  45. <Property Name="Role" Type="varchar" MaxLength="50" />
  46. </EntityType>
  47. <EntityType Name="Sneakers">
  48. <Key>
  49. <PropertyRef Name="id_Sneakers" />
  50. </Key>
  51. <Property Name="id_Sneakers" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  52. <Property Name="id_Brand" Type="int" Nullable="false" />
  53. <Property Name="Colors" Type="varchar" MaxLength="50" Nullable="false" />
  54. <Property Name="Price" Type="money" Nullable="false" />
  55. <Property Name="Model" Type="varchar" MaxLength="50" Nullable="false" />
  56. <Property Name="Size" Type="varchar" MaxLength="50" Nullable="false" />
  57. </EntityType>
  58. <EntityType Name="Users">
  59. <Key>
  60. <PropertyRef Name="id_Users" />
  61. </Key>
  62. <Property Name="id_Users" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  63. <Property Name="id_Gender" Type="int" />
  64. <Property Name="id_Role" Type="int" />
  65. <Property Name="Surname" Type="varchar" MaxLength="50" />
  66. <Property Name="Name" Type="varchar" MaxLength="50" />
  67. <Property Name="Patronymic" Type="varchar" MaxLength="50" />
  68. <Property Name="Login" Type="varchar" MaxLength="50" />
  69. <Property Name="Password" Type="varchar" MaxLength="256" />
  70. <Property Name="DateBirth" Type="date" />
  71. </EntityType>
  72. <Association Name="FK_Components_of_Cheque_Cheque">
  73. <End Role="Cheque" Type="Self.Cheque" Multiplicity="1" />
  74. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  75. <ReferentialConstraint>
  76. <Principal Role="Cheque">
  77. <PropertyRef Name="id_Cheque" />
  78. </Principal>
  79. <Dependent Role="Components_of_Cheque">
  80. <PropertyRef Name="id_Cheque" />
  81. </Dependent>
  82. </ReferentialConstraint>
  83. </Association>
  84. <Association Name="FK_Components_of_Cheque_Sneakers">
  85. <End Role="Sneakers" Type="Self.Sneakers" Multiplicity="1" />
  86. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  87. <ReferentialConstraint>
  88. <Principal Role="Sneakers">
  89. <PropertyRef Name="id_Sneakers" />
  90. </Principal>
  91. <Dependent Role="Components_of_Cheque">
  92. <PropertyRef Name="id_Sneakers" />
  93. </Dependent>
  94. </ReferentialConstraint>
  95. </Association>
  96. <Association Name="FK_Components_of_Cheque_Users">
  97. <End Role="Users" Type="Self.Users" Multiplicity="1" />
  98. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  99. <ReferentialConstraint>
  100. <Principal Role="Users">
  101. <PropertyRef Name="id_Users" />
  102. </Principal>
  103. <Dependent Role="Components_of_Cheque">
  104. <PropertyRef Name="id_Users" />
  105. </Dependent>
  106. </ReferentialConstraint>
  107. </Association>
  108. <Association Name="FK_Sneakers_Brand">
  109. <End Role="Brand" Type="Self.Brand" Multiplicity="1" />
  110. <End Role="Sneakers" Type="Self.Sneakers" Multiplicity="*" />
  111. <ReferentialConstraint>
  112. <Principal Role="Brand">
  113. <PropertyRef Name="id_Brand" />
  114. </Principal>
  115. <Dependent Role="Sneakers">
  116. <PropertyRef Name="id_Brand" />
  117. </Dependent>
  118. </ReferentialConstraint>
  119. </Association>
  120. <Association Name="FK_Users_Gender">
  121. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  122. <End Role="Users" Type="Self.Users" Multiplicity="*" />
  123. <ReferentialConstraint>
  124. <Principal Role="Gender">
  125. <PropertyRef Name="id_Gender" />
  126. </Principal>
  127. <Dependent Role="Users">
  128. <PropertyRef Name="id_Gender" />
  129. </Dependent>
  130. </ReferentialConstraint>
  131. </Association>
  132. <Association Name="FK_Users_Role">
  133. <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
  134. <End Role="Users" Type="Self.Users" Multiplicity="*" />
  135. <ReferentialConstraint>
  136. <Principal Role="Role">
  137. <PropertyRef Name="id_Role" />
  138. </Principal>
  139. <Dependent Role="Users">
  140. <PropertyRef Name="id_Role" />
  141. </Dependent>
  142. </ReferentialConstraint>
  143. </Association>
  144. <EntityContainer Name="Хранилище ModelContainer">
  145. <EntitySet Name="Brand" EntityType="Self.Brand" Schema="dbo" store:Type="Tables" />
  146. <EntitySet Name="Cheque" EntityType="Self.Cheque" Schema="dbo" store:Type="Tables" />
  147. <EntitySet Name="Components_of_Cheque" EntityType="Self.Components_of_Cheque" Schema="dbo" store:Type="Tables" />
  148. <EntitySet Name="Gender" EntityType="Self.Gender" Schema="dbo" store:Type="Tables" />
  149. <EntitySet Name="Role" EntityType="Self.Role" Schema="dbo" store:Type="Tables" />
  150. <EntitySet Name="Sneakers" EntityType="Self.Sneakers" Schema="dbo" store:Type="Tables" />
  151. <EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
  152. <AssociationSet Name="FK_Components_of_Cheque_Cheque" Association="Self.FK_Components_of_Cheque_Cheque">
  153. <End Role="Cheque" EntitySet="Cheque" />
  154. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  155. </AssociationSet>
  156. <AssociationSet Name="FK_Components_of_Cheque_Sneakers" Association="Self.FK_Components_of_Cheque_Sneakers">
  157. <End Role="Sneakers" EntitySet="Sneakers" />
  158. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  159. </AssociationSet>
  160. <AssociationSet Name="FK_Components_of_Cheque_Users" Association="Self.FK_Components_of_Cheque_Users">
  161. <End Role="Users" EntitySet="Users" />
  162. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  163. </AssociationSet>
  164. <AssociationSet Name="FK_Sneakers_Brand" Association="Self.FK_Sneakers_Brand">
  165. <End Role="Brand" EntitySet="Brand" />
  166. <End Role="Sneakers" EntitySet="Sneakers" />
  167. </AssociationSet>
  168. <AssociationSet Name="FK_Users_Gender" Association="Self.FK_Users_Gender">
  169. <End Role="Gender" EntitySet="Gender" />
  170. <End Role="Users" EntitySet="Users" />
  171. </AssociationSet>
  172. <AssociationSet Name="FK_Users_Role" Association="Self.FK_Users_Role">
  173. <End Role="Role" EntitySet="Role" />
  174. <End Role="Users" EntitySet="Users" />
  175. </AssociationSet>
  176. </EntityContainer>
  177. </Schema>
  178. </edmx:StorageModels>
  179. <!-- CSDL content -->
  180. <edmx:ConceptualModels>
  181. <Schema Namespace="Model" 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">
  182. <EntityType Name="Brand">
  183. <Key>
  184. <PropertyRef Name="id_Brand" />
  185. </Key>
  186. <Property Name="id_Brand" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  187. <Property Name="Label" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  188. <Property Name="Country_of_origin" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  189. <NavigationProperty Name="Sneakers" Relationship="Self.FK_Sneakers_Brand" FromRole="Brand" ToRole="Sneakers" />
  190. </EntityType>
  191. <EntityType Name="Cheque">
  192. <Key>
  193. <PropertyRef Name="id_Cheque" />
  194. </Key>
  195. <Property Name="id_Cheque" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  196. <Property Name="Date_of_formation" Type="DateTime" Nullable="false" Precision="0" />
  197. <NavigationProperty Name="Components_of_Cheque" Relationship="Self.FK_Components_of_Cheque_Cheque" FromRole="Cheque" ToRole="Components_of_Cheque" />
  198. </EntityType>
  199. <EntityType Name="Components_of_Cheque">
  200. <Key>
  201. <PropertyRef Name="id_Components_of_the_cheque" />
  202. </Key>
  203. <Property Name="id_Components_of_the_cheque" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  204. <Property Name="id_Cheque" Type="Int32" Nullable="false" />
  205. <Property Name="id_Sneakers" Type="Int32" Nullable="false" />
  206. <Property Name="Quantity" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  207. <Property Name="id_Users" Type="Int32" Nullable="false" />
  208. <NavigationProperty Name="Cheque" Relationship="Self.FK_Components_of_Cheque_Cheque" FromRole="Components_of_Cheque" ToRole="Cheque" />
  209. <NavigationProperty Name="Sneakers" Relationship="Self.FK_Components_of_Cheque_Sneakers" FromRole="Components_of_Cheque" ToRole="Sneakers" />
  210. <NavigationProperty Name="Users" Relationship="Self.FK_Components_of_Cheque_Users" FromRole="Components_of_Cheque" ToRole="Users" />
  211. </EntityType>
  212. <EntityType Name="Gender">
  213. <Key>
  214. <PropertyRef Name="id_Gender" />
  215. </Key>
  216. <Property Name="id_Gender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  217. <Property Name="Gender1" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  218. <NavigationProperty Name="Users" Relationship="Self.FK_Users_Gender" FromRole="Gender" ToRole="Users" />
  219. </EntityType>
  220. <EntityType Name="Role">
  221. <Key>
  222. <PropertyRef Name="id_Role" />
  223. </Key>
  224. <Property Name="id_Role" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  225. <Property Name="Role1" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  226. <NavigationProperty Name="Users" Relationship="Self.FK_Users_Role" FromRole="Role" ToRole="Users" />
  227. </EntityType>
  228. <EntityType Name="Sneakers">
  229. <Key>
  230. <PropertyRef Name="id_Sneakers" />
  231. </Key>
  232. <Property Name="id_Sneakers" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  233. <Property Name="id_Brand" Type="Int32" Nullable="false" />
  234. <Property Name="Colors" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  235. <Property Name="Price" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
  236. <Property Name="Model" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  237. <Property Name="Size" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
  238. <NavigationProperty Name="Brand" Relationship="Self.FK_Sneakers_Brand" FromRole="Sneakers" ToRole="Brand" />
  239. <NavigationProperty Name="Components_of_Cheque" Relationship="Self.FK_Components_of_Cheque_Sneakers" FromRole="Sneakers" ToRole="Components_of_Cheque" />
  240. </EntityType>
  241. <EntityType Name="Users">
  242. <Key>
  243. <PropertyRef Name="id_Users" />
  244. </Key>
  245. <Property Name="id_Users" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  246. <Property Name="id_Gender" Type="Int32" />
  247. <Property Name="id_Role" Type="Int32" />
  248. <Property Name="Surname" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  249. <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  250. <Property Name="Patronymic" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  251. <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  252. <Property Name="Password" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
  253. <Property Name="DateBirth" Type="DateTime" Precision="0" />
  254. <NavigationProperty Name="Components_of_Cheque" Relationship="Self.FK_Components_of_Cheque_Users" FromRole="Users" ToRole="Components_of_Cheque" />
  255. <NavigationProperty Name="Gender" Relationship="Self.FK_Users_Gender" FromRole="Users" ToRole="Gender" />
  256. <NavigationProperty Name="Role" Relationship="Self.FK_Users_Role" FromRole="Users" ToRole="Role" />
  257. </EntityType>
  258. <Association Name="FK_Sneakers_Brand">
  259. <End Role="Brand" Type="Self.Brand" Multiplicity="1" />
  260. <End Role="Sneakers" Type="Self.Sneakers" Multiplicity="*" />
  261. <ReferentialConstraint>
  262. <Principal Role="Brand">
  263. <PropertyRef Name="id_Brand" />
  264. </Principal>
  265. <Dependent Role="Sneakers">
  266. <PropertyRef Name="id_Brand" />
  267. </Dependent>
  268. </ReferentialConstraint>
  269. </Association>
  270. <Association Name="FK_Components_of_Cheque_Cheque">
  271. <End Role="Cheque" Type="Self.Cheque" Multiplicity="1" />
  272. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  273. <ReferentialConstraint>
  274. <Principal Role="Cheque">
  275. <PropertyRef Name="id_Cheque" />
  276. </Principal>
  277. <Dependent Role="Components_of_Cheque">
  278. <PropertyRef Name="id_Cheque" />
  279. </Dependent>
  280. </ReferentialConstraint>
  281. </Association>
  282. <Association Name="FK_Components_of_Cheque_Sneakers">
  283. <End Role="Sneakers" Type="Self.Sneakers" Multiplicity="1" />
  284. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  285. <ReferentialConstraint>
  286. <Principal Role="Sneakers">
  287. <PropertyRef Name="id_Sneakers" />
  288. </Principal>
  289. <Dependent Role="Components_of_Cheque">
  290. <PropertyRef Name="id_Sneakers" />
  291. </Dependent>
  292. </ReferentialConstraint>
  293. </Association>
  294. <Association Name="FK_Components_of_Cheque_Users">
  295. <End Role="Users" Type="Self.Users" Multiplicity="1" />
  296. <End Role="Components_of_Cheque" Type="Self.Components_of_Cheque" Multiplicity="*" />
  297. <ReferentialConstraint>
  298. <Principal Role="Users">
  299. <PropertyRef Name="id_Users" />
  300. </Principal>
  301. <Dependent Role="Components_of_Cheque">
  302. <PropertyRef Name="id_Users" />
  303. </Dependent>
  304. </ReferentialConstraint>
  305. </Association>
  306. <Association Name="FK_Users_Gender">
  307. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  308. <End Role="Users" Type="Self.Users" Multiplicity="*" />
  309. <ReferentialConstraint>
  310. <Principal Role="Gender">
  311. <PropertyRef Name="id_Gender" />
  312. </Principal>
  313. <Dependent Role="Users">
  314. <PropertyRef Name="id_Gender" />
  315. </Dependent>
  316. </ReferentialConstraint>
  317. </Association>
  318. <Association Name="FK_Users_Role">
  319. <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
  320. <End Role="Users" Type="Self.Users" Multiplicity="*" />
  321. <ReferentialConstraint>
  322. <Principal Role="Role">
  323. <PropertyRef Name="id_Role" />
  324. </Principal>
  325. <Dependent Role="Users">
  326. <PropertyRef Name="id_Role" />
  327. </Dependent>
  328. </ReferentialConstraint>
  329. </Association>
  330. <EntityContainer Name="Sniker" annotation:LazyLoadingEnabled="true">
  331. <EntitySet Name="Brand" EntityType="Self.Brand" />
  332. <EntitySet Name="Cheque" EntityType="Self.Cheque" />
  333. <EntitySet Name="Components_of_Cheque" EntityType="Self.Components_of_Cheque" />
  334. <EntitySet Name="Gender" EntityType="Self.Gender" />
  335. <EntitySet Name="Role" EntityType="Self.Role" />
  336. <EntitySet Name="Sneakers" EntityType="Self.Sneakers" />
  337. <EntitySet Name="Users" EntityType="Self.Users" />
  338. <AssociationSet Name="FK_Sneakers_Brand" Association="Self.FK_Sneakers_Brand">
  339. <End Role="Brand" EntitySet="Brand" />
  340. <End Role="Sneakers" EntitySet="Sneakers" />
  341. </AssociationSet>
  342. <AssociationSet Name="FK_Components_of_Cheque_Cheque" Association="Self.FK_Components_of_Cheque_Cheque">
  343. <End Role="Cheque" EntitySet="Cheque" />
  344. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  345. </AssociationSet>
  346. <AssociationSet Name="FK_Components_of_Cheque_Sneakers" Association="Self.FK_Components_of_Cheque_Sneakers">
  347. <End Role="Sneakers" EntitySet="Sneakers" />
  348. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  349. </AssociationSet>
  350. <AssociationSet Name="FK_Components_of_Cheque_Users" Association="Self.FK_Components_of_Cheque_Users">
  351. <End Role="Users" EntitySet="Users" />
  352. <End Role="Components_of_Cheque" EntitySet="Components_of_Cheque" />
  353. </AssociationSet>
  354. <AssociationSet Name="FK_Users_Gender" Association="Self.FK_Users_Gender">
  355. <End Role="Gender" EntitySet="Gender" />
  356. <End Role="Users" EntitySet="Users" />
  357. </AssociationSet>
  358. <AssociationSet Name="FK_Users_Role" Association="Self.FK_Users_Role">
  359. <End Role="Role" EntitySet="Role" />
  360. <End Role="Users" EntitySet="Users" />
  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="Хранилище ModelContainer" CdmEntityContainer="Sniker">
  369. <EntitySetMapping Name="Brand">
  370. <EntityTypeMapping TypeName="Model.Brand">
  371. <MappingFragment StoreEntitySet="Brand">
  372. <ScalarProperty Name="id_Brand" ColumnName="id_Brand" />
  373. <ScalarProperty Name="Label" ColumnName="Label" />
  374. <ScalarProperty Name="Country_of_origin" ColumnName="Country_of_origin" />
  375. </MappingFragment>
  376. </EntityTypeMapping>
  377. </EntitySetMapping>
  378. <EntitySetMapping Name="Cheque">
  379. <EntityTypeMapping TypeName="Model.Cheque">
  380. <MappingFragment StoreEntitySet="Cheque">
  381. <ScalarProperty Name="id_Cheque" ColumnName="id_Cheque" />
  382. <ScalarProperty Name="Date_of_formation" ColumnName="Date_of_formation" />
  383. </MappingFragment>
  384. </EntityTypeMapping>
  385. </EntitySetMapping>
  386. <EntitySetMapping Name="Components_of_Cheque">
  387. <EntityTypeMapping TypeName="Model.Components_of_Cheque">
  388. <MappingFragment StoreEntitySet="Components_of_Cheque">
  389. <ScalarProperty Name="id_Components_of_the_cheque" ColumnName="id_Components_of_the_cheque" />
  390. <ScalarProperty Name="id_Cheque" ColumnName="id_Cheque" />
  391. <ScalarProperty Name="id_Sneakers" ColumnName="id_Sneakers" />
  392. <ScalarProperty Name="Quantity" ColumnName="Quantity" />
  393. <ScalarProperty Name="id_Users" ColumnName="id_Users" />
  394. </MappingFragment>
  395. </EntityTypeMapping>
  396. </EntitySetMapping>
  397. <EntitySetMapping Name="Gender">
  398. <EntityTypeMapping TypeName="Model.Gender">
  399. <MappingFragment StoreEntitySet="Gender">
  400. <ScalarProperty Name="id_Gender" ColumnName="id_Gender" />
  401. <ScalarProperty Name="Gender1" ColumnName="Gender" />
  402. </MappingFragment>
  403. </EntityTypeMapping>
  404. </EntitySetMapping>
  405. <EntitySetMapping Name="Role">
  406. <EntityTypeMapping TypeName="Model.Role">
  407. <MappingFragment StoreEntitySet="Role">
  408. <ScalarProperty Name="id_Role" ColumnName="id_Role" />
  409. <ScalarProperty Name="Role1" ColumnName="Role" />
  410. </MappingFragment>
  411. </EntityTypeMapping>
  412. </EntitySetMapping>
  413. <EntitySetMapping Name="Sneakers">
  414. <EntityTypeMapping TypeName="Model.Sneakers">
  415. <MappingFragment StoreEntitySet="Sneakers">
  416. <ScalarProperty Name="id_Sneakers" ColumnName="id_Sneakers" />
  417. <ScalarProperty Name="id_Brand" ColumnName="id_Brand" />
  418. <ScalarProperty Name="Colors" ColumnName="Colors" />
  419. <ScalarProperty Name="Price" ColumnName="Price" />
  420. <ScalarProperty Name="Model" ColumnName="Model" />
  421. <ScalarProperty Name="Size" ColumnName="Size" />
  422. </MappingFragment>
  423. </EntityTypeMapping>
  424. </EntitySetMapping>
  425. <EntitySetMapping Name="Users">
  426. <EntityTypeMapping TypeName="Model.Users">
  427. <MappingFragment StoreEntitySet="Users">
  428. <ScalarProperty Name="id_Users" ColumnName="id_Users" />
  429. <ScalarProperty Name="id_Gender" ColumnName="id_Gender" />
  430. <ScalarProperty Name="id_Role" ColumnName="id_Role" />
  431. <ScalarProperty Name="Surname" ColumnName="Surname" />
  432. <ScalarProperty Name="Name" ColumnName="Name" />
  433. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  434. <ScalarProperty Name="Login" ColumnName="Login" />
  435. <ScalarProperty Name="Password" ColumnName="Password" />
  436. <ScalarProperty Name="DateBirth" ColumnName="DateBirth" />
  437. </MappingFragment>
  438. </EntityTypeMapping>
  439. </EntitySetMapping>
  440. </EntityContainerMapping>
  441. </Mapping>
  442. </edmx:Mappings>
  443. </edmx:Runtime>
  444. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  445. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  446. <Connection>
  447. <DesignerInfoPropertySet>
  448. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  449. </DesignerInfoPropertySet>
  450. </Connection>
  451. <Options>
  452. <DesignerInfoPropertySet>
  453. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  454. <DesignerProperty Name="EnablePluralization" Value="false" />
  455. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  456. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  457. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  458. </DesignerInfoPropertySet>
  459. </Options>
  460. <!-- Diagram content (shape and connector positions) -->
  461. <Diagrams></Diagrams>
  462. </Designer>
  463. </edmx:Edmx>