There is a first model containing a user
<code>public class User_Profiles
{
public int id { get; set; }
public string Name { get; set; }
public List<order>? orders { get; set; }
}
</code>
<code>public class User_Profiles
{
public int id { get; set; }
public string Name { get; set; }
public List<order>? orders { get; set; }
}
</code>
public class User_Profiles
{
public int id { get; set; }
public string Name { get; set; }
public List<order>? orders { get; set; }
}
There is a second model containing an order model
<code>public class Document_Dependency_Model
{
public int id { get; set; }
public int Сreated_UserID { get; set; }
public User_Profiles Сreated_User { get; set; }
public int ExecudedUserID { get; set; }
public Large_Archive_Of_Documents_Model ExecudedUser { get; set; }
}
</code>
<code>public class Document_Dependency_Model
{
public int id { get; set; }
public int Сreated_UserID { get; set; }
public User_Profiles Сreated_User { get; set; }
public int ExecudedUserID { get; set; }
public Large_Archive_Of_Documents_Model ExecudedUser { get; set; }
}
</code>
public class Document_Dependency_Model
{
public int id { get; set; }
public int Сreated_UserID { get; set; }
public User_Profiles Сreated_User { get; set; }
public int ExecudedUserID { get; set; }
public Large_Archive_Of_Documents_Model ExecudedUser { get; set; }
}
}
Next I wrote in the context class what is connected
<code>modelBuilder.Entity<order>()
.HasOne(ps => ps.Сreated_User)
.WithMany()
.HasForeignKey(ps => ps.Сreated_UserID)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity<order>()
.HasOne(ps => ps.ExecudedUser)
.WithMany()
.HasForeignKey(ps => ps.ExecudedUserID)
.OnDelete(DeleteBehavior.Restrict);
</code>
<code>modelBuilder.Entity<order>()
.HasOne(ps => ps.Сreated_User)
.WithMany()
.HasForeignKey(ps => ps.Сreated_UserID)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity<order>()
.HasOne(ps => ps.ExecudedUser)
.WithMany()
.HasForeignKey(ps => ps.ExecudedUserID)
.OnDelete(DeleteBehavior.Restrict);
</code>
modelBuilder.Entity<order>()
.HasOne(ps => ps.Сreated_User)
.WithMany()
.HasForeignKey(ps => ps.Сreated_UserID)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity<order>()
.HasOne(ps => ps.ExecudedUser)
.WithMany()
.HasForeignKey(ps => ps.ExecudedUserID)
.OnDelete(DeleteBehavior.Restrict);
The connections are established, everything works, but if you look at the database table, the “user_profileid” field is created in it
How to establish such connections correctly and how to avoid creating an unnecessary field?