Problem with Schema - User prefix in Oracle

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Problem with Schema - User prefix in Oracle

Post by crazypit » Fri 29 May 2009 11:17


If i generate the classes using the O-R tool, each business class e.g. Customer gets a Table attribute in which the name of the table is prefixed by the relevant default schema E.g. SCHEMA1.CUSTOMERS. If i use a different schema when i instantiate the DataContext class, data for Customers are still retrieved from the SCHEMA1.CUSTOMERS table!!! Both users have DBA priviledges and i think this is the reason behind the visibility of the old schema. If i change the attribute to point to a non existent schema, i get an error "table or view does not exist". It seems to me, that the tool should not prefix the table name with a user. If i just delete the schema prefix, everything works as expected.

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

Post by AndreyR » Fri 29 May 2009 12:59

We follow the way given by Microsoft in both Entity Framework and LINQ to SQL.
Thank you for the suggestion, we will investigate the possibility of improving the designed behaviour.

Post Reply