Activities of "maliming"

Yes, requiresNew should be true

hi

Please check: https://abp.io/community/articles/understanding-transactions-in-abp-unit-of-work-0r248xsr

Great!

You have started a new uow. That’s no problem.

using (var uow = UnitOfWorkManager.Begin(requiresNew: true, isTransactional: true, isolationLevel: System.Data.IsolationLevel.ReadCommitted))
{
    using (_dataFilter.Disable())
    {
        reportPeriodId = await _reportDataRepository.CollectDataAsync(reportCode, paraObject.ReportDate, paraObject.Department, keyValueParams);
    }

    await uow.CompleteAsync();
}

You can enable the debug log of EF Core to see the SQL statement(EnableSensitiveDataLogging).

https://abp.io/support/questions/8622/How-to-enable-Debug-logs-for-troubleshoot-problems

hi

I can't understand your problem. Can you share some test code so that I can reproduce it on my computer?

Thanks.

hi

Please try to begin a new UOW instead of using [UnitOfWork(true, System.Data.IsolationLevel.ReadCommitted)]

See https://abp.io/community/articles/understanding-transactions-in-abp-unit-of-work-0r248xsr

hi

Please use these code to override the login and register class.

https://we.tl/t-YQ7tQxfSjw

hi

https://github.com/maliming/PortalApi-main/invitations

hi

I have changed the PermissionAppService service, now, there is only one SQL query.

What is your GitHub username? I will invite you to join.

https://github.com/maliming/PortalApi-main/commit/4e479470d6076e3971a05053950cbf93b20b602c

[INF] Request starting HTTP/2 GET api/permission-management/permissions?providerName=R&providerKey=admin

[INF] Executed DbCommand (6ms) [Parameters=[@__names_0='["FeatureManagement.ManageHostFeatures",.......]'
(Size = -1), @__providerName_1='R' 
(Size = 64), @__providerKey_2='admin' (Size = 64)], CommandType='"Text"', CommandTimeout='30']

SELECT [a].[Id], [a].[Name], [a].[ProviderKey], [a].[ProviderName], [a].[TenantId]
FROM [AbpPermissionGrants] AS [a]
WHERE [a].[TenantId] IS NULL AND [a].[Name] IN (
    SELECT [n].[value]
    FROM OPENJSON(@__names_0) WITH ([value] nvarchar(128) '$') AS [n]
) AND [a].[ProviderName] = @__providerName_1 AND [a].[ProviderKey] = @__providerKey_2

[INF] Request finished HTTP/2 GET /api/permission-management/permissions?providerName=R&providerKey=admin - 412.39ms

hi