Devart Forums

Code: Select all

_dbContext.Class1.FirstOrDefault(o => o.MyBoolProp)

Code: Select all

SELECT "o"."Id", "o"."MyBoolProp"
FROM "Class1" "o"
WHERE (ROWNUM <= 1) AND "o"."MyBoolProp"

Code: Select all

 var works = dbContext.Class1
                .Include(o => o.OtherClass)
                .Where(o => o.IsDeleted == false) //Check is delete for Class1
                .OrderByDescending(o => o.Id)
                .Take(5)
                .ToList();

            var dontWorks = dbContext.Class1
                .Include(o => o.OtherClass)
                .Where(o => o.OtherClass.IsDeleted == false) //Check is delete for Class1.OtherClass
                .OrderByDescending(o => o.Id)
                .Take(5)
                .ToList();

Code: Select all

var works:
SELECT "t"."Id", "t"."IsDeleted", "t"."OtherClassId", "c"."Id", "c"."IsDeleted"
FROM (
    SELECT "o"."Id", "o"."IsDeleted", "o"."OtherClassId"
    FROM "Class1" "o"
    WHERE "o"."IsDeleted" = 0
    ORDER BY "o"."Id" DESC
) "t"
LEFT JOIN "Class2" "c" ON "t"."OtherClassId" = "c"."Id"
WHERE ROWNUM <= :p__p_0

Code: Select all

var dontWorks:
SELECT "t"."Id", "t"."IsDeleted", "t"."OtherClassId", "c"."Id", "c"."IsDeleted"
FROM (
    SELECT "o"."Id", "o"."IsDeleted", "o"."OtherClassId", "o.OtherClass"."Id" AS "c0", "o.OtherClass"."IsDeleted" AS "c1"
    FROM "Class1" "o"
    LEFT JOIN "Class2" "o.OtherClass" ON "o"."OtherClassId" = "o.OtherClass"."Id"
    WHERE "o.OtherClass"."IsDeleted" = 0
    ORDER BY "o"."Id" DESC, "o"."OtherClassId"
) "t"
LEFT JOIN "Class2" "c" ON "t"."OtherClassId" = "c"."Id"
WHERE ROWNUM <= :p__p_0