Database Schema owner is hardcoded in Entity Model / SQL

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
m12345
Posts: 1
Joined: Fri 26 Mar 2010 22:25

Database Schema owner is hardcoded in Entity Model / SQL

Post by m12345 » Fri 26 Mar 2010 22:32

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)

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 29 Mar 2010 14:11

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.

Post Reply