How to initialize unit tests to use in memory database for SettingManagementDbContext #1804

1 Answer(s)

• 

  0

  alper created 5 years ago

  Support Team Director

  your domain service should depend on the EntityFrameworkCore.Test project. and your EntityFrameworkCore.Test project module class should be like this

  You can create a new project from module template, to see how it works

  abp new Acme.MyProModule -t module-pro -csf
  

  [DependsOn(
          typeof(MyProjectNameTestBaseModule),
          typeof(MyProjectNameEntityFrameworkCoreModule),
          typeof(AbpEntityFrameworkCoreSqliteModule)
          )]
      public class MyProjectNameEntityFrameworkCoreTestModule : AbpModule
      {
          public override void ConfigureServices(ServiceConfigurationContext context)
          {
              var sqliteConnection = CreateDatabaseAndGetConnection();
  
              Configure<AbpDbContextOptions>(options =>
              {
                  options.Configure(abpDbContextConfigurationContext =>
                  {
                      abpDbContextConfigurationContext.DbContextOptions.UseSqlite(sqliteConnection);
                  });
              });
          }
          
          private static SqliteConnection CreateDatabaseAndGetConnection()
          {
              var connection = new SqliteConnection("Data Source=:memory:");
              connection.Open();
  
              new MyProjectNameDbContext(
                  new DbContextOptionsBuilder<MyProjectNameDbContext>().UseSqlite(connection).Options
              ).GetService<IRelationalDatabaseCreator>().CreateTables();
              
              return connection;
          }
      }
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel