Нет описания

Model1.edmx 6.5KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="labModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  8. <EntityContainer Name="labModelStoreContainer">
  9. <EntitySet Name="users" EntityType="labModel.Store.users" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
  10. </EntityContainer>
  11. <EntityType Name="users">
  12. <Key>
  13. <PropertyRef Name="id" />
  14. </Key>
  15. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  16. <Property Name="email" Type="nchar" MaxLength="40" />
  17. <Property Name="hashed_password" Type="nchar" MaxLength="250" />
  18. <Property Name="created_at" Type="datetime" />
  19. <Property Name="updated_at" Type="datetime" />
  20. <Property Name="active" Type="bit" />
  21. </EntityType>
  22. <!--Errors Found During Generation:
  23. warning 6013: The table/view 'lab.dbo.v_master_view' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
  24. <EntityType Name="v_master_view">
  25. <Property Name="PRO1" Type="float" />
  26. <Property Name="PRO1C" Type="nvarchar" MaxLength="255" />
  27. <Property Name="PRO2" Type="nvarchar" MaxLength="255" />
  28. <Property Name="PRO5" Type="float" />
  29. <Property Name="PRO8" Type="float" />
  30. <Property Name="PRO9" Type="nvarchar" MaxLength="255" />
  31. <Property Name="PRO10" Type="float" />
  32. <Property Name="PRO11" Type="float" />
  33. <Property Name="PRO12" Type="float" />
  34. <Property Name="PRO13" Type="nvarchar" MaxLength="255" />
  35. <Property Name="PRO14" Type="float" />
  36. <Property Name="PRO15" Type="nvarchar" MaxLength="255" />
  37. <Property Name="PRO16" Type="float" />
  38. <Property Name="PRO17" Type="nvarchar" MaxLength="255" />
  39. <Property Name="PRO18" Type="nvarchar" MaxLength="255" />
  40. <Property Name="MC23" Type="nvarchar" MaxLength="255" />
  41. <Property Name="MC20" Type="float" />
  42. <Property Name="MP34" Type="nvarchar" MaxLength="255" />
  43. <Property Name="MP39" Type="nvarchar" MaxLength="255" />
  44. <Property Name="MI13" Type="float" />
  45. <Property Name="TC" Type="float" />
  46. <Property Name="MI14" Type="float" />
  47. <Property Name="MI15" Type="float" />
  48. <Property Name="MI16" Type="float" />
  49. <Property Name="MI17" Type="nvarchar" MaxLength="255" />
  50. <Property Name="MI18" Type="float" />
  51. <Property Name="MI19" Type="float" />
  52. <Property Name="MI20" Type="float" />
  53. <Property Name="MI21" Type="nvarchar" MaxLength="255" />
  54. <Property Name="MI22" Type="float" />
  55. <Property Name="MI23" Type="float" />
  56. <Property Name="MI31" Type="nvarchar" MaxLength="255" />
  57. <Property Name="MI33" Type="nvarchar" MaxLength="255" />
  58. <Property Name="INSAGM" Type="nvarchar" MaxLength="255" />
  59. <Property Name="MARAGM" Type="nvarchar" MaxLength="255" />
  60. </EntityType>-->
  61. </Schema>
  62. </edmx:StorageModels>
  63. <!-- CSDL content -->
  64. <edmx:ConceptualModels>
  65. <Schema Namespace="labModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2008/09/edm" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
  66. <EntityContainer Name="labEntities" annotation:LazyLoadingEnabled="true">
  67. <EntitySet Name="users" EntityType="labModel.user" />
  68. </EntityContainer>
  69. <EntityType Name="user">
  70. <Key>
  71. <PropertyRef Name="id" />
  72. </Key>
  73. <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  74. <Property Name="email" Type="String" MaxLength="40" Unicode="true" FixedLength="true" />
  75. <Property Name="hashed_password" Type="String" MaxLength="250" Unicode="true" FixedLength="true" />
  76. <Property Name="created_at" Type="DateTime" />
  77. <Property Name="updated_at" Type="DateTime" />
  78. <Property Name="active" Type="Boolean" />
  79. </EntityType>
  80. </Schema>
  81. </edmx:ConceptualModels>
  82. <!-- C-S mapping content -->
  83. <edmx:Mappings>
  84. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  85. <EntityContainerMapping StorageEntityContainer="labModelStoreContainer" CdmEntityContainer="labEntities">
  86. <EntitySetMapping Name="users"><EntityTypeMapping TypeName="labModel.user"><MappingFragment StoreEntitySet="users">
  87. <ScalarProperty Name="id" ColumnName="id" />
  88. <ScalarProperty Name="email" ColumnName="email" />
  89. <ScalarProperty Name="hashed_password" ColumnName="hashed_password" />
  90. <ScalarProperty Name="created_at" ColumnName="created_at" />
  91. <ScalarProperty Name="updated_at" ColumnName="updated_at" />
  92. <ScalarProperty Name="active" ColumnName="active" />
  93. </MappingFragment></EntityTypeMapping></EntitySetMapping>
  94. </EntityContainerMapping>
  95. </Mapping>
  96. </edmx:Mappings>
  97. </edmx:Runtime>
  98. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  99. <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
  100. <Connection>
  101. <DesignerInfoPropertySet>
  102. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  103. </DesignerInfoPropertySet>
  104. </Connection>
  105. <Options>
  106. <DesignerInfoPropertySet>
  107. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  108. <DesignerProperty Name="EnablePluralization" Value="True" />
  109. <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
  110. </DesignerInfoPropertySet>
  111. </Options>
  112. <!-- Diagram content (shape and connector positions) -->
  113. <Diagrams>
  114. <Diagram Name="Model1">
  115. <EntityTypeShape EntityType="labModel.user" Width="1.5" PointX="0.75" PointY="0.75" Height="2.172587890625" IsExpanded="true" />
  116. </Diagram>
  117. </Diagrams>
  118. </Designer>
  119. </edmx:Edmx>