Physically seperate DB for tenant #3334

10 Answer(s)

• 

  0

  liangshiwei created 2 years ago

  Support Team Fullstack Developer

  Hi,

  When you creating a tenant, you can set the connection string for it.

  

  Save Cancel
• 

  0

  shobhit created 2 years ago

  1. create seperate db for tenant
  2. run the db migrator project have default connection string pointing to tenant db
  4. Login to angular application as host admin and create new tenant and set the new db connection string
  5. Logout as host and select new tenant and try to login a. Cannot login as admin user created b. Cannot login as host admin default credentials

  Save Cancel
• 

  0

  shobhit created 2 years ago

  Please note i am using 4.2.2

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  Support Team Fullstack Developer

  Hi,

  You can add a TenantChangedEventHandler to your domain project.

  public class TenantChangedEventHandler : ILocalEventHandler<EntityChangedEventData<Tenant>>, ITransientDependency
  {
      private readonly IEnumerable<I<YourProjectName>DbSchemaMigrator> _dbSchemaMigrators;
      private readonly ICurrentTenant _currentTenant;
      private readonly IUnitOfWorkManager _unitOfWorkManager;
      private readonly IDataSeeder _dataSeeder;
      private readonly ITenantStore _tenantStore;
      private readonly ILogger<TenantChangedEventHandler> _logger;
  
      public TenantChangedEventHandler(
          IEnumerable<I<YourProjectName>DbSchemaMigrator> dbSchemaMigrators,
          ICurrentTenant currentTenant,
          IUnitOfWorkManager unitOfWorkManager,
          IDataSeeder dataSeeder, 
          ITenantStore tenantStore, 
          ILogger<TenantChangedEventHandler> logger)
      {
          _dbSchemaMigrators = dbSchemaMigrators;
          _currentTenant = currentTenant;
          _unitOfWorkManager = unitOfWorkManager;
          _dataSeeder = dataSeeder;
          _tenantStore = tenantStore;
          _logger = logger;
      }
  
      public async Task HandleEventAsync(EntityChangedEventData<Tenant> eventData)
      {
          await MigrateAndSeedForTenantAsync(
              eventData.Entity.Id
          );
      }
  
      private async Task MigrateAndSeedForTenantAsync(
          Guid tenantId)
      {
          try
          {
              using (_currentTenant.Change(tenantId))
              {
                  // Create database tables if needed
                  using (var uow = _unitOfWorkManager.Begin(requiresNew: true, isTransactional: false))
                  {
                      var tenantConfiguration = await _tenantStore.FindAsync(tenantId);
                      if (tenantConfiguration?.ConnectionStrings != null &&
                          !tenantConfiguration.ConnectionStrings.Default.IsNullOrWhiteSpace())
                      {
                          foreach (var migrator in _dbSchemaMigrators)
                          {
                              await migrator.MigrateAsync();
                          }
                      }
  
                      await uow.CompleteAsync();
                  }
  
                  // Seed data
                  using (var uow = _unitOfWorkManager.Begin(requiresNew: true, isTransactional: true))
                  {
                      await _dataSeeder.SeedAsync(
                          new DataSeedContext(tenantId)
                      );
  
                      await uow.CompleteAsync();
                  }
              }
          }
          catch (Exception ex)
          {
              _logger.LogException(ex);
          }
      }
  }
  

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  Support Team Fullstack Developer

  BTW, we recommend that you upgrade to the latest version, It contains lots of performance improvements and bug fixes as well as new features

  Save Cancel
• 

  0

  shobhit created 2 years ago

  Hello liangshiwei, Thanks. what should be next step?

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  Support Team Fullstack Developer

  Hi,

  That's all, when you create a tenant and set its connection string, you will see the database has been created

  Save Cancel
• 

  0

  shobhit created 2 years ago

  ok. Thanks. Let me try

  Save Cancel
• 

  0

  shobhit created 2 years ago

  When creating new tenant we don't provide connection string. After tenant creation, there is provision to provide new connection string.

  

  Save Cancel
• 

  0

  shobhit created 2 years ago

  No Worries and Thanks for all help. I am able to setup and run the tenant in new DB

  Save Cancel