tags:

views:

530

answers:

1
+1  Q: 

Entity Framework Multiple Table Entity Key Mapping issue

Ok so here is my issue. I have a QA day log table and a Employee table. I want the NetUserID on the Employee table to be transfered to the QA day log table. I added both tables, cut and pasted in the designer and I edited the mappings like I thought I was supposed to. I get an error about the DL_ID which is the primary key for the QA DayLog not bing mapped. I don't get it I can't see it in the xml. It appears mapped to me. Any help would be greatly appreaciated cause I have spent hours on this. Here is my xml. Thanks in advance.

  `<!-- SSDL content -->

  <Schema Namespace="ShepherdDB1Model.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"&gt;
    <EntityContainer Name="ShepherdDB1ModelStoreContainer">
      <EntitySet Name="Employee" EntityType="ShepherdDB1Model.Store.Employee" store:Type="Tables" Schema="dbo" />
      <EntitySet Name="QA_DayLog" EntityType="ShepherdDB1Model.Store.QA_DayLog" store:Type="Tables" Schema="dbo" />
    </EntityContainer>
    <EntityType Name="Employee">
      <Key>
        <PropertyRef Name="EmployeeID" />
      </Key>
      <Property Name="ADate" Type="datetime" />
      <Property Name="Address1" Type="varchar" MaxLength="30" />
      <Property Name="Address2" Type="varchar" MaxLength="30" />
      <Property Name="AttendRptInclude" Type="smallint" />
      <Property Name="BirthDate" Type="datetime" />
      <Property Name="BranchID" Type="int" />
      <Property Name="CellPhone" Type="varchar" MaxLength="20" />
      <Property Name="City" Type="varchar" MaxLength="15" />
      <Property Name="CmpBrnch" Type="varchar" MaxLength="10" />
      <Property Name="COAPassWord" Type="varchar" MaxLength="10" />
      <Property Name="CommonName" Type="varchar" MaxLength="15" />
      <Property Name="CompanyID" Type="int" />
      <Property Name="Department" Type="varchar" MaxLength="7" />
      <Property Name="DeptAssigned" Type="varchar" MaxLength="7" />
      <Property Name="EEOCategoryID" Type="int" />
      <Property Name="EmployeeID" Type="smallint" Nullable="false" StoreGeneratedPattern="Identity" />
      <Property Name="EmrContact" Type="varchar" MaxLength="20" />
      <Property Name="EmrPhoneH" Type="varchar" MaxLength="20" />
      <Property Name="EmrPhoneW" Type="varchar" MaxLength="20" />
      <Property Name="FirstName" Type="varchar" Nullable="false" MaxLength="15" />
      <Property Name="Gender" Type="varchar" MaxLength="1" />
      <Property Name="Glasses" Type="bit" Nullable="false" />
      <Property Name="Hired" Type="datetime" />
      <Property Name="Initials" Type="varchar" MaxLength="3" />
      <Property Name="InternetAccess" Type="tinyint" />
      <Property Name="LastName" Type="varchar" Nullable="false" MaxLength="15" />
      <Property Name="MiddleInitial" Type="varchar" MaxLength="1" />
      <Property Name="NetUserID" Type="varchar" MaxLength="30" />
      <Property Name="Notes" Type="varchar" MaxLength="1024" />
      <Property Name="PayRoll" Type="varchar" MaxLength="1" />
      <Property Name="PermTemp" Type="varchar" MaxLength="1" />
      <Property Name="Phone" Type="varchar" MaxLength="20" />
      <Property Name="PhoneEx" Type="varchar" MaxLength="25" />
      <Property Name="Position" Type="varchar" MaxLength="10" />
      <Property Name="PositionDate" Type="datetime" />
      <Property Name="PositionLevelID" Type="int" />
      <Property Name="RaceID" Type="int" />
      <Property Name="ReHireDate" Type="datetime" />
      <Property Name="RespiratorID" Type="smallint" />
      <Property Name="Shift" Type="tinyint" />
      <Property Name="SMSEmail" Type="varchar" MaxLength="30" />
      <Property Name="SpouseName" Type="varchar" MaxLength="30" />
      <Property Name="SpousePhone" Type="varchar" MaxLength="20" />
      <Property Name="SSNumber" Type="varchar" Nullable="false" MaxLength="9" />
      <Property Name="ST" Type="varchar" MaxLength="2" />
      <Property Name="Status" Type="varchar" MaxLength="4" />
      <Property Name="SubDepartmentID" Type="int" />
      <Property Name="SupervisorID" Type="int" />
      <Property Name="Terminated" Type="datetime" />
      <Property Name="TerminateNote" Type="varchar" MaxLength="255" />
      <Property Name="Title" Type="varchar" MaxLength="50" />
      <Property Name="Trainee" Type="bit" Nullable="false" />
      <Property Name="ViewAttendance" Type="tinyint" />
      <Property Name="WeekHrs" Type="smallint" />
      <Property Name="WorkFriday" Type="bit" Nullable="false" />
      <Property Name="WorkMonday" Type="bit" Nullable="false" />
      <Property Name="WorkSaturday" Type="bit" Nullable="false" />
      <Property Name="WorkSunday" Type="bit" Nullable="false" />
      <Property Name="WorkThursday" Type="bit" Nullable="false" />
      <Property Name="WorkTuesday" Type="bit" Nullable="false" />
      <Property Name="WorkWednesday" Type="bit" Nullable="false" />
      <Property Name="ZipCode" Type="varchar" MaxLength="10" />
    </EntityType>
    <EntityType Name="QA_DayLog">
      <Key>
        <PropertyRef Name="DL_ID" />
      </Key>
      <Property Name="325Mesh" Type="decimal" Precision="9" Scale="3" />
      <Property Name="Action" Type="varchar" MaxLength="1" />
      <Property Name="Comment" Type="varchar" MaxLength="255" />
      <Property Name="Composit" Type="bit" Nullable="false" />
      <Property Name="DL_ID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
      <Property Name="EmployeeID" Type="smallint" />
      <Property Name="Grit" Type="varchar" MaxLength="1" />
      <Property Name="Hegman" Type="decimal" Precision="9" Scale="3" />
      <Property Name="Initials" Type="varchar" MaxLength="3" />
      <Property Name="LogDate" Type="datetime" Nullable="false" />
      <Property Name="LotNum" Type="varchar" MaxLength="20" />
      <Property Name="MeshCnt" Type="tinyint" />
      <Property Name="MFGConditions" Type="varchar" MaxLength="20" />
      <Property Name="MFGEquipment" Type="varchar" MaxLength="10" />
      <Property Name="MFGProcess" Type="varchar" MaxLength="2" />
      <Property Name="MFGProcessStep" Type="decimal" Precision="9" Scale="3" />
      <Property Name="MFGProcessStepInc" Type="decimal" Precision="9" Scale="3" />
      <Property Name="MFGProcessStepIncUOM" Type="varchar" MaxLength="3" />
      <Property Name="MFGProcessStepUOM" Type="varchar" MaxLength="3" />
      <Property Name="MIX" Type="varchar" MaxLength="6" />
      <Property Name="MSample_ID" Type="int" />
      <Property Name="P1" Type="varchar" MaxLength="1" />
      <Property Name="P2" Type="varchar" MaxLength="1" />
      <Property Name="P3" Type="varchar" MaxLength="1" />
      <Property Name="PSI" Type="decimal" Precision="9" Scale="3" />
      <Property Name="RPM" Type="decimal" Precision="9" Scale="3" />
      <Property Name="Sampled" Type="bit" Nullable="false" />
      <Property Name="SPRStep" Type="decimal" Precision="9" Scale="3" />
      <Property Name="SPRUoM" Type="varchar" MaxLength="3" />
      <Property Name="Time" Type="varchar" MaxLength="5" />
      <Property Name="Trainee" Type="bit" Nullable="false" />
      <Property Name="TraineeVerified" Type="bit" Nullable="false" />
      <Property Name="VerifiedBy" Type="smallint" />
      <Property Name="VerifiedDate" Type="datetime" />
      <Property Name="VerifiedNotes" Type="varchar" MaxLength="255" />
    </EntityType>
  </Schema>
</edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
  <Schema Namespace="ShepherdDB1Model" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm"&gt;
    <EntityContainer Name="ShepherdDB1Entities">
      <EntitySet Name="QA_DayLog" EntityType="ShepherdDB1Model.QA_DayLog" />
    </EntityContainer>
    <EntityType Name="QA_DayLog">
      <Key>
        <PropertyRef Name="DL_ID" />
      </Key>
      <Property Name="C325Mesh" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="Action" Type="String" MaxLength="1" Unicode="false" FixedLength="false" />
      <Property Name="Comment" Type="String" MaxLength="255" Unicode="false" FixedLength="false" />
      <Property Name="Composit" Type="Boolean" Nullable="false" />
      <Property Name="DL_ID" Type="Int32" Nullable="false" />
      <Property Name="EmployeeID" Type="Int16" />
      <Property Name="Grit" Type="String" MaxLength="1" Unicode="false" FixedLength="false" />
      <Property Name="Hegman" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="Initials" Type="String" MaxLength="3" Unicode="false" FixedLength="false" />
      <Property Name="LogDate" Type="DateTime" Nullable="false" />
      <Property Name="LotNum" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
      <Property Name="MeshCnt" Type="Byte" />
      <Property Name="MFGConditions" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
      <Property Name="MFGEquipment" Type="String" MaxLength="10" Unicode="false" FixedLength="false" />
      <Property MaxLength="2" Unicode="false" FixedLength="false" Name="MFGProcess" Type="String" />
      <Property Name="MFGProcessStep" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="MFGProcessStepInc" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="MFGProcessStepIncUOM" Type="String" MaxLength="3" Unicode="false" FixedLength="false" />
      <Property MaxLength="3" Unicode="false" FixedLength="false" Name="MFGProcessStepUOM" Type="String" />
      <Property Name="MIX" Type="String" MaxLength="6" Unicode="false" FixedLength="false" />
      <Property Name="MSample_ID" Type="Int32" />
      <Property Name="P1" Type="String" MaxLength="1" Unicode="false" FixedLength="false" />
      <Property Name="P2" Type="String" MaxLength="1" Unicode="false" FixedLength="false" />
      <Property Name="P3" Type="String" MaxLength="1" Unicode="false" FixedLength="false" />
      <Property Name="PSI" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="RPM" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="Sampled" Type="Boolean" Nullable="false" />
      <Property Name="SPRStep" Type="Decimal" Precision="9" Scale="3" />
      <Property Name="SPRUoM" Type="String" MaxLength="3" Unicode="false" FixedLength="false" />
      <Property Name="Time" Type="String" MaxLength="5" Unicode="false" FixedLength="false" />
      <Property Name="Trainee" Type="Boolean" Nullable="false" />
      <Property Name="TraineeVerified" Type="Boolean" Nullable="false" />
      <Property Name="VerifiedBy" Type="Int16" />
      <Property Name="VerifiedDate" Type="DateTime" />
      <Property Name="VerifiedNotes" Type="String" MaxLength="255" Unicode="false" FixedLength="false" />
      <Property Name="NetUserID" Type="String" Nullable="true" /></EntityType>
  </Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
  <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
    <EntityContainerMapping StorageEntityContainer="ShepherdDB1ModelStoreContainer" CdmEntityContainer="ShepherdDB1Entities">
      <EntitySetMapping Name="QA_DayLog">
        <EntityTypeMapping TypeName="IsTypeOf(ShepherdDB1Model.QA_DayLog)">
          <MappingFragment StoreEntitySet="QA_DayLog">
            <ScalarProperty Name="C325Mesh" ColumnName="325Mesh" />
            <ScalarProperty Name="Action" ColumnName="Action" />
            <ScalarProperty Name="Comment" ColumnName="Comment" />
            <ScalarProperty Name="Composit" ColumnName="Composit" />
            <ScalarProperty Name="DL_ID" ColumnName="DL_ID" />
            <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
            <ScalarProperty Name="Grit" ColumnName="Grit" />
            <ScalarProperty Name="Hegman" ColumnName="Hegman" />
            <ScalarProperty Name="Initials" ColumnName="Initials" />
            <ScalarProperty Name="LogDate" ColumnName="LogDate" />
            <ScalarProperty Name="LotNum" ColumnName="LotNum" />
            <ScalarProperty Name="MeshCnt" ColumnName="MeshCnt" />
            <ScalarProperty Name="MFGConditions" ColumnName="MFGConditions" />
            <ScalarProperty Name="MFGEquipment" ColumnName="MFGEquipment" />
            <ScalarProperty Name="MFGProcess" ColumnName="MFGProcess" />
            <ScalarProperty Name="MFGProcessStep" ColumnName="MFGProcessStep" />
            <ScalarProperty Name="MFGProcessStepInc" ColumnName="MFGProcessStepInc" />
            <ScalarProperty Name="MFGProcessStepIncUOM" ColumnName="MFGProcessStepIncUOM" />
            <ScalarProperty Name="MFGProcessStepUOM" ColumnName="MFGProcessStepUOM" />
            <ScalarProperty Name="MIX" ColumnName="MIX" />
            <ScalarProperty Name="MSample_ID" ColumnName="MSample_ID" />
            <ScalarProperty Name="P1" ColumnName="P1" />
            <ScalarProperty Name="P2" ColumnName="P2" />
            <ScalarProperty Name="P3" ColumnName="P3" />
            <ScalarProperty Name="PSI" ColumnName="PSI" />
            <ScalarProperty Name="RPM" ColumnName="RPM" />
            <ScalarProperty Name="Sampled" ColumnName="Sampled" />
            <ScalarProperty Name="SPRStep" ColumnName="SPRStep" />
            <ScalarProperty Name="SPRUoM" ColumnName="SPRUoM" />
            <ScalarProperty Name="Time" ColumnName="Time" />
            <ScalarProperty Name="Trainee" ColumnName="Trainee" />
            <ScalarProperty Name="TraineeVerified" ColumnName="TraineeVerified" />
            <ScalarProperty Name="VerifiedBy" ColumnName="VerifiedBy" />
            <ScalarProperty Name="VerifiedDate" ColumnName="VerifiedDate" />
            <ScalarProperty Name="VerifiedNotes" ColumnName="VerifiedNotes" />
          </MappingFragment>
          <MappingFragment StoreEntitySet="Employee">
            <ScalarProperty Name="NetUserID" ColumnName="NetUserID" />
            <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
            </MappingFragment></EntityTypeMapping>
      </EntitySetMapping>
    </EntityContainerMapping>
  </Mapping>
</edmx:Mappings>

`

