且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Entity Framework中为第三个表添加额外的列?

更新时间:2023-01-31 11:51:37

你不能在关系中添加额外的字段,如状态。你需要有一个虚拟表格。
我认为你的问题与以下答案相同
在Fluent API中与多个字段进行多对多映射
可能这将有所帮助。


用户
通知_
您将状态字段字段的UserNotification(虚拟表) p>


Assume i have two entities, User and Notification:

public class User
{
[Key]
    public int UserId { get; set; }

// other public properties


// Navigation Properties

    public virtual ICollection<Notification> Notifications { get; set; }
}



public class Notification
{

    [Key]
    public int NotificationId { get; set; }

// other public properties

    // Navigation Properties

    public virtual ICollection<User> Users { get; set; }

}

I'm simply adding many-to-many Relationship like this:

modelBuilder.Entity<User>()
            .HasMany(u => u.Notifications)
            .WithMany(t => t.Users)
            .Map(m =>
            {
                m.ToTable("UserNotifications");
                m.MapLeftKey("UserId");
                m.MapRightKey("NotificationId");
            });

But what happens if i want to add extra column to this table which name is 'Status' ? I thought i can use AddColumn but then how can i access this column and get it's value ? How can i accomplish this? I want to check whether the user read notification or not. Any suggestions would be great,thanks.

You can't add extra field like "Status" in the relationship. You need to have a dummy table for that.
And i think your question is same as the following answer
Many to Many mapping with extra fields in Fluent API May be this would help.

User
Notification
UserNotification (dummy table) where you put your Status field