How to add Unique Key Constraints on combination of two columns using .NET CORE 3.1 code first approch?

Question

I am using .NET CORE 3.1 version and code first approach for Database creation. My model is in c# :

[Table("ProfileStore")]
public class ProfileStore : BaseEntity
{
    [ForeignKey("Profile")]
    public int ProfileId { get; set; }

    [ForeignKey("Store")]
    public int StoreId { get; set; }

    public virtual Stores.Store Store { get; set; }

    public virtual Profile Profile { get; set; }
}

Here Profile and Store both are different table and I am adding mapping of this two table in this table. Now I want to add row with unique combination only. How can I do that?

Sample Data Will be :

Id    ProfileId   StoreId
1        1           1
2        1           2
3        2           1
4        2           3
5        1           1    <------- This is should not insert when I will try to insert this.

Sina Riani · Accepted Answer · 2020-12-14 11:08:26Z

1

Use Configuring Many To Many Relationships in Entity Framework Core. First, add ICollection of each entity to the other one.


    public class Profile
    {
        // other property
        public ICollection<Store> Stores { get; set; }
    }  
    
    public class Store
    {
        // other property
        public ICollection<Profile> Profiles { get; set; }
    }

then use FluentAPI and configure the junction table as follow:


    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<ProfileStore>()
            .HasKey(ps => new { ps.ProfileId, bc.StoreId }).IsUnique();  
        modelBuilder.Entity<ProfileStore>()
            .HasOne(ps => ps.Profile)
            .WithMany(p => p.ProfileStore)
            .HasForeignKey(ps => ps.ProfileId);  
        modelBuilder.Entity<ProfileStore>()
            .HasOne(ps => ps.Store)
            .WithMany(s => s.ProfileStore)
            .HasForeignKey(ps => ps.StoreId);
    }

edited Dec 14, 2020 at 11:08

answered Dec 14, 2020 at 7:39

Sina Riani

3454 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Srusti Thakkar Over a year ago

I had tried this but not working. Need to add migration after adding these properties?

Sina Riani Over a year ago

it's better to rollback previous migration, and try it again with this config, maybe work

Srusti Thakkar · Accepted Answer · 2020-12-14 10:02:54Z

0

I had tried below code and it's working. Don't forgot to add migration after this code change.

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<ProfileStore>()
            .HasIndex(p => new { p.ProfileId, p.StoreId }).IsUnique();
    }

answered Dec 14, 2020 at 10:02

Srusti Thakkar

1,9112 gold badges26 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to add Unique Key Constraints on combination of two columns using .NET CORE 3.1 code first approch?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related