c# - Entity Framework Relationship Error -
i following error when using entity framework:
unable determine principal end of association between types 'xxx.domain.entities.usersettings' , 'xxx.domain.entities.user'. principal end of association must explicitly configured using either relationship fluent api or data annotations.
here 2 entity classes:
public class user { [key, column("un")] public string username { get; set; } public int level { get; set; } public virtual usersettings usersettings { get; set; } } public class usersettings { [key] public string username { get; set; } public int activerefresh { get; set; } [foreignkey("username")] public virtual user user { get; set; } }
i not sure how resolve error. stuck database design can't update fix issue. there way using fluent api these associations working?
a user can have usersettings object. relationship desired.
it looks need 1 zero-or-one relationship
// configure primary key user modelbuilder.entity<user>() .haskey(t => t.username); // map one-to-zero or 1 relationship modelbuilder.entity<usersettings>() .hasrequired(t => t.user) .withoptional(t => t.usersettings);
this not tested! remove annotations entity classes. link fluent api relationships in comment above has more examples of different kinds of relationship.
Comments
Post a Comment