related questions

NHibernate many-to-one mappings updating unchanged table
nHibernate mapping to custom types
Mapping Oracle bool fields with nHibernate
Color mapping a texture in opengl
Google Maps API - GMarker.openInfoWindowHtml() stopped working
Mapping multiple Values to a Value Object in NHibernate
Getting String Sets into Presentation Layer
Which map api would best support fictionally defined maps?
Mapstraction as a library to access Google maps
Object-relational mapping: What's the best way to implement getters?
What is the ideal data type to use when storing latitude / longitudes in a MySQL database?
Annotated Spring-MVC controller not recognized when controller extends interface
Why isn't my NHibernate bag collection setting the 'parent id' of the children dynamically?
GIS/Mapping solutions that provide easy access to routing data
TIGER shapefiles - using and interpreting
Does such a procedure exist in a Scheme standard and if yes, how is it called?
We're manually mapping our internal data elements to external vendors' xml schema. there's gotta be a better way...
Which tool do I use if I want to map a programming framework visually and see the relationship between all entities?
Why does Python's iter() on a mapping return iterkeys() instead of iteritems()?
Finding City and Zip Code for a Location
How do I calculate distance between two latitude longitude points?
Java code for WGS84 to Google map position and back
Map Routing, a la Google Maps?
Mapping latitude/longitude to a distorted map
Decent, simple, GIS/mapping component for ASP.NET?