I have another problem while moving from NHibernate to DotConnect with EfCore. We have DotConnect 9.4.280 running against an existing Oracle 11g Database.
Now I have trouble with joining some entities. I have a ReportBox with one to one mapping to a ReportVersion, which belongs to one Report. So one ReportBox has one ReportVersion with one Report.
If I try to get all of these together I get an ORA-00918: column ambiguously defined. As you can see in the following SQL query some columns on different tables have the same name, but aren't renamed in the query.
Code: Select all
SELECT "x".ReportBoxId,
...
"x".ReportVersionId,
"x.reportversion".ReportVersionId,
"x.reportversion".ReportBoxId,
"x.reportversion".ReportId,
...
"x.reportversion.report".ReportId,
...
FROM TblReportBox "x"
LEFT JOIN TblReportVersion "x.reportversion"
ON "x".ReportBoxId = "x.reportversion".ReportBoxId
LEFT JOIN TblReport "x.reportversion.report"
ON "x.reportversion".ReportId = "x.reportversion.report".ReportId
WHERE EXISTS
( SELECT 1 FROM TblReportBoxSequence "s"
WHERE ( "s".berichtboxsequenzid = :p__boxSequenceId_0 ) AND ( "x".ReportBoxId = "s".ReportBoxId) )
ORDER BY "x".ReportBoxId,"x.reportversion".ReportBoxId
FETCH first 2 ROWS only
Sincerely,
Butzei