Page 1 of 1

Database Schema owner is hardcoded in Entity Model / SQL

Posted: Fri 26 Mar 2010 22:32
by m12345
At design time, the edmx file gets created with the schema owner hardcoded. This schema owner is used in the SQL at runtime. This creates problems if the development environment has a different schema owner than in production. Is there a way to prevent the schema name from being used in the SQL, other than manually edit the edmx file to remove the schema name?

(FYI: We are using EF 1.0; dotConnect for Oracle version 5.0.12)

Posted: Mon 29 Mar 2010 14:11
by AndreyR
The reason of this behaviour is the possibility to add entities from different schemas to the model.
The only way to overcome this is to manually remove the Schema attribute from the model.