Devart Forums

Hi,
I developed my application with oracle client 11 and oracle server 11 in code first. Now I deployed my application on the test server and I got "ORA-00952 - Table or view does not exist" at first query.
So I tried from my machine with developing environment and I get the same when I use Oracle 10 meanwhile there aren't problems when I use Oracle 11 (using the same compiled code I change only the TNS Name)
How can I resolve it?

Thank you

Claudio

It seems like an old schema name is used in the queries, which are generated by EF engine in the new environment. You can check this using the dbMonitor tool that performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html

You can turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/ ... orkarounds.

Thank you for you response, thanks to dbMonitor I found my problem.
The problem was that the generated query have the " on every filedname and table name and so the query is case sensitive.
Thank you

Claudio

Please try the config.Workarounds.DisableQuoting = true; workaround.