Error Running dotnet test for AdministrationService #10194

9 Answer(s)

• 

  0

  AI-Bot created yesterday

  Support Team ABP Agent

  1. Solution

  • Root cause

    • Your AdministrationService integration tests run with a single in‑memory SQLite connection and only create tables for the service’s own DbContexts (AdministrationServiceDbContext and BlobStoringDbContext).
    • The failing tests hit ABP Language Management (DatabaseLanguageProvider and EfCoreLanguageRepository), which uses its own EF Core DbContext (LanguageManagementDbContext). Since your test setup doesn’t create tables for that DbContext, SQLite throws “no such table: AbpLanguages/AbpLanguageTexts”.

  • Recommended fix (create tables for every EF Core module DbContext used during tests)

    • Ensure the test module depends on the EF Core package of the used module(s). For Language Management:
      • Add a reference to Volo.Abp.LanguageManagement.EntityFrameworkCore in your AdministrationService.EntityFrameworkCore.Tests project (or your Web/Host test project if that’s where the failing tests live).
    • In your test module where you configure the in‑memory SQLite connection, configure the same connection for LanguageManagementDbContext and create its tables using IRelationalDatabaseCreator.CreateTables().

    Example (extend your existing CreateDatabaseAndGetConnection and service configuration):

  using Microsoft.Data.Sqlite;
    using Microsoft.EntityFrameworkCore;
    using Microsoft.EntityFrameworkCore.Infrastructure;
    using Microsoft.EntityFrameworkCore.Storage;
    using Microsoft.Extensions.DependencyInjection;
    using Volo.Abp.EntityFrameworkCore;
    using Volo.Abp.Modularity;
    using Volo.Abp.LanguageManagement.EntityFrameworkCore;
  
    [DependsOn(
        typeof(AdministrationServiceEntityFrameworkCoreModule),
        typeof(AbpEntityFrameworkCoreSqliteModule),
        typeof(AbpLanguageManagementEntityFrameworkCoreModule) // add this
    )]
    public class AdministrationServiceEntityFrameworkCoreTestModule : AbpModule
    {
        public override void ConfigureServices(ServiceConfigurationContext context)
        {
            var sqliteConnection = CreateDatabaseAndGetConnection();
  
            Configure<AbpDbContextOptions>(options =>
            {
                options.Configure<AdministrationServiceDbContext>(c =>
                {
                    c.DbContextOptions.UseSqlite(sqliteConnection);
                });
  
                options.Configure<BlobStoringDbContext>(c =>
                {
                    c.DbContextOptions.UseSqlite(sqliteConnection);
                });
  
                // configure LanguageManagementDbContext to use the same connection
                options.Configure<LanguageManagementDbContext>(c =>
                {
                    c.DbContextOptions.UseSqlite(sqliteConnection);
                });
            });
        }
  
        private static SqliteConnection CreateDatabaseAndGetConnection()
        {
            var connection = new SqliteConnection("Data Source=:memory:");
            connection.Open();
  
            // AdministrationService
            new AdministrationServiceDbContext(
                new DbContextOptionsBuilder<AdministrationServiceDbContext>().UseSqlite(connection).Options
            ).GetService<IRelationalDatabaseCreator>().CreateTables();
  
            // BlobStoring
            new BlobStoringDbContext(
                new DbContextOptionsBuilder<BlobStoringDbContext>().UseSqlite(connection).Options
            ).GetService<IRelationalDatabaseCreator>().CreateTables();
  
            // LanguageManagement: creates AbpLanguages, AbpLanguageTexts, etc.
            new LanguageManagementDbContext(
                new DbContextOptionsBuilder<LanguageManagementDbContext>().UseSqlite(connection).Options
            ).GetService<IRelationalDatabaseCreator>().CreateTables();
  
            return connection;
        }
    }
  

  • Notes
    • This same pattern applies to any ABP module that introduces its own DbContext and is used during your tests (e.g., SettingManagementDbContext, TextTemplateManagementDbContext, etc.). Add the module’s EF Core package to the test project, configure the DbContext to share the SQLite connection, and call CreateTables() for it in your test setup.
    • You do not need to write custom “table creation logic” beyond calling CreateTables() for each involved DbContext; ABP’s and EF Core’s metadata define the schema.

  2. Sources

  • https://abp.io/docs/latest/framework/data/entity-framework-core/migrations
  • https://abp.io/support/questions/5285
  • https://abp.io/support/questions/1737

  ---

  This response was generated by AI. If it didn’t solve your problem, feel free to post a new answer — our support team will jump in to help you soon.

  Save Cancel
