dotConnect throws an error on an boolean Query like this (Oracle 10):
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
_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