Databases
StackOverflow2013
Postsdbo
POMapping suggestion for a possibly shared foreign key (value object in entity) in Entity Framework 4.1?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMapping suggestion for a possibly shared foreign key (value object in entity) in Entity Framework 4.1?
    primarykey
    data
    text
    <p>I have a Project entity and an Rfi entity. The project entity contains a list of TeamMembers. Project is a navigation property in the Rfi entity. In the Rfi entity there is a RecipientId. This Id represents a person from the TeamMembers collection. So imagine, on a web page, we have a drop down box named Recipient. The list includes all team members of the Project. The user will select a Contact from that list. The Id of that contact will be saved in the RecipientsId property. When the page is reloaded we will select the Id of that user in the drop down based off the value in the RecipeintsId property. What is the best way to map this in EF 4.1 using the fluent API?</p> <pre><code> public class Project : BaseEntity { public string ProjectNumber { get; set; } public string Description { get; set; } public string CreatedBy { get; set; } public string ModifiedBy { get; set; } public string Currency { get; set; } #region Navigation Properties public Guid AddressId { get; set; } public virtual Address Address { get; set; } public Guid CompanyCodeId { get; set; } public virtual CompanyCode CompanyCode { get; set; } public virtual ICollection&lt;Contact&gt; TeamMembers { get; set; } #endregion } public class Rfi : Document { public string Number { get; set; } public string Subject { get; set; } public string SubcontractorRfiReference { get; set; } public string SpecificationSection { get; set; } public RfiStatus RfiStatus { get; set; } public Guid RecipientId { get; set; } #region Navigation Properties public Guid ProjectId { get; set; } public Project Project { get; set; } #endregion } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDDiVita
    1. USDDiVita
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAnd what is a problem with your current mapping?
      singulars
      1. POMapping suggestion for a possibly shared foreign key (value object in entity) in Entity Framework 4.1?
      1. USLadislav Mrnka
    2. COThere is no problem, I am asking how I would map this in EF. I updated the question asking how I would map this using the fluent API.
      singulars
      1. POMapping suggestion for a possibly shared foreign key (value object in entity) in Entity Framework 4.1?
      1. USDDiVita
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload