Model1.msl 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  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="Девяток_ДЭEntities">
  4. <EntitySetMapping Name="Client">
  5. <EntityTypeMapping TypeName="Девяток_ДЭModel.Client">
  6. <MappingFragment StoreEntitySet="Client">
  7. <ScalarProperty Name="idClient" ColumnName="idClient" />
  8. <ScalarProperty Name="ClientSurname" ColumnName="ClientSurname" />
  9. <ScalarProperty Name="ClientName" ColumnName="ClientName" />
  10. <ScalarProperty Name="ClientPatronymic" ColumnName="ClientPatronymic" />
  11. <ScalarProperty Name="Phone" ColumnName="Phone" />
  12. </MappingFragment>
  13. </EntityTypeMapping>
  14. </EntitySetMapping>
  15. <EntitySetMapping Name="Order">
  16. <EntityTypeMapping TypeName="Девяток_ДЭModel.Order">
  17. <MappingFragment StoreEntitySet="Order">
  18. <ScalarProperty Name="OrderID" ColumnName="OrderID" />
  19. <ScalarProperty Name="OrderContains" ColumnName="OrderContains" />
  20. <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
  21. <ScalarProperty Name="OrderDeliveryDate" ColumnName="OrderDeliveryDate" />
  22. <ScalarProperty Name="id_point" ColumnName="id_point" />
  23. <ScalarProperty Name="idClient" ColumnName="idClient" />
  24. <ScalarProperty Name="code" ColumnName="code" />
  25. <ScalarProperty Name="OrderStatus" ColumnName="OrderStatus" />
  26. </MappingFragment>
  27. </EntityTypeMapping>
  28. </EntitySetMapping>
  29. <EntitySetMapping Name="OrderStatus">
  30. <EntityTypeMapping TypeName="Девяток_ДЭModel.OrderStatus">
  31. <MappingFragment StoreEntitySet="OrderStatus">
  32. <ScalarProperty Name="StatusID" ColumnName="StatusID" />
  33. <ScalarProperty Name="Status" ColumnName="Status" />
  34. </MappingFragment>
  35. </EntityTypeMapping>
  36. </EntitySetMapping>
  37. <EntitySetMapping Name="pickupPoint">
  38. <EntityTypeMapping TypeName="Девяток_ДЭModel.pickupPoint">
  39. <MappingFragment StoreEntitySet="pickupPoint">
  40. <ScalarProperty Name="id_int" ColumnName="id_int" />
  41. <ScalarProperty Name="index_point" ColumnName="index_point" />
  42. <ScalarProperty Name="city" ColumnName="city" />
  43. <ScalarProperty Name="street" ColumnName="street" />
  44. <ScalarProperty Name="number" ColumnName="number" />
  45. </MappingFragment>
  46. </EntityTypeMapping>
  47. </EntitySetMapping>
  48. <EntitySetMapping Name="Product">
  49. <EntityTypeMapping TypeName="Девяток_ДЭModel.Product">
  50. <MappingFragment StoreEntitySet="Product">
  51. <ScalarProperty Name="ProductArticleNumber" ColumnName="ProductArticleNumber" />
  52. <ScalarProperty Name="ProductName" ColumnName="ProductName" />
  53. <ScalarProperty Name="ProductDescription" ColumnName="ProductDescription" />
  54. <ScalarProperty Name="ProductCategory" ColumnName="ProductCategory" />
  55. <ScalarProperty Name="ProductPhoto" ColumnName="ProductPhoto" />
  56. <ScalarProperty Name="ProductManufacturer" ColumnName="ProductManufacturer" />
  57. <ScalarProperty Name="ProductCost" ColumnName="ProductCost" />
  58. <ScalarProperty Name="ProductDiscountAmount" ColumnName="ProductDiscountAmount" />
  59. <ScalarProperty Name="ProductQuantityInStock" ColumnName="ProductQuantityInStock" />
  60. </MappingFragment>
  61. </EntityTypeMapping>
  62. </EntitySetMapping>
  63. <EntitySetMapping Name="Role">
  64. <EntityTypeMapping TypeName="Девяток_ДЭModel.Role">
  65. <MappingFragment StoreEntitySet="Role">
  66. <ScalarProperty Name="RoleID" ColumnName="RoleID" />
  67. <ScalarProperty Name="RoleName" ColumnName="RoleName" />
  68. </MappingFragment>
  69. </EntityTypeMapping>
  70. </EntitySetMapping>
  71. <EntitySetMapping Name="sysdiagrams">
  72. <EntityTypeMapping TypeName="Девяток_ДЭModel.sysdiagrams">
  73. <MappingFragment StoreEntitySet="sysdiagrams">
  74. <ScalarProperty Name="name" ColumnName="name" />
  75. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  76. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  77. <ScalarProperty Name="version" ColumnName="version" />
  78. <ScalarProperty Name="definition" ColumnName="definition" />
  79. </MappingFragment>
  80. </EntityTypeMapping>
  81. </EntitySetMapping>
  82. <EntitySetMapping Name="User">
  83. <EntityTypeMapping TypeName="Девяток_ДЭModel.User">
  84. <MappingFragment StoreEntitySet="User">
  85. <ScalarProperty Name="UserID" ColumnName="UserID" />
  86. <ScalarProperty Name="UserSurname" ColumnName="UserSurname" />
  87. <ScalarProperty Name="UserName" ColumnName="UserName" />
  88. <ScalarProperty Name="UserPatronymic" ColumnName="UserPatronymic" />
  89. <ScalarProperty Name="UserLogin" ColumnName="UserLogin" />
  90. <ScalarProperty Name="UserPassword" ColumnName="UserPassword" />
  91. <ScalarProperty Name="UserRole" ColumnName="UserRole" />
  92. </MappingFragment>
  93. </EntityTypeMapping>
  94. </EntitySetMapping>
  95. <AssociationSetMapping Name="OrderProduct" TypeName="Девяток_ДЭModel.OrderProduct" StoreEntitySet="OrderProduct">
  96. <EndProperty Name="Order">
  97. <ScalarProperty Name="OrderID" ColumnName="OrderID" />
  98. </EndProperty>
  99. <EndProperty Name="Product">
  100. <ScalarProperty Name="ProductArticleNumber" ColumnName="ProductArticleNumber" />
  101. </EndProperty>
  102. </AssociationSetMapping>
  103. </EntityContainerMapping>
  104. </Mapping>