There is no foreign key in the database (Oracle) and the model and yet EF generated sql contains navigation column.

This is database first and the model was generated with SQL Server where foreign key was there. I removed those lines with HasForeignKey and then added support for Oracle. Now both Context classes have no code with HasForeignKey and there is no attribute on the Entity.

Foreign Key is still there on SQL Server but it is not there on Oracle and the code is being executed on Oracle.
I am using EFCore 3.1 with .Net 4.8.

I might have made some mistake which i am unable to identify, any suggestions please.

Generated sql.

Schema

Entity