.NETCore5.0EF遷移添加新的外部列-有解無憂

我首先有一個帶有 .net 核心物體框架代碼的應用程式。

我有 2 個表的關系。altKategori 和 anaKategori

替代類別

public class altKategori
{
    [Key]
    public int idAltKategori { get; set; }

    [Column(TypeName = "Varchar")]
    [StringLength(30)]
    public string adAltKategori { get; set; }

    public int idAnaKategori { get; set; }
    public anaKategori anaKategori { get; set; }
}

無類別的

public class anaKategori
{
    [Key]
    public int idAnaKategori { get; set; }

    [Column(TypeName = "Varchar")]
    [StringLength(30)]
    public string adAnaKategori { get; set; }

    public List<altKategori> altKategoris { get; set; }
}

還有我的背景關系：

public class Context : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("server=.\\MSSQLSERVER2019;database=deneme;User ID=deneme1;Password=****;");
    }
    public DbSet<altKategori> altKategoris { get; set; }
    public DbSet<anaKategori> anaKategoris { get; set; }
}

當我開始遷移時，遷移會自動添加 anaKategoriidAnaKategori 列，并添加與該列的關系。

migrationBuilder.CreateTable(
            name: "altKategoris",
            columns: table => new
            {
                idAltKategori = table.Column<int>(type: "int", nullable: false)
                    .Annotation("SqlServer:Identity", "1, 1"),
                adAltKategori = table.Column<string>(type: "Varchar(30)", maxLength: 30, nullable: true),
                idAnaKategori = table.Column<int>(type: "int", nullable: false),
                anaKategoriidAnaKategori = table.Column<int>(type: "int", nullable: true)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_altKategoris", x => x.idAltKategori);
                table.ForeignKey(
                    name: "FK_altKategoris_anaKategoris_anaKategoriidAnaKategori",
                    column: x => x.anaKategoriidAnaKategori,
                    principalTable: "anaKategoris",
                    principalColumn: "idAnaKategori",
                    onDelete: ReferentialAction.Restrict);
            });

我不想與 anaKategoriidAnaKategori 發生關系。我想與 idAnaKategori 建立關系。我怎樣才能？謝謝你的幫助。

uj5u.com熱心網友回復：

嘗試添加關系屬性

public class altKategori
{
    [Key]
    public int idAltKategori { get; set; }

    [Column(TypeName = "Varchar")]
    [StringLength(30)]
    public string adAltKategori { get; set; }

    public int idAnaKategori { get; set; }

    [ForeignKey(nameof(idAnaKategori ))]
    [InverseProperty("altKategoris")]
    public anaKategori anaKategori { get; set; }
}

public class anaKategori
{
    [Key]
    public int idAnaKategori { get; set; }

    [Column(TypeName = "Varchar")]
    [StringLength(30)]
    public string adAnaKategori { get; set; }

   [InverseProperty(nameof(altKategori.anaKategori))]
    public List<altKategori> altKategoris { get; set; }
}

轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/345132.html

標籤：asp.net-mvc asp.net核心实体框架核心外键实体框架迁移

上一篇：不使用EF的視圖的分頁

下一篇：反序列化的Json物件值為null