This is likely because you are setting a unique constraint on the navigation property, but the database really has a foreign key for that property, therefore you might try applying an attribute to that foreign key....SharePoint_Id...
and make it non-nullable, after which it ought to function....modelBuilder.Entity<User>()
.Property(p => p.SharePoin...
Your code above (the mapping) specifies that the column has a primary key and a non-clustered index. You then attempt to add a clustered index to another column when the primary key will already be clustered. EntityFamework creates all primary keys as clustered indexes....According to my understanding, you cannot construct a non-clustered primary k...
To be clear, you don't always require navigation properties, i.e....public City City { get; set; }...
to establish connections. The foreign key and the appropriate settings are the only things required....Although I haven't tried it, I believe the following setup might work for you:...Entities...If you don't mind, I also purposefully changed your c...
