Message entity


Create a new model class Message.cs

public class Message
    public int Id { get; set; }
    public int SenderId { get; set; }
    public User Sender { get; set; }
    public int RecipientId { get; set; }
    public User Recipient { get; set; }
    public string Content { get; set; }
    public DateTime? SentDate { get; set; }
    public bool IsRead { get; set; }
    public DateTime? ReadDate { get; set; }
    public bool SenderDeleted { get; set; }
    public bool RecipientDeleted { get; set; }

Add the properties for sent and received to User

public ICollection<Message> MessagesSent { get; set; }
public ICollection<Message> MessagesReceived { get; set; }

Context, defaults and many to many

In DatingContext add a new DbSet and configure the relationships. Note that the foreign key can be ignored and ef will add it by convention (Sender has a SenderId and Recipient has a RecipientId)

// ...
public DbSet<Message> Messages { get; set; }
// ...
protected override void OnModelCreating(ModelBuilder modelBuilder)
// ...
    .HasOne(m => m.Sender)
    .WithMany(u => u.MessagesSent)

    .HasOne(m => m.Recipient)
    .WithMany(u => u.MessagesReceived)
    //.HasForeignKey(m => m.RecipientId)
// ...

Stop dotnet run

Create a new migration

dotnet ef migrations add AddedMessages

Review the code of the migration and note how the FK and IX has been automatically discovered by ef.

Apply the canghes

dotnet ef database update

restart dotnet run