EMISLogContext.edmx 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  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="EMIS.Entities.Log.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  8. <EntityContainer Name="EMISEntitiesLogStoreContainer">
  9. <EntitySet Name="Log_Operate" EntityType="EMIS.Entities.Log.Store.Log_Operate" store:Type="Tables" Schema="dbo" />
  10. <EntitySet Name="VW_Sys_User" EntityType="EMIS.Entities.Log.Store.VW_Sys_User" store:Type="Views" store:Schema="dbo" store:Name="VW_Sys_User">
  11. <DefiningQuery>SELECT
  12. [VW_Sys_User].[UserID] AS [UserID],
  13. [VW_Sys_User].[LoginID] AS [LoginID],
  14. [VW_Sys_User].[Password] AS [Password],
  15. [VW_Sys_User].[Name] AS [Name],
  16. [VW_Sys_User].[RecordStatus] AS [RecordStatus],
  17. [VW_Sys_User].[CreateUserID] AS [CreateUserID],
  18. [VW_Sys_User].[CreateTime] AS [CreateTime],
  19. [VW_Sys_User].[ModifyUserID] AS [ModifyUserID],
  20. [VW_Sys_User].[ModifyTime] AS [ModifyTime]
  21. FROM [dbo].[VW_Sys_User] AS [VW_Sys_User]</DefiningQuery>
  22. </EntitySet>
  23. </EntityContainer>
  24. <EntityType Name="Log_Operate">
  25. <Key>
  26. <PropertyRef Name="OperateID" />
  27. </Key>
  28. <Property Name="OperateID" Type="uniqueidentifier" Nullable="false" />
  29. <Property Name="UserID" Type="uniqueidentifier" />
  30. <Property Name="IP" Type="varchar" MaxLength="50" />
  31. <Property Name="TableName" Type="varchar" MaxLength="50" />
  32. <Property Name="SourceUrl" Type="varchar" MaxLength="500" />
  33. <Property Name="Operate" Type="nvarchar" MaxLength="50" />
  34. <Property Name="Detail" Type="nvarchar(max)" />
  35. <Property Name="IsSuccess" Type="bit" />
  36. <Property Name="OperateTime" Type="datetime" />
  37. </EntityType>
  38. <!--生成过程中发现错误:
  39. 警告 6002: 表/视图“EMISNewLog.dbo.VW_Sys_User”未定义主键。已推断出该键,并将定义创建为只读的表/视图。
  40. -->
  41. <EntityType Name="VW_Sys_User">
  42. <Key>
  43. <PropertyRef Name="UserID" />
  44. </Key>
  45. <Property Name="UserID" Type="uniqueidentifier" Nullable="false" />
  46. <Property Name="LoginID" Type="varchar" MaxLength="50" />
  47. <Property Name="Password" Type="varchar" MaxLength="50" />
  48. <Property Name="Name" Type="nvarchar" MaxLength="50" />
  49. <Property Name="RecordStatus" Type="int" />
  50. <Property Name="CreateUserID" Type="uniqueidentifier" />
  51. <Property Name="CreateTime" Type="datetime" />
  52. <Property Name="ModifyUserID" Type="uniqueidentifier" />
  53. <Property Name="ModifyTime" Type="datetime" />
  54. </EntityType>
  55. </Schema>
  56. </edmx:StorageModels>
  57. <!-- CSDL content -->
  58. <edmx:ConceptualModels>
  59. <Schema Namespace="EMIS.Entities.Log" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
  60. <EntityContainer Name="EMISNewLogContext" annotation:LazyLoadingEnabled="true">
  61. <EntitySet Name="Log_Operate" EntityType="EMIS.Entities.Log.Log_Operate" />
  62. <EntitySet Name="VW_Sys_User" EntityType="EMIS.Entities.Log.VW_Sys_User" />
  63. </EntityContainer>
  64. <EntityType Name="Log_Operate">
  65. <Key>
  66. <PropertyRef Name="OperateID" />
  67. </Key>
  68. <Property Name="OperateID" Type="Guid" Nullable="false" />
  69. <Property Name="UserID" Type="Guid" />
  70. <Property Name="IP" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
  71. <Property Name="TableName" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
  72. <Property Name="SourceUrl" Type="String" MaxLength="2000" Unicode="false" FixedLength="false" />
  73. <Property Name="Operate" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
  74. <Property Name="Detail" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
  75. <Property Name="IsSuccess" Type="Boolean" />
  76. <Property Name="OperateTime" Type="DateTime" />
  77. </EntityType>
  78. <EntityType Name="VW_Sys_User">
  79. <Key>
  80. <PropertyRef Name="UserID" />
  81. </Key>
  82. <Property Name="UserID" Type="Guid" Nullable="false" />
  83. <Property Name="LoginID" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
  84. <Property Name="Password" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
  85. <Property Name="Name" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
  86. <Property Name="RecordStatus" Type="Int32" />
  87. <Property Name="CreateUserID" Type="Guid" />
  88. <Property Name="CreateTime" Type="DateTime" />
  89. <Property Name="ModifyUserID" Type="Guid" />
  90. <Property Name="ModifyTime" Type="DateTime" />
  91. </EntityType>
  92. </Schema>
  93. </edmx:ConceptualModels>
  94. <!-- C-S mapping content -->
  95. <edmx:Mappings>
  96. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  97. <EntityContainerMapping StorageEntityContainer="EMISEntitiesLogStoreContainer" CdmEntityContainer="EMISNewLogContext">
  98. <EntitySetMapping Name="Log_Operate">
  99. <EntityTypeMapping TypeName="EMIS.Entities.Log.Log_Operate">
  100. <MappingFragment StoreEntitySet="Log_Operate">
  101. <ScalarProperty Name="OperateID" ColumnName="OperateID" />
  102. <ScalarProperty Name="UserID" ColumnName="UserID" />
  103. <ScalarProperty Name="IP" ColumnName="IP" />
  104. <ScalarProperty Name="TableName" ColumnName="TableName" />
  105. <ScalarProperty Name="SourceUrl" ColumnName="SourceUrl" />
  106. <ScalarProperty Name="Operate" ColumnName="Operate" />
  107. <ScalarProperty Name="Detail" ColumnName="Detail" />
  108. <ScalarProperty Name="IsSuccess" ColumnName="IsSuccess" />
  109. <ScalarProperty Name="OperateTime" ColumnName="OperateTime" />
  110. </MappingFragment>
  111. </EntityTypeMapping>
  112. </EntitySetMapping>
  113. <EntitySetMapping Name="VW_Sys_User">
  114. <EntityTypeMapping TypeName="EMIS.Entities.Log.VW_Sys_User">
  115. <MappingFragment StoreEntitySet="VW_Sys_User">
  116. <ScalarProperty Name="UserID" ColumnName="UserID" />
  117. <ScalarProperty Name="LoginID" ColumnName="LoginID" />
  118. <ScalarProperty Name="Password" ColumnName="Password" />
  119. <ScalarProperty Name="Name" ColumnName="Name" />
  120. <ScalarProperty Name="RecordStatus" ColumnName="RecordStatus" />
  121. <ScalarProperty Name="CreateUserID" ColumnName="CreateUserID" />
  122. <ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
  123. <ScalarProperty Name="ModifyUserID" ColumnName="ModifyUserID" />
  124. <ScalarProperty Name="ModifyTime" ColumnName="ModifyTime" />
  125. </MappingFragment>
  126. </EntityTypeMapping>
  127. </EntitySetMapping>
  128. </EntityContainerMapping>
  129. </Mapping>
  130. </edmx:Mappings>
  131. </edmx:Runtime>
  132. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  133. <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
  134. <Connection>
  135. <DesignerInfoPropertySet>
  136. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  137. </DesignerInfoPropertySet>
  138. </Connection>
  139. <Options>
  140. <DesignerInfoPropertySet>
  141. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  142. <DesignerProperty Name="EnablePluralization" Value="False" />
  143. <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
  144. <DesignerProperty Name="CodeGenerationStrategy" Value="无" />
  145. </DesignerInfoPropertySet>
  146. </Options>
  147. <!-- Diagram content (shape and connector positions) -->
  148. <Diagrams>
  149. <Diagram Name="EMISLogContext">
  150. <EntityTypeShape EntityType="EMIS.Entities.Log.Log_Operate" Width="1.5" PointX="0.75" PointY="0.75" Height="2.6594042968749996" IsExpanded="true" />
  151. <EntityTypeShape EntityType="EMIS.Entities.Log.VW_Sys_User" Width="1.5" PointX="2.75" PointY="0.75" Height="2.6594042968749996" IsExpanded="true" />
  152. </Diagram>
  153. </Diagrams>
  154. </Designer>
  155. </edmx:Edmx>