Switching Context #1219

11 Answer(s)

• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  If your tenant has a separate connection string, you should switch the tenant of the current context to switch the DbContext using a different connection string.

  https://docs.abp.io/en/abp/latest/Multi-Tenancy#change-the-current-tenant

  You should not create DbCotext manually, abp will manage it automatically.

  Save Cancel
• 

  0

  MarekH created 3 years ago

  hi

  If your tenant has a separate connection string, you should switch the tenant of the current context to switch the DbContext using a different connection string.

  https://docs.abp.io/en/abp/latest/Multi-Tenancy#change-the-current-tenant

  You should not create DbCotext manually, abp will manage it automatically.

  Hello Maliming,

  Thanks for giving above answer its helpful to us.

  I have check that we are able to switch the tenant by using CurrentTenant.Change() method in HttpApi.Host Layer you can see the below image.It's working

  

  I have tried the same way with micro-service (Create new micro-service) and write similar code which is in above image and call the api. At that time I am not able to call api, it gives a 500 error. I have also added reference of Application layer and added related reference project.

  Can we access the Repository of any table in micro-service ? Please provide some step for access the table repository in micro-service

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  it gives a 500 error.

  Can you share the error logs?

  Save Cancel
• 

  0

  MarekH created 3 years ago

  it gives a 500 error.

  Can you share the error logs?

  Hello maliming,

  I have downloaded a sample code from Abp.io and added a microservice project named FD.Demo.MicroService.Host to it. I have created PostGreController in V1 folder of controller folder inside FD.Demo.MicroService.Host project. Now that controller contains a method test(API) which calls IAppUserRepository method (GetListAsync for get the list of users) in FD.Demo.Domain project and returns the list of users. When executing Test API of PostGreController from FD.Demo.MicroService.Host, swagger is showing 500 error. I have attached sample project file which is given below.

  Steps:- 1)download the below project 2)Execute the microservice Test api

  Project Link:- deleted

  Our Purpose is to Change Tenant using CurrentTenant.Change() in MicroService. We are not able to access the Repository in MicroService Layer.We have added the Reference of FD.Demo.Domain for accessing Repository of AppUser. We are not getting any compile time error however we are not able to access the Repository on MicroService API.

  Can you please check above example and let me know how can I Access the reposity in MicroService Layer.

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  Please share the proejct via email liming.ma@volosoft.com

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  Please check PostGreController in FD.Demo.MicroService.Host project. We are trying to access appuserRepository for specific tenant but without any luck.

  You can use CurrentTenant.Change to switch host and tenant.

  [ApiController]
  public class PostGreController : AbpController
  {
  
      private readonly IAppUsers _appuserRepository;
      private readonly IDbContextProvider<DemoDbContext> _dbContextProvider;
  
      public PostGreController(IAppUsers appuserRepository, IDbContextProvider<DemoDbContext> dbContextProvider)
      {
          _appuserRepository = appuserRepository;
          _dbContextProvider = dbContextProvider;
      }
  
  
      [Route("/api/v1/test")]
      [HttpGet]
      [ProducesResponseType((int)HttpStatusCode.Accepted)]
      public async Task<IActionResult> test()
      {
          using (CurrentTenant.Change(null))
          {
              var abcInHostDatabase = await _appuserRepository.GetListAsync();
          }
  
          var ten1 = new Guid("your tenant id to switch tenant");
          using (CurrentTenant.Change(ten1))
          {
              var abcInTenantDatabase = await _appuserRepository.GetListAsync();
          }
  
  
          var demoDbContext = await _dbContextProvider.GetDbContextAsync();
  
          return Ok();
      }
  }
  

  Our general issue is, how to access DemoDBContext from FD.Demo.Microservice.Host project.

  Reference FD.Demo.EntityFrameworkCore.csproj in your FD.Demo.Microservice.Host project.

  var demoDbContext = await _dbContextProvider.GetDbContextAsync();

  Save Cancel
• 

  0

  MarekH created 3 years ago

  hi

  Please check PostGreController in FD.Demo.MicroService.Host project. We are trying to access appuserRepository for specific tenant but without any luck.

  You can use CurrentTenant.Change to switch host and tenant.

  [ApiController] 
  public class PostGreController : AbpController 
  { 
   
      private readonly IAppUsers _appuserRepository; 
      private readonly IDbContextProvider<DemoDbContext> _dbContextProvider; 
   
      public PostGreController(IAppUsers appuserRepository, IDbContextProvider<DemoDbContext> dbContextProvider) 
      { 
          _appuserRepository = appuserRepository; 
          _dbContextProvider = dbContextProvider; 
      } 
   
   
      [Route("/api/v1/test")] 
      [HttpGet] 
      [ProducesResponseType((int)HttpStatusCode.Accepted)] 
      public async Task<IActionResult> test() 
      { 
          using (CurrentTenant.Change(null)) 
          { 
              var abcInHostDatabase = await _appuserRepository.GetListAsync(); 
          } 
   
          var ten1 = new Guid("your tenant id to switch tenant"); 
          using (CurrentTenant.Change(ten1)) 
          { 
              var abcInTenantDatabase = await _appuserRepository.GetListAsync(); 
          } 
   
   
          var demoDbContext = await _dbContextProvider.GetDbContextAsync(); 
   
          return Ok(); 
      } 
  } 
  

  Our general issue is, how to access DemoDBContext from FD.Demo.Microservice.Host project.

  Reference FD.Demo.EntityFrameworkCore.csproj in your FD.Demo.Microservice.Host project.

  var demoDbContext = await _dbContextProvider.GetDbContextAsync();

  Hello Maliming,

  As per your reply, I tried giving reference of FD.Demo.EntityFrameworkCore.csproj to my FD.Demo.Microservice.Host project but I am still getting the same error. Can we please schedule a call?

  Save Cancel
• 

  0

  gterdem created 3 years ago

  Senior .NET Developer

  Hello Maliming,

  As per your reply, I tried giving reference of FD.Demo.EntityFrameworkCore.csproj to my FD.Demo.Microservice.Host project but I am still getting the same error. Can we please schedule a call?

  Can you double check if you add the DependsOn attribute in the FDDemoMicroserviceHostModule as well?

  Save Cancel
• 

  0

  MarekH created 3 years ago

  Yes We have added DependsOn attribute in FDDemoMicroserviceHostModule. We are still not able to access the dbContext.

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  Send me an email when you're available, I can remote check it again.

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  I back the Question Credits to you, you can open a new quesion.

  Save Cancel