MySqlConnector.MySqlException (0x80004005): Table '*.AbpSessions' doesn't exist #8172

0

maliming created 2 months ago

Support Team Fullstack Developer

hi

You should add new ef core migrations and update the database.

0

zhongfang created one month ago

I am very practices with ef core migrations.

Perhaps I missed any module or fuction call?

[ReplaceDbContext(typeof(IIdentityProDbContext))]
[ReplaceDbContext(typeof(ISaasDbContext))]
[ConnectionStringName("Default")]
public class BlazorOneDbContext :
    AbpDbContext&lt;BlazorOneDbContext&gt;,
    IIdentityProDbContext,
    ISaasDbContext
{
    /* Add DbSet properties for your Aggregate Roots / Entities here. */

    #region Entities from the modules

    /* Notice: We only implemented IIdentityProDbContext and ISaasDbContext
     * and replaced them for this DbContext. This allows you to perform JOIN
     * queries for the entities of these modules over the repositories easily. You
     * typically don't need that for other modules. But, if you need, you can
     * implement the DbContext interface of the needed module and use ReplaceDbContext
     * attribute just like IIdentityProDbContext and ISaasDbContext.
     *
     * More info: Replacing a DbContext of a module ensures that the related module
     * uses this DbContext on runtime. Otherwise, it will use its own DbContext class.
     */

    // Identity
    public DbSet&lt;IdentityUser&gt; Users { get; set; }
    public DbSet&lt;IdentityRole&gt; Roles { get; set; }
    public DbSet&lt;IdentitySession&gt; Sessions { get; set; }
    public DbSet&lt;IdentityClaimType&gt; ClaimTypes { get; set; }
    public DbSet&lt;OrganizationUnit&gt; OrganizationUnits { get; set; }
    public DbSet&lt;IdentitySecurityLog&gt; SecurityLogs { get; set; }
    public DbSet&lt;IdentityLinkUser&gt; LinkUsers { get; set; }
    public DbSet&lt;IdentityUserDelegation&gt; UserDelegations { get; }

    // SaaS
    public DbSet&lt;Tenant&gt; Tenants { get; set; }
    public DbSet&lt;Edition&gt; Editions { get; set; }
    public DbSet&lt;TenantConnectionString&gt; TenantConnectionStrings { get; set; }

    #endregion

    public BlazorOneDbContext(DbContextOptions&lt;BlazorOneDbContext&gt; options)
        : base(options)
    {

    }

    protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);

        /* Include modules to your migration db context */

        builder.ConfigurePermissionManagement();
        builder.ConfigureSettingManagement();
        builder.ConfigureBackgroundJobs();
        builder.ConfigureAuditLogging();
        builder.ConfigureIdentityPro();
        builder.ConfigureOpenIddict();
        builder.ConfigureFeatureManagement();
        builder.ConfigureLanguageManagement();
        builder.ConfigureSaas();
        builder.ConfigureTextTemplateManagement();
        builder.ConfigureBlobStoring();
        builder.ConfigureGdpr();
    ~~~

0

maliming created one month ago

Support Team Fullstack Developer

Looks your DbContext no problem.

What happens if you run the dotnet ef migrations add NewTest command?

0

zhongfang created one month ago

Oh, after I run the dotnet ef migrations add... The problem has been resolved.

0

maliming created one month ago

Support Team Fullstack Developer

Good news.

5 Answer(s)