如何在 ASP.NET Boilerplate 中制作复合唯一键? [英] How to make composite unique key in ASP.NET Boilerplate?

问题描述

我有一个以 Id 作为主键的表，我想在 Code 和 Value 列上有一个复合唯一键.我正在尝试这种方式.

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.

推荐答案

为他人添加解决方案.

不要修改任何东西，只需添加以下行

Don't modify anything just add the below line

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

这篇关于如何在 ASP.NET Boilerplate 中制作复合唯一键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！