Search code examples
aspnetboilerplateasp.net-boilerplate

How to make composite unique key in ASP.NET Boilerplate?


I have a table which has the Id as primary key, I want to have a composite unique key on Code and Value column. I'm trying in this way.

[Table("Test")]

public class Test: FullAuditedEntity

{


[Key]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public virtual int Code { get; set; }

[Key]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public virtual int Value { get; set; }

But it's making the composite primary key not unique key.


Solution

  • Adding solution for others.

    Don't modify anything just add the below line

    modelBuilder.Entity<Test>(b =>
            {
                b.HasIndex(e => new { e.Code, e.Value}).IsUnique();
            });