Activities of "maliming"

hi

I use https://github.com/maliming/PortalApi-main project with brand new SQL server database.

Migrate and run API.Host. Login admin user, then check the permission endpoint.

Here are the results, as you can see, the response time is about 200-300ms

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