locked
asp.net core 3.0 Identity RRS feed

  • Question

  • User62207621 posted

    When I run Update-database after add-migration (and using the context I created which inherits IdentityContext) I don't get any errors but the tables do not get created in my database.  The Migration file looks fine with all the identity tables create statements. The code follows.  I've tried everything I can think of and am at a brick wall.

    public partial class fixRoles : Migration
    {
    protected override void Up(MigrationBuilder migrationBuilder)
    {
    migrationBuilder.CreateTable(
    name: "AspNetRoles",
    columns: table => new
    {
    Id = table.Column<int>(nullable: false),
    Name = table.Column<string>(maxLength: 256, nullable: true),
    NormalizedName = table.Column<string>(maxLength: 256, nullable: true),
    ConcurrencyStamp = table.Column<string>(nullable: true)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetRoles", x => x.Id);
    });

    migrationBuilder.CreateTable(
    name: "AspNetUsers",
    columns: table => new
    {
    Id = table.Column<int>(nullable: false),
    UserName = table.Column<string>(maxLength: 256, nullable: true),
    NormalizedUserName = table.Column<string>(maxLength: 256, nullable: true),
    Email = table.Column<string>(maxLength: 256, nullable: true),
    NormalizedEmail = table.Column<string>(maxLength: 256, nullable: true),
    EmailConfirmed = table.Column<bool>(nullable: false),
    PasswordHash = table.Column<string>(nullable: true),
    SecurityStamp = table.Column<string>(nullable: true),
    ConcurrencyStamp = table.Column<string>(nullable: true),
    PhoneNumber = table.Column<string>(nullable: true),
    PhoneNumberConfirmed = table.Column<bool>(nullable: false),
    TwoFactorEnabled = table.Column<bool>(nullable: false),
    LockoutEnd = table.Column<DateTimeOffset>(nullable: true),
    LockoutEnabled = table.Column<bool>(nullable: false),
    AccessFailedCount = table.Column<int>(nullable: false)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetUsers", x => x.Id);
    });

    migrationBuilder.CreateTable(
    name: "AspNetRoleClaims",
    columns: table => new
    {
    Id = table.Column<int>(nullable: false)
    .Annotation("SqlServer:Identity", "1, 1"),
    RoleId = table.Column<int>(nullable: false),
    ClaimType = table.Column<string>(nullable: true),
    ClaimValue = table.Column<string>(nullable: true)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
    table.ForeignKey(
    name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
    column: x => x.RoleId,
    principalTable: "AspNetRoles",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    });

    migrationBuilder.CreateTable(
    name: "AspNetUserClaims",
    columns: table => new
    {
    Id = table.Column<int>(nullable: false)
    .Annotation("SqlServer:Identity", "1, 1"),
    UserId = table.Column<int>(nullable: false),
    ClaimType = table.Column<string>(nullable: true),
    ClaimValue = table.Column<string>(nullable: true)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
    table.ForeignKey(
    name: "FK_AspNetUserClaims_AspNetUsers_UserId",
    column: x => x.UserId,
    principalTable: "AspNetUsers",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    });

    migrationBuilder.CreateTable(
    name: "AspNetUserLogins",
    columns: table => new
    {
    LoginProvider = table.Column<string>(maxLength: 200, nullable: false),
    ProviderKey = table.Column<string>(maxLength: 200, nullable: false),
    ProviderDisplayName = table.Column<string>(nullable: true),
    UserId = table.Column<int>(nullable: false)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey });
    table.ForeignKey(
    name: "FK_AspNetUserLogins_AspNetUsers_UserId",
    column: x => x.UserId,
    principalTable: "AspNetUsers",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    });

    migrationBuilder.CreateTable(
    name: "AspNetUserRoles",
    columns: table => new
    {
    UserId = table.Column<int>(nullable: false),
    RoleId = table.Column<int>(nullable: false)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
    table.ForeignKey(
    name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
    column: x => x.RoleId,
    principalTable: "AspNetRoles",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    table.ForeignKey(
    name: "FK_AspNetUserRoles_AspNetUsers_UserId",
    column: x => x.UserId,
    principalTable: "AspNetUsers",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    });

    migrationBuilder.CreateTable(
    name: "AspNetUserTokens",
    columns: table => new
    {
    UserId = table.Column<int>(nullable: false),
    LoginProvider = table.Column<string>(maxLength: 200, nullable: false),
    Name = table.Column<string>(maxLength: 200, nullable: false),
    Value = table.Column<string>(nullable: true)
    },
    constraints: table =>
    {
    table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
    table.ForeignKey(
    name: "FK_AspNetUserTokens_AspNetUsers_UserId",
    column: x => x.UserId,
    principalTable: "AspNetUsers",
    principalColumn: "Id",
    onDelete: ReferentialAction.Cascade);
    });

    migrationBuilder.CreateIndex(
    name: "IX_AspNetRoleClaims_RoleId",
    table: "AspNetRoleClaims",
    column: "RoleId");

    migrationBuilder.CreateIndex(
    name: "RoleNameIndex",
    table: "AspNetRoles",
    column: "NormalizedName",
    unique: true,
    filter: "[NormalizedName] IS NOT NULL");

    migrationBuilder.CreateIndex(
    name: "IX_AspNetUserClaims_UserId",
    table: "AspNetUserClaims",
    column: "UserId");

    migrationBuilder.CreateIndex(
    name: "IX_AspNetUserLogins_UserId",
    table: "AspNetUserLogins",
    column: "UserId");

    migrationBuilder.CreateIndex(
    name: "IX_AspNetUserRoles_RoleId",
    table: "AspNetUserRoles",
    column: "RoleId");

    migrationBuilder.CreateIndex(
    name: "EmailIndex",
    table: "AspNetUsers",
    column: "NormalizedEmail");

    migrationBuilder.CreateIndex(
    name: "UserNameIndex",
    table: "AspNetUsers",
    column: "NormalizedUserName",
    unique: true,
    filter: "[NormalizedUserName] IS NOT NULL");
    }

    Wednesday, February 5, 2020 7:59 AM

All replies

  • User711641945 posted

    Hi BabyGollum,

    Could you share your DbContext and your model?

    Check your appSettings.json file and you could find the DatabaseName mark in green by the following code:

    "ConnectionStrings": {
        "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-Identity3-18F1AED3-5FD0-4B35-9EC0-4511A17234AC;Trusted_Connection=True;MultipleActiveResultSets=true"
    }

    Best Regards,

    Rena

    Wednesday, February 5, 2020 8:48 AM