Activities of "furkan.kara"

Hi,

I can't obfuscate whole project. If we can arrange an online meeting I'll show it there.

This is my class code:

namespace MyApp;

public class MyAppService : CrudAppService<MyEntity, MyEntityDto, Guid, GetListMyEntityDto, CreateMyEntityDto, UpdateMyEntityDto>, IMyAppService
{
    private readonly IMyCrudEntityRepository _myCrudEntityRepository;
    private readonly IRepository<MyEntity, Guid> _myEntityRepository;

    public MyAppService(IMyCrudEntityRepository myCrudEntityRepository,
                           IRepository<MyEntity, Guid> myEntityRepository) : base(myCrudEntityRepository)
    {
        _myEntityRepository = myEntityRepository;
    }

    public async Task GetTreeAsync()
    {
        var result = await _myEntityRepository.GetListAsync(x => x.MainId == Guid.Parse("SOME-KNOWN-GUID"), true);
    }
}

There is no significant debug log for ef core. There are two dbCommand execution log for this request and after that no logs.

2025-06-13 11:36:07.923 +03:00 [INF] Executed DbCommand (82ms) [Parameters=[@p1='False', @tenantId='***' (Nullable = true), @p4='True', @p3='True', @mainList={  } (DbType = Object)], CommandType='"Text"', CommandTimeout='0']
SELECT a."Id", a."ConcurrencyStamp", a."RefId", a."CreatedOn", a."CreatedBy", a."ExtraProps", a."ModifiedOn", a."ModifiedBy", a."CustomParam1", a."TenantId", a."Flag1", a."FormValue", a."TailoringValue",
       b."Id", c."Id", d."Id", e."Id"
FROM "SchemaX"."MyEntity" AS b
INNER JOIN (
    SELECT x."Id", x."Ref1", x."Ref2"
    FROM "SchemaX"."EntityA" AS x
    WHERE @p1 OR x."TenantId" = @tenantId
) AS c ON b."RefId" = c."Id"
INNER JOIN (
    SELECT y."Id"
    FROM "SchemaX"."EntityB" AS y
    WHERE (@p1 OR y."TenantId" = @tenantId) AND (@p4 OR (@p3 AND y."Id" = ANY (@mainList)))
) AS d ON c."Ref1" = d."Id"
LEFT JOIN "SchemaX"."EntityC" AS e ON c."Ref2" = e."Id"
INNER JOIN (
    SELECT z."Id", z."ConcurrencyStamp", z."RefId", z."CreatedOn", z."CreatedBy", z."ExtraProps", z."ModifiedOn", z."ModifiedBy", z."CustomParam1", z."TenantId", z."Flag1", z."FormValue", z."TailoringValue"
    FROM "SchemaX"."EntityD" AS z
    WHERE @p1 OR z."TenantId" = @tenantId
) AS a ON c."Id" = a."RefId"
WHERE (@p1 OR b."TenantId" = @tenantId) AND (@p4 OR (@p3 AND b."MainId" = ANY (@mainList))) AND b."MainId" = '***'
ORDER BY b."Id", c."Id", d."Id", e."Id"

2025-06-13 11:36:10.038 +03:00 [INF] Executed DbCommand (71ms) [Parameters=[@p1='False', @tenantId='***' (Nullable = true), @p4='True', @p3='True', @mainList={  } (DbType = Object)], CommandType='"Text"', CommandTimeout='0']
SELECT a."Id", a."ForeignKey1", a."ConcurrencyStamp", a."RefId", a."CreatedOn", a."CreatedBy", a."ExtraProps", a."ModifiedOn", a."ModifiedBy", a."TenantId",
       a."Id0", a."Explanation", a."IdentNumber", a."Text", a."RefX", a."FlagX",
       a."ConcurrencyStamp0", a."CreatedOn0", a."CreatedBy0", a."ExtraProps0", a."IsPending", a."ModifiedOn0", a."ModifiedBy0",
       a."RefMain", a."TenantId0", a."Title",
       b."Id", c."Id", d."Id", e."Id"
FROM "SchemaX"."MyEntity" AS b
INNER JOIN (
    SELECT x."Id", x."Ref1", x."Ref2"
    FROM "SchemaX"."EntityA" AS x
    WHERE @p1 OR x."TenantId" = @tenantId
) AS c ON b."RefId" = c."Id"
INNER JOIN (
    SELECT y."Id"
    FROM "SchemaX"."EntityB" AS y
    WHERE (@p1 OR y."TenantId" = @tenantId) AND (@p4 OR (@p3 AND y."Id" = ANY (@mainList)))
) AS d ON c."Ref1" = d."Id"
LEFT JOIN "SchemaX"."EntityC" AS e ON c."Ref2" = e."Id"
INNER JOIN (
    SELECT z."Id", z."ForeignKey1", z."ConcurrencyStamp", z."RefId", z."CreatedOn", z."CreatedBy", z."ExtraProps", z."ModifiedOn", z."ModifiedBy", z."TenantId",
           zz."Id" AS "Id0", zz."Explanation", zz."IdentNumber", zz."Text", zz."RefX", zz."FlagX",
           zz."ConcurrencyStamp" AS "ConcurrencyStamp0", zz."CreatedOn" AS "CreatedOn0", zz."CreatedBy" AS "CreatedBy0", zz."ExtraProps" AS "ExtraProps0",
           zz."IsPending", zz."ModifiedOn" AS "ModifiedOn0", zz."ModifiedBy" AS "ModifiedBy0", zz."RefMain", zz."TenantId" AS "TenantId0", zz."Title"
    FROM "SchemaX"."EntityE" AS z
    INNER JOIN (
        SELECT zz."Id", zz."Explanation", zz."IdentNumber", zz."Text", zz."RefX", zz."FlagX",
               zz."ConcurrencyStamp", zz."CreatedOn", zz."CreatedBy", zz."ExtraProps",
               zz."IsPending", zz."ModifiedOn", zz."ModifiedBy", zz."RefMain", zz."TenantId", zz."Title"
        FROM "SchemaX"."EntityF" AS zz
        WHERE @p1 OR zz."TenantId" = @tenantId
    ) AS zz ON z."ForeignKey1" = zz."Id"
    WHERE @p1 OR z."TenantId" = @tenantId
) AS a ON c."Id" = a."RefId"
WHERE (@p1 OR b."TenantId" = @tenantId) AND (@p4 OR (@p3 AND b."MainId" = ANY (@mainList))) AND b."MainId" = '***'
ORDER BY b."Id", c."Id", d."Id", e."Id"

I obfuscated SQL query to hide sensitive table and column names via AI.

I have included related entities in the Configure<AbpEntityOptions> body in the MyEntityFrameworkCoreModule class. There are no circular references. So AI answer is not enough for me.