如何阻止dotnetef遷移添加創建不必要的附加欄位

這是一個只有一個類的準系統應用程式：AppUser 只有（Id、FirstName、LastName、Phone1、Phone2、KnAs、EmailAddress、Question、Answer 和 IsTrialMode。

沒有其他桌子！

DataContext is only:

    public class DataContext : DbContext
{
    public DataContext(DbContextOptions options) : base(options)
    {
    }

    public DbSet<AppUser> Users { get; set; }
}

當我執行 dotnet ef migrations add 命令時，遷移檔案包含：

            migrationBuilder.CreateTable(
            name: "Users",
            columns: table => new
            {
                Id = table.Column<int>(type: "int", nullable: false)
                    .Annotation("SqlServer:Identity", "1, 1"),
                FirstName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                LastName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                Phone1 = table.Column<string>(type: "nvarchar(max)", nullable: true),
                Phone2 = table.Column<string>(type: "nvarchar(max)", nullable: true),
                KnownAs = table.Column<string>(type: "nvarchar(max)", nullable: true),
                EmailAddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
                Question = table.Column<string>(type: "nvarchar(max)", nullable: true),
                Answer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                IsTrialMode = table.Column<bool>(type: "bit", nullable: false),
                UserName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                NormalizedUserName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                Email = table.Column<string>(type: "nvarchar(max)", nullable: true),
                NormalizedEmail = table.Column<string>(type: "nvarchar(max)", nullable: true),
                EmailConfirmed = table.Column<bool>(type: "bit", nullable: false),
                PasswordHash = table.Column<string>(type: "nvarchar(max)", nullable: true),
                SecurityStamp = table.Column<string>(type: "nvarchar(max)", nullable: true),
                ConcurrencyStamp = table.Column<string>(type: "nvarchar(max)", nullable: true),
                PhoneNumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                PhoneNumberConfirmed = table.Column<bool>(type: "bit", nullable: false),
                TwoFactorEnabled = table.Column<bool>(type: "bit", nullable: false),
                LockoutEnd = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                LockoutEnabled = table.Column<bool>(type: "bit", nullable: false),
                AccessFailedCount = table.Column<int>(type: "int", nullable: false)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_Users", x => x.Id);
            });

這顯然不是我所期望的。
是什么原因造成的；如何讓它停止？

提前致謝。“查克”

uj5u.com熱心網友回復：

從您的遷移檔案中，附加屬性似乎是IdentityUser類默認屬性。

確保您的 AppUser 不擴展IdentityUser或IdentityUser<T>分類：

public class AppUser
{
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Phone1 { get; set; }
    public string Phone2 { get; set; }
    public string KnownAs { get; set; }
    public string Question { get; set; }
    public string Answer { get; set; }
    public string EmailAddress { get; set; }
    public bool IsTrialMode { get; set; }
}

標籤：实体框架 asp.net 核心 移民

上一篇：使用物體框架連接多個表的最佳方法是什么？

下一篇：System.InvalidOperationException:'無法翻譯LINQ運算式。以可以翻譯的形式重寫查詢