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

5 Answer(s)

• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

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

  Save Cancel
• 

  0

  zhongfang created 10 months 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<BlazorOneDbContext>,
      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<IdentityUser> Users { get; set; }
      public DbSet<IdentityRole> Roles { get; set; }
      public DbSet<IdentitySession> Sessions { get; set; }
      public DbSet<IdentityClaimType> ClaimTypes { get; set; }
      public DbSet<OrganizationUnit> OrganizationUnits { get; set; }
      public DbSet<IdentitySecurityLog> SecurityLogs { get; set; }
      public DbSet<IdentityLinkUser> LinkUsers { get; set; }
      public DbSet<IdentityUserDelegation> UserDelegations { get; }
  
      // SaaS
      public DbSet<Tenant> Tenants { get; set; }
      public DbSet<Edition> Editions { get; set; }
      public DbSet<TenantConnectionString> TenantConnectionStrings { get; set; }
  
      #endregion
  
      public BlazorOneDbContext(DbContextOptions<BlazorOneDbContext> 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();
      ~~~
  

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  Looks your DbContext no problem.

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

  Save Cancel
• 

  0

  zhongfang created 10 months ago

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

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  Good news.

  Save Cancel