StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20009302
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-15T19:42:41.793
FavoriteCount
0
LastActivityDate
2013-11-18T11:15:52.627
LastEditDate
2017-05-23T11:56:06.693
LastEditorUserId
-1
OwnerUserId
150342
ParentId
19998589
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
As I understand it, Entity Framework enforces one-to-one relationships by making the 2 entities share the same primary key. That means that there is no need for a separate foreign key column, because the primary key property also acts as the foreign key. So, remove the surplus foreign keys and change the type of the Item's key to string so that it can refer to the User's Id: <pre><code>class User : IdentityUser // so it has public string Id! { public virtual Item Item { get; set; } } class Item { public string Id { get; set;} public virtual User User { get; set; } } </code></pre> Now, when both ends of the relationship are required or both sides are optional the Entity Framework cannot identify the dependent and principal. The dependent is the one that gets the foreign key referencing the principal's key. So try this: <pre><code>modelBuilder.Entity<User>() .HasOptional(f => f.Item). //Item is dependent and //gets the foreign key .WithOptionalPrincipal(s => s.User); </code></pre> Proviso I haven't tried this or done this and the bit I don't get is this. If both ends are optional, then how can the <code>Item</code> have a foreign key to the <code>User</code> that is also a primary key? A primary key is required but an optional foreign key is not. So they cannot be one and the same. So, if EF has now added An optional foreign key, I would add a unique index to it to ensure it is 1 to 1. As it is nullable, you will need to do it using sql in a migration <code>Sql("CREATE INDEX ON Item(User_Id) UNIQUE WHERE User_Id IS NOT NULL")</code> References: <a href="http://msdn.microsoft.com/en-us/data/jj713564" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/data/jj713564</a> <a href="http://msdn.microsoft.com/en-us/data/jj591620.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/data/jj591620.aspx</a> It says on that page: <blockquote> When both ends of the relationship are optional, use WithOptionalPrincipal or WithOptionalDependent after the HasOptional method. </blockquote> <a href="https://stackoverflow.com/questions/19580054/do-i-define-a-relationship-between-two-entities-on-the-dependent-or-the-principa/19580798#19580798">Do I define a relationship between two entities on the dependent or the principal?</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POEF not recognising Key for Relationship
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USColin
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.