C#•6d ago

✅ Unable to create a 'DbContext' of type 'ApplicationDbContext'.

hi 👋 i'm trying to structure my project with DDD model but getting this error:

Unable to create a 'DbContext' of type 'ApplicationDbContext'. The exception 'The entity type 'IdentityUserLogin<string>' requires a primary key to be defined.

(this used to work before restructuring) i'm adding db context in Project.Web/Program.cs:

builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseNpgsql(
        builder.Configuration.GetConnectionString("ApplicationDbContext") ??
        throw new InvalidOperationException(
            "Connection string 'BlogContext' not found."
        )
    )
);

builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseNpgsql(
        builder.Configuration.GetConnectionString("ApplicationDbContext") ??
        throw new InvalidOperationException(
            "Connection string 'BlogContext' not found."
        )
    )
);

db context in Project.Infrastructure.Data:

namespace Project.Infrastructure.Data;

public class ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
    : IdentityDbContext<ApplicationUser>(options) {
    public DbSet<Post> Post { get; set; } = default!;
    public DbSet<TagPost> TagPost { get; set; } = default!;
    public DbSet<Comment> Comment { get; set; } = default!;

    public DbSet<Product> Product { get; set; } = default!;
    public DbSet<Category> Category { get; set; } = default!;
    public DbSet<CartItem> CartItem { get; set; }

namespace Project.Infrastructure.Data;

public class ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
    : IdentityDbContext<ApplicationUser>(options) {
    public DbSet<Post> Post { get; set; } = default!;
    public DbSet<TagPost> TagPost { get; set; } = default!;
    public DbSet<Comment> Comment { get; set; } = default!;

    public DbSet<Product> Product { get; set; } = default!;
    public DbSet<Category> Category { get; set; } = default!;
    public DbSet<CartItem> CartItem { get; set; }

and ApplicationUser in Project.Domain.Entities.Identity

public class ApplicationUser : IdentityUser {
    public ICollection<Post> Posts { get; } = [];
    public ICollection<Comment> Comment { get; } = [];
}

public class ApplicationUser : IdentityUser {
    public ICollection<Post> Posts { get; } = [];
    public ICollection<Comment> Comment { get; } = [];
}

i've moved migration files to Project.Infrastructure/Data/Migrations but now i can't do databtase update or make new migrations, or run the app

8 Replies

amirreza 🇮🇷🇵🇸OP•6d ago

├── Project.Domain
├── Project.Infrastructure
├── Project.Web
├── Project.sln
└── Project.sln.DotSettings.user

├── Project.Domain
├── Project.Infrastructure
├── Project.Web
├── Project.sln
└── Project.sln.DotSettings.user

Fayoka•6d ago

I am not sure honestly as I am not that experienced but don't you just have to add the attribute [Key] to the model IdentityUserLogin

amirreza 🇮🇷🇵🇸OP•6d ago

IdentityUserLogin is made by asp, not me and it has a primary key already

Fayoka•6d ago

i asked gippity, maybe the issiue is that you have to update the location of the migrations in the DI:

builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseNpgsql(
        builder.Configuration.GetConnectionString("ApplicationDbContext")
            ?? throw new InvalidOperationException("Connection string 'ApplicationDbContext' not found."),
        b => b.MigrationsAssembly("Project.Infrastructure") // 👈 IMPORTANT
    )
);

builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseNpgsql(
        builder.Configuration.GetConnectionString("ApplicationDbContext")
            ?? throw new InvalidOperationException("Connection string 'ApplicationDbContext' not found."),
        b => b.MigrationsAssembly("Project.Infrastructure") // 👈 IMPORTANT
    )
);

Otherwise I got no clue either and I am sorry if you already did that to lol 🙂

Unknown User•6d ago

Message Not Public

amirreza 🇮🇷🇵🇸OP•6d ago

🫠 🫠 yup

Fayoka•6d ago

god damnit haha, the hallucinations as well when i tried to explain to gippity what the correct solution was as well xd

amirreza 🇮🇷🇵🇸OP•6d ago

thank you 🙌

Gaming

Programming

✅ Unable to create a 'DbContext' of type 'ApplicationDbContext'.

Did you find this page helpful?