dotConnect throws an error on an Query like this (Oracle 12):
Code: Select all
dbContext.Class1.Include(o => o.OtherClass).FirstOrDefault(o => !o.IsDeleted)
'ORA-00918: column ambiguously defined'
Generated SQL:
Code: Select all
SELECT "o"."Id", "o"."IsDeleted", "o"."OtherClassId", "o.OtherClass"."Id", "o.OtherClass"."IsDeleted", "o.OtherClass"."Test"
FROM "Class1" "o"
LEFT JOIN "Class2" "o.OtherClass" ON "o"."OtherClassId" = "o.OtherClass"."Id"
WHERE "o"."IsDeleted" = 0
FETCH FIRST 1 ROWS ONLY