• 

  0

  maliming created yesterday

  Support Team Fullstack Developer

  hi

  Please update the CreateDatabaseAndGetConnection as below

     
  private static SqliteConnection CreateDatabaseAndGetConnection()
  {
      var connection = new SqliteConnection("Data Source=:memory:");
      connection.Open();
  
      // AdministrationServiceDbContext ()
      new AdministrationServiceDbContext(
          new DbContextOptionsBuilder<AdministrationServiceDbContext>().UseSqlite(connection).Options
      ).GetService<IRelationalDatabaseCreator>().CreateTables();
      
      // BlobStoringDbContext
      new BlobStoringDbContext(
          new DbContextOptionsBuilder<BlobStoringDbContext>().UseSqlite(connection).Options
      ).GetService<IRelationalDatabaseCreator>().CreateTables();
      
      // LanguageManagementDbContext ()
      new LanguageManagementDbContext(
          new DbContextOptionsBuilder<LanguageManagementDbContext>().UseSqlite(connection).Options
      ).GetService<IRelationalDatabaseCreator>().CreateTables();
      
      return connection;
  }
  

  

  Thanks.

  Save Cancel

  1
• 

  0

  vmquang95 created 19 hours ago

  [maliming] said: hi

  Please update the CreateDatabaseAndGetConnection as below

      
  private static SqliteConnection CreateDatabaseAndGetConnection() 
  { 
      var connection = new SqliteConnection("Data Source=:memory:"); 
      connection.Open(); 
   
      // AdministrationServiceDbContext () 
      new AdministrationServiceDbContext( 
          new DbContextOptionsBuilder<AdministrationServiceDbContext>().UseSqlite(connection).Options 
      ).GetService<IRelationalDatabaseCreator>().CreateTables(); 
       
      // BlobStoringDbContext 
      new BlobStoringDbContext( 
          new DbContextOptionsBuilder<BlobStoringDbContext>().UseSqlite(connection).Options 
      ).GetService<IRelationalDatabaseCreator>().CreateTables(); 
       
      // LanguageManagementDbContext () 
      new LanguageManagementDbContext( 
          new DbContextOptionsBuilder<LanguageManagementDbContext>().UseSqlite(connection).Options 
      ).GetService<IRelationalDatabaseCreator>().CreateTables(); 
       
      return connection; 
  } 
  

  

  Thanks.

  Hello maliming, I followed your instructions. After running dotnet test, the errors related to the missing AbpLanguages and AbpLanguageTexts tables were resolved. However, the testing process is now taking a very long time and continues running without producing any results.

  

  Save Cancel

  1
• 

  0

  maliming created 19 hours ago

  Support Team Fullstack Developer

  hi

  I will check it again

  Thanks

  Save Cancel

  1 1
• 

  0

  maliming created 19 hours ago

  Support Team Fullstack Developer

  hi

  Configure<AbpExternalLocalizationOptions>(options =>
  {
    
      options.SaveToExternalStore = false;
  });
  

  

  Save Cancel

  1 1
• 

  0

  vmquang95 created 17 hours ago

  [maliming] said: hi

  Configure<AbpExternalLocalizationOptions>(options => 
  {
     
      options.SaveToExternalStore = false; 
  }); 
  

  

  Thanks, maliming. I followed the solution you provided and it resolved the issue.

  new LanguageManagementDbContext(
      new DbContextOptionsBuilder<LanguageManagementDbContext>().UseSqlite(connection).Options
  ).GetService<IRelationalDatabaseCreator>().CreateTables();
  
  Configure<AbpExternalLocalizationOptions>(options =>
  {
      options.SaveToExternalStore = false;
  });
  

  I would like to understand why these steps need to be added manually. Without them, the tests fail. Shouldn’t ABP automatically handle this when generating a new project, so that the testing environment works out of the box?

  Could you please clarify why this behavior occurs and whether it is expected?

  Save Cancel
• 

  0

  maliming created 17 hours ago

  Support Team Fullstack Developer

  hi

  I have fixed this in the Studio template; the next version will be no problem.

  Thanks.

  Save Cancel

  1
• 

  0

  vmquang95 created 17 hours ago

  [maliming] said: hi

  I have fixed this in the Studio template; the next version will be no problem.

  Thanks.

  Thanks.

  Save Cancel
• 

  0

  maliming created 17 hours ago

  Support Team Fullstack Developer

  : )

  Save Cancel

  1