PageRenderTime 84ms CodeModel.GetById 40ms app.highlight 3ms RepoModel.GetById 37ms 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>