I am switching a project from edmx to ef core
I am switching a project from edmx to ef core. I have child navigation models that share property names (Like the foreign key) Because of this I keep getting the error Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00918: column ambiguously defined. These are legacy tables so changing the column name is not an option. It's to the point im using raw queries but its a mess and this can't be the only way?
7 Replies
What is the query?
And waht Oracle version?
var customer = await _model.CUSTOMER.Include(x=> x.SALESPERSON)
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
CUSTOMER and SALESPERSON share the same foreign key name
What is the SQL of the query?
I think I know what it is. And suspect it is a known Oracle 12.1 bug.
GitHub
Column ambiguously defined ORA-00918 · Issue #103 · oracle/dotnet-d...
The code below results in 'Column ambiguously defined ORA-00918' This occurs if version of Oracle.EntityFrameworkCore is 3.19.80 Worked well in Oracle.EntityFrameworkCore 2.19.90 `class Ord...
lol
thats exactly what im experiencing
when i do .any it breaks because it creates true/false and oracle doesnt support bools
do you know if there is any fix for that than doing .where?
As much informaton as I know is in that issue.
i am on ef core 7.0 not 3.x, unless its broken on 3.1+? would changing ef core versions help?