Model.edmx | searchcode

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

#
Unknown | 201 lines | 201 code | 0 blank | 0 comment | 0 complexity | 005d21f3e5d333546d21da3c3eb3bc30 MD5 | raw file

<?xml version="1.0" encoding="utf-8"?>

<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">

  <!-- EF Runtime content -->

  <edmx:Runtime>

    <!-- SSDL content -->

    <edmx:StorageModels>

      <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">

        <EntityContainer Name="TimeSheetDatabaseModelStoreContainer">

          <EntitySet Name="Effort" EntityType="TimeSheetDatabaseModel.Store.Effort" store:Type="Tables" Schema="dbo" />

          <EntitySet Name="Member" EntityType="TimeSheetDatabaseModel.Store.Member" store:Type="Tables" Schema="dbo" />

          <EntitySet Name="Project" EntityType="TimeSheetDatabaseModel.Store.Project" store:Type="Tables" Schema="dbo" />

          <AssociationSet Name="FK_Effort_Member" Association="TimeSheetDatabaseModel.Store.FK_Effort_Member">

            <End Role="Member" EntitySet="Member" />

            <End Role="Effort" EntitySet="Effort" />

          </AssociationSet>

          <AssociationSet Name="FK_Effort_Project" Association="TimeSheetDatabaseModel.Store.FK_Effort_Project">

            <End Role="Project" EntitySet="Project" />

            <End Role="Effort" EntitySet="Effort" />

          </AssociationSet>

        </EntityContainer>

        <EntityType Name="Effort">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />

          <Property Name="Date" Type="date" Nullable="false" />

          <Property Name="Hours" Type="float" Nullable="false" />

          <Property Name="Description" Type="nvarchar" MaxLength="1000" />

          <Property Name="MemberId" Type="int" Nullable="false" />

          <Property Name="ProjectId" Type="int" Nullable="false" />

        </EntityType>

        <EntityType Name="Member">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />

          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="100" />

        </EntityType>

        <EntityType Name="Project">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />

          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="100" />

        </EntityType>

        <Association Name="FK_Effort_Member">

          <End Role="Member" Type="TimeSheetDatabaseModel.Store.Member" Multiplicity="1" />

          <End Role="Effort" Type="TimeSheetDatabaseModel.Store.Effort" Multiplicity="*" />

          <ReferentialConstraint>

            <Principal Role="Member">

              <PropertyRef Name="Id" />

            </Principal>

            <Dependent Role="Effort">

              <PropertyRef Name="MemberId" />

            </Dependent>

          </ReferentialConstraint>

        </Association>

        <Association Name="FK_Effort_Project">

          <End Role="Project" Type="TimeSheetDatabaseModel.Store.Project" Multiplicity="1" />

          <End Role="Effort" Type="TimeSheetDatabaseModel.Store.Effort" Multiplicity="*" />

          <ReferentialConstraint>

            <Principal Role="Project">

              <PropertyRef Name="Id" />

            </Principal>

            <Dependent Role="Effort">

              <PropertyRef Name="ProjectId" />

            </Dependent>

          </ReferentialConstraint>

        </Association>

      </Schema>

    </edmx:StorageModels>

    <!-- CSDL content -->

    <edmx:ConceptualModels>

      <Schema Namespace="TimeSheetDatabaseModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm">

        <EntityContainer Name="TimeSheetDatabaseEntities">

          <EntitySet Name="Effort" EntityType="TimeSheetDatabaseModel.Effort" />

          <EntitySet Name="Member" EntityType="TimeSheetDatabaseModel.Member" />

          <EntitySet Name="Project" EntityType="TimeSheetDatabaseModel.Project" />

          <AssociationSet Name="FK_Effort_Member" Association="TimeSheetDatabaseModel.FK_Effort_Member">

            <End Role="Member" EntitySet="Member" />

            <End Role="Effort" EntitySet="Effort" />

          </AssociationSet>

          <AssociationSet Name="FK_Effort_Project" Association="TimeSheetDatabaseModel.FK_Effort_Project">

            <End Role="Project" EntitySet="Project" />

            <End Role="Effort" EntitySet="Effort" />

          </AssociationSet>

        </EntityContainer>

        <EntityType Name="Effort">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="Int32" Nullable="false" />

          <Property Name="Date" Type="DateTime" Nullable="false" />

          <Property Name="Hours" Type="Double" Nullable="false" />

          <Property Name="Description" Type="String" MaxLength="1000" Unicode="true" FixedLength="false" />

          <NavigationProperty Name="Member" Relationship="TimeSheetDatabaseModel.FK_Effort_Member" FromRole="Effort" ToRole="Member" />

          <NavigationProperty Name="Project" Relationship="TimeSheetDatabaseModel.FK_Effort_Project" FromRole="Effort" ToRole="Project" />

        </EntityType>

        <EntityType Name="Member">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="Int32" Nullable="false" />

          <Property Name="Name" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />

          <NavigationProperty Name="Effort" Relationship="TimeSheetDatabaseModel.FK_Effort_Member" FromRole="Member" ToRole="Effort" />

        </EntityType>

        <EntityType Name="Project">

          <Key>

            <PropertyRef Name="Id" />

          </Key>

          <Property Name="Id" Type="Int32" Nullable="false" />

          <Property Name="Name" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />

          <NavigationProperty Name="Effort" Relationship="TimeSheetDatabaseModel.FK_Effort_Project" FromRole="Project" ToRole="Effort" />

        </EntityType>

        <Association Name="FK_Effort_Member">

          <End Role="Member" Type="TimeSheetDatabaseModel.Member" Multiplicity="1" />

          <End Role="Effort" Type="TimeSheetDatabaseModel.Effort" Multiplicity="*" />

        </Association>

        <Association Name="FK_Effort_Project">

          <End Role="Project" Type="TimeSheetDatabaseModel.Project" Multiplicity="1" />

          <End Role="Effort" Type="TimeSheetDatabaseModel.Effort" Multiplicity="*" />

        </Association>

      </Schema>

    </edmx:ConceptualModels>

    <!-- C-S mapping content -->

    <edmx:Mappings>

      <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">

        <EntityContainerMapping StorageEntityContainer="TimeSheetDatabaseModelStoreContainer" CdmEntityContainer="TimeSheetDatabaseEntities">

          <EntitySetMapping Name="Effort">

            <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Effort)">

              <MappingFragment StoreEntitySet="Effort">

                <ScalarProperty Name="Id" ColumnName="Id" />

                <ScalarProperty Name="Date" ColumnName="Date" />

                <ScalarProperty Name="Hours" ColumnName="Hours" />

                <ScalarProperty Name="Description" ColumnName="Description" />

              </MappingFragment>

            </EntityTypeMapping>

          </EntitySetMapping>

          <EntitySetMapping Name="Member">

            <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Member)">

              <MappingFragment StoreEntitySet="Member">

                <ScalarProperty Name="Id" ColumnName="Id" />

                <ScalarProperty Name="Name" ColumnName="Name" />

              </MappingFragment>

            </EntityTypeMapping>

          </EntitySetMapping>

          <EntitySetMapping Name="Project">

            <EntityTypeMapping TypeName="IsTypeOf(TimeSheetDatabaseModel.Project)">

              <MappingFragment StoreEntitySet="Project">

                <ScalarProperty Name="Id" ColumnName="Id" />

                <ScalarProperty Name="Name" ColumnName="Name" />

              </MappingFragment>

            </EntityTypeMapping>

          </EntitySetMapping>

          <AssociationSetMapping Name="FK_Effort_Member" TypeName="TimeSheetDatabaseModel.FK_Effort_Member" StoreEntitySet="Effort">

            <EndProperty Name="Member">

              <ScalarProperty Name="Id" ColumnName="MemberId" />

            </EndProperty>

            <EndProperty Name="Effort">

              <ScalarProperty Name="Id" ColumnName="Id" />

            </EndProperty>

          </AssociationSetMapping>

          <AssociationSetMapping Name="FK_Effort_Project" TypeName="TimeSheetDatabaseModel.FK_Effort_Project" StoreEntitySet="Effort">

            <EndProperty Name="Project">

              <ScalarProperty Name="Id" ColumnName="ProjectId" />

            </EndProperty>

            <EndProperty Name="Effort">

              <ScalarProperty Name="Id" ColumnName="Id" />

            </EndProperty>

          </AssociationSetMapping>

        </EntityContainerMapping>

      </Mapping>

    </edmx:Mappings>

  </edmx:Runtime>

  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->

  <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx">

    <edmx:Connection>

      <DesignerInfoPropertySet>

        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />

      </DesignerInfoPropertySet>

    </edmx:Connection>

    <edmx:Options>

      <DesignerInfoPropertySet>

        <DesignerProperty Name="ValidateOnBuild" Value="true" />

      </DesignerInfoPropertySet>

    </edmx:Options>

    <!-- Diagram content (shape and connector positions) -->

    <edmx:Diagrams>

      <Diagram Name="Model">

        <EntityTypeShape EntityType="TimeSheetDatabaseModel.Effort" Width="1.5" PointX="3" PointY="0.875" Height="1.9210009765625" IsExpanded="true" />

        <EntityTypeShape EntityType="TimeSheetDatabaseModel.Member" Width="1.5" PointX="0.75" PointY="1.125" Height="1.427958984375" IsExpanded="true" />

        <EntityTypeShape EntityType="TimeSheetDatabaseModel.Project" Width="1.5" PointX="0.75" PointY="4.125" Height="1.4279589843749996" IsExpanded="true" />

        <AssociationConnector Association="TimeSheetDatabaseModel.FK_Effort_Member" ManuallyRouted="false">

          <ConnectorPoint PointX="2.25" PointY="1.8389794921875" />

          <ConnectorPoint PointX="3" PointY="1.8389794921875" /></AssociationConnector>

        <AssociationConnector Association="TimeSheetDatabaseModel.FK_Effort_Project" ManuallyRouted="false">

          <ConnectorPoint PointX="2.25" PointY="4.8389794921875" />

          <ConnectorPoint PointX="3.75" PointY="4.8389794921875" />

          <ConnectorPoint PointX="3.75" PointY="2.7960009765625" /></AssociationConnector></Diagram></edmx:Diagrams>

  </edmx:Designer>

</edmx:Edmx>