PageRenderTime 46ms CodeModel.GetById 15ms RepoModel.GetById 1ms app.codeStats 0ms

/TimeSheetReporting/TimeSheetReporting.Web/Model/Model.edmx

#
Unknown | 201 lines | 201 code | 0 blank | 0 comment | 0 complexity | 005d21f3e5d333546d21da3c3eb3bc30 MD5 | raw file
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="TimeSheetDatabaseModel.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/2006/04/edm/ssdl">
  8. <EntityContainer Name="TimeSheetDatabaseModelStoreContainer">
  9. <EntitySet Name="Effort" EntityType="TimeSheetDatabaseModel.Store.Effort" store:Type="Tables" Schema="dbo" />
  10. <EntitySet Name="Member" EntityType="TimeSheetDatabaseModel.Store.Member" store:Type="Tables" Schema="dbo" />
  11. <EntitySet Name="Project" EntityType="TimeSheetDatabaseModel.Store.Project" store:Type="Tables" Schema="dbo" />
  12. <AssociationSet Name="FK_Effort_Member" Association="TimeSheetDatabaseModel.Store.FK_Effort_Member">
  13. <End Role="Member" EntitySet="Member" />
  14. <End Role="Effort" EntitySet="Effort" />
  15. </AssociationSet>
  16. <AssociationSet Name="FK_Effort_Project" Association="TimeSheetDatabaseModel.Store.FK_Effort_Project">
  17. <End Role="Project" EntitySet="Project" />
  18. <End Role="Effort" EntitySet="Effort" />
  19. </AssociationSet>
  20. </EntityContainer>
  21. <EntityType Name="Effort">
  22. <Key>
  23. <PropertyRef Name="Id" />
  24. </Key>
  25. <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  26. <Property Name="Date" Type="date" Nullable="false" />
  27. <Property Name="Hours" Type="float" Nullable="false" />
  28. <Property Name="Description" Type="nvarchar" MaxLength="1000" />
  29. <Property Name="MemberId" Type="int" Nullable="false" />
  30. <Property Name="ProjectId" Type="int" Nullable="false" />
  31. </EntityType>
  32. <EntityType Name="Member">
  33. <Key>
  34. <PropertyRef Name="Id" />
  35. </Key>
  36. <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  37. <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="100" />
  38. </EntityType>
  39. <EntityType Name="Project">
  40. <Key>
  41. <PropertyRef Name="Id" />
  42. </Key>
  43. <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  44. <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="100" />
  45. </EntityType>
  46. <Association Name="FK_Effort_Member">
  47. <End Role="Member" Type="TimeSheetDatabaseModel.Store.Member" Multiplicity="1" />
  48. <End Role="Effort" Type="TimeSheetDatabaseModel.Store.Effort" Multiplicity="*" />
  49. <ReferentialConstraint>
  50. <Principal Role="Member">
  51. <PropertyRef Name="Id" />
  52. </Principal>
  53. <Dependent Role="Effort">
  54. <PropertyRef Name="MemberId" />
  55. </Dependent>
  56. </ReferentialConstraint>
  57. </Association>
  58. <Association Name="FK_Effort_Project">
  59. <End Role="Project" Type="TimeSheetDatabaseModel.Store.Project" Multiplicity="1" />
  60. <End Role="Effort" Type="TimeSheetDatabaseModel.Store.Effort" Multiplicity="*" />
  61. <ReferentialConstraint>
  62. <Principal Role="Project">
  63. <PropertyRef Name="Id" />
  64. </Principal>
  65. <Dependent Role="Effort">
  66. <PropertyRef Name="ProjectId" />
  67. </Dependent>
  68. </ReferentialConstraint>
  69. </Association>
  70. </Schema>
  71. </edmx:StorageModels>
  72. <!-- CSDL content -->
  73. <edmx:ConceptualModels>
  74. <Schema Namespace="TimeSheetDatabaseModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm">
  75. <EntityContainer Name="TimeSheetDatabaseEntities">
  76. <EntitySet Name="Effort" EntityType="TimeSheetDatabaseModel.Effort" />
  77. <EntitySet Name="Member" EntityType="TimeSheetDatabaseModel.Member" />
  78. <EntitySet Name="Project" EntityType="TimeSheetDatabaseModel.Project" />
  79. <AssociationSet Name="FK_Effort_Member" Association="TimeSheetDatabaseModel.FK_Effort_Member">
  80. <End Role="Member" EntitySet="Member" />
  81. <End Role="Effort" EntitySet="Effort" />
  82. </AssociationSet>
  83. <AssociationSet Name="FK_Effort_Project" Association="TimeSheetDatabaseModel.FK_Effort_Project">
  84. <End Role="Project" EntitySet="Project" />
  85. <End Role="Effort" EntitySet="Effort" />
  86. </AssociationSet>
  87. </EntityContainer>
  88. <EntityType Name="Effort">
  89. <Key>
  90. <PropertyRef Name="Id" />
  91. </Key>
  92. <Property Name="Id" Type="Int32" Nullable="false" />
  93. <Property Name="Date" Type="DateTime" Nullable="false" />
  94. <Property Name="Hours" Type="Double" Nullable="false" />
  95. <Property Name="Description" Type="String" MaxLength="1000" Unicode="true" FixedLength="false" />
  96. <NavigationProperty Name="Member" Relationship="TimeSheetDatabaseModel.FK_Effort_Member" FromRole="Effort" ToRole="Member" />
  97. <NavigationProperty Name="Project" Relationship="TimeSheetDatabaseModel.FK_Effort_Project" FromRole="Effort" ToRole="Project" />
  98. </EntityType>
  99. <EntityType Name="Member">
  100. <Key>
  101. <PropertyRef Name="Id" />
  102. </Key>
  103. <Property Name="Id" Type="Int32" Nullable="false" />
  104. <Property Name="Name" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
  105. <NavigationProperty Name="Effort" Relationship="TimeSheetDatabaseModel.FK_Effort_Member" FromRole="Member" ToRole="Effort" />
  106. </EntityType>
  107. <EntityType Name="Project">
  108. <Key>
  109. <PropertyRef Name="Id" />
  110. </Key>
  111. <Property Name="Id" Type="Int32" Nullable="false" />
  112. <Property Name="Name" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
  113. <NavigationProperty Name="Effort" Relationship="TimeSheetDatabaseModel.FK_Effort_Project" FromRole="Project" ToRole="Effort" />
  114. </EntityType>
  115. <Association Name="FK_Effort_Member">
  116. <End Role="Member" Type="TimeSheetDatabaseModel.Member" Multiplicity="1" />
  117. <End Role="Effort" Type="TimeSheetDatabaseModel.Effort" Multiplicity="*" />
  118. </Association>
  119. <Association Name="FK_Effort_Project">
  120. <End Role="Project" Type="TimeSheetDatabaseModel.Project" Multiplicity="1" />
  121. <End Role="Effort" Type="TimeSheetDatabaseModel.Effort" Multiplicity="*" />
  122. </Association>
  123. </Schema>
  124. </edmx:ConceptualModels>
  125. <!-- C-S mapping content -->
  126. <edmx:Mappings>
  127. <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
  128. <EntityContainerMapping StorageEntityContainer="TimeSheetDatabaseModelStoreContainer" CdmEntityContainer="TimeSheetDatabaseEntities">
  129. <EntitySetMapping Name="Effort">
  130. <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Effort)">
  131. <MappingFragment StoreEntitySet="Effort">
  132. <ScalarProperty Name="Id" ColumnName="Id" />
  133. <ScalarProperty Name="Date" ColumnName="Date" />
  134. <ScalarProperty Name="Hours" ColumnName="Hours" />
  135. <ScalarProperty Name="Description" ColumnName="Description" />
  136. </MappingFragment>
  137. </EntityTypeMapping>
  138. </EntitySetMapping>
  139. <EntitySetMapping Name="Member">
  140. <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Member)">
  141. <MappingFragment StoreEntitySet="Member">
  142. <ScalarProperty Name="Id" ColumnName="Id" />
  143. <ScalarProperty Name="Name" ColumnName="Name" />
  144. </MappingFragment>
  145. </EntityTypeMapping>
  146. </EntitySetMapping>
  147. <EntitySetMapping Name="Project">
  148. <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Project)">
  149. <MappingFragment StoreEntitySet="Project">
  150. <ScalarProperty Name="Id" ColumnName="Id" />
  151. <ScalarProperty Name="Name" ColumnName="Name" />
  152. </MappingFragment>
  153. </EntityTypeMapping>
  154. </EntitySetMapping>
  155. <AssociationSetMapping Name="FK_Effort_Member" TypeName="TimeSheetDatabaseModel.FK_Effort_Member" StoreEntitySet="Effort">
  156. <EndProperty Name="Member">
  157. <ScalarProperty Name="Id" ColumnName="MemberId" />
  158. </EndProperty>
  159. <EndProperty Name="Effort">
  160. <ScalarProperty Name="Id" ColumnName="Id" />
  161. </EndProperty>
  162. </AssociationSetMapping>
  163. <AssociationSetMapping Name="FK_Effort_Project" TypeName="TimeSheetDatabaseModel.FK_Effort_Project" StoreEntitySet="Effort">
  164. <EndProperty Name="Project">
  165. <ScalarProperty Name="Id" ColumnName="ProjectId" />
  166. </EndProperty>
  167. <EndProperty Name="Effort">
  168. <ScalarProperty Name="Id" ColumnName="Id" />
  169. </EndProperty>
  170. </AssociationSetMapping>
  171. </EntityContainerMapping>
  172. </Mapping>
  173. </edmx:Mappings>
  174. </edmx:Runtime>
  175. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  176. <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx">
  177. <edmx:Connection>
  178. <DesignerInfoPropertySet>
  179. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  180. </DesignerInfoPropertySet>
  181. </edmx:Connection>
  182. <edmx:Options>
  183. <DesignerInfoPropertySet>
  184. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  185. </DesignerInfoPropertySet>
  186. </edmx:Options>
  187. <!-- Diagram content (shape and connector positions) -->
  188. <edmx:Diagrams>
  189. <Diagram Name="Model">
  190. <EntityTypeShape EntityType="TimeSheetDatabaseModel.Effort" Width="1.5" PointX="3" PointY="0.875" Height="1.9210009765625" IsExpanded="true" />
  191. <EntityTypeShape EntityType="TimeSheetDatabaseModel.Member" Width="1.5" PointX="0.75" PointY="1.125" Height="1.427958984375" IsExpanded="true" />
  192. <EntityTypeShape EntityType="TimeSheetDatabaseModel.Project" Width="1.5" PointX="0.75" PointY="4.125" Height="1.4279589843749996" IsExpanded="true" />
  193. <AssociationConnector Association="TimeSheetDatabaseModel.FK_Effort_Member" ManuallyRouted="false">
  194. <ConnectorPoint PointX="2.25" PointY="1.8389794921875" />
  195. <ConnectorPoint PointX="3" PointY="1.8389794921875" /></AssociationConnector>
  196. <AssociationConnector Association="TimeSheetDatabaseModel.FK_Effort_Project" ManuallyRouted="false">
  197. <ConnectorPoint PointX="2.25" PointY="4.8389794921875" />
  198. <ConnectorPoint PointX="3.75" PointY="4.8389794921875" />
  199. <ConnectorPoint PointX="3.75" PointY="2.7960009765625" /></AssociationConnector></Diagram></edmx:Diagrams>
  200. </edmx:Designer>
  201. </edmx:Edmx>