StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POEF Unidirectional One to Many relationship
primarykey
Id
20499339
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-12-10T16:06:48.770
FavoriteCount
0
LastActivityDate
2013-12-19T22:34:30.260
LastEditDate
2013-12-10T21:04:19.063
LastEditorUserId
1303170
OwnerUserId
1303170
ParentId
0
PostTypeId
1
Score
0
ViewCount
565
LastEditorDisplayName
text
Body
I have an IdentityUser class which has a navigation property called Logins which is of type Collection. <pre><code>public class IdentityUser : IUser { public IdentityUser(); public IdentityUser(string userName); public virtual ICollection<IdentityUserClaim> Claims { get; } public virtual string Id { get; set; } public virtual ICollection<IdentityUserLogin> Logins { get; } public virtual string PasswordHash { get; set; } public virtual ICollection<IdentityUserRole> Roles { get; } public virtual string SecurityStamp { get; set; } public virtual string UserName { get; set; } } </code></pre> In the IdentityUserLogin class there is a navigation property called User which is of type IdentityUser. <pre><code>public class IdentityUserLogin { public IdentityUserLogin(); public virtual string LoginProvider { get; set; } public virtual string ProviderKey { get; set; } public virtual IdentityUser User { get; set; } public virtual string UserId { get; set; } } </code></pre> From this I can see that <ol> <li>the IdentityUser can have 0 to many IdentityUserLogin.</li> <li>IdentityUserLogin must have a IdentityUser.</li> </ol> I tried: <pre><code> this.HasRequired(t => t.User) .WithRequiredPrincipal(); </code></pre> but it was looking for a foreign key of IdentityUser_Id but it should be using UserId (which is a property of IdentityUserLogin so then I tried: <pre><code> this.HasRequired(t => t.User) .WithMany(t => t.Logins) .HasForeignKey(t => t.UserId); </code></pre> but I get an error stating: <blockquote> IdentityUserLogin_User_Source: : Multiplicity is not valid in Role 'IdentityUserLogin_User_Source' in relationship 'IdentityUserLogin_User'. Because the Dependent Role refers to the key properties, the upper bound of the multiplicity of the Dependent Role must be '1'. </blockquote> Does anyone know how I can declare the relationship and specify the Foreign Key? Update 1 This is my IdentityUserLogin map class: <pre><code>public class IdentityUserLoginMap : EntityTypeConfiguration<IdentityUserLogin> { public IdentityUserLoginMap() { // Primary Key this.HasKey(t => t.UserId); // Properties this.Property(t => t.LoginProvider) .IsRequired() .HasMaxLength(128); this.Property(t => t.ProviderKey) .IsRequired() .HasMaxLength(128); this.Property(t => t.UserId) .IsRequired() .HasMaxLength(128); // Table & Column Mappings this.ToTable("IdentityUserLogins"); this.Property(t => t.LoginProvider).HasColumnName("LoginProvider"); this.Property(t => t.ProviderKey).HasColumnName("ProviderKey"); this.Property(t => t.UserId).HasColumnName("UserId"); // Relationships this.HasRequired(t => t.User) .WithRequiredPrincipal(); } } </code></pre> As you can see, I am setting a primary key Update 2 Just to give a bit more of an explanation, here is the users table: <pre><code>CREATE TABLE [dbo].[IdentityUsers]( [Id] [nvarchar](128) NOT NULL, [UserName] [nvarchar](max) NULL, [PasswordHash] [nvarchar](max) NULL, [SecurityStamp] [nvarchar](max) NULL, [Discriminator] [nvarchar](128) NOT NULL, CONSTRAINT [PK_dbo.IdentityUsers] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) </code></pre> and the IdentityUserLogin table should look like this: <pre><code>CREATE TABLE [dbo].[IdentityUserLogins]( [LoginProvider] [nvarchar](128) NOT NULL, [ProviderKey] [nvarchar](128) NOT NULL, [UserId] [nvarchar](128) NOT NULL, PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] </code></pre> but when I run my code on a new database I get this: <pre><code>CREATE TABLE [dbo].[IdentityUserLogins]( [UserId] [nvarchar](128) NOT NULL, [LoginProvider] [nvarchar](128) NOT NULL, [ProviderKey] [nvarchar](128) NOT NULL, [IdentityUser_Id] [nvarchar](128) NULL, CONSTRAINT [PK_dbo.IdentityUserLogins] PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] </code></pre> as you can see, the IdentityUser_Id is obsolete, it should be using the primary key. That is my objective :)
Tags
<c#><entity-framework><asp.net-mvc-5>
Title
EF Unidirectional One to Many relationship
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USr3plica
UserOwnerUserId
1. USr3plica
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
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.