Physically seperate DB for tenant #3334

10 Answer(s)

• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

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

  

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 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

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 years ago

  Please note i am using 4.2.2

  Markdown supported.

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

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  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);
          }
      }
  }
  

  Markdown supported.

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

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  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

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 years ago

  Hello liangshiwei, Thanks. what should be next step?

  Markdown supported.

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

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

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

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 years ago

  ok. Thanks. Let me try

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 years ago

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

  

  Markdown supported.

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

  Save Cancel
• 

  0

  shobhit created 4 years ago

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

  Markdown supported.

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

  Save Cancel