Using same EDMX file for different schema
Posted: Fri 10 Jul 2009 12:10
I have two databases with same Tables/Functions/Procedures etc. When I use same schema name in both databases then the EDMX does fine (Same EDMX can be used for both database by changing the connection string).
But, when the schema name (username in case of oracle 10g) is different then it gives me the compilation error.
Is there any way to use same EDMX file with different schema names? I wanted to use same database with two different schemas for two users so that both users can add/edit data only in their schema space.
Any help will be greatly appreciated.
But, when the schema name (username in case of oracle 10g) is different then it gives me the compilation error.
Is there any way to use same EDMX file with different schema names? I wanted to use same database with two different schemas for two users so that both users can add/edit data only in their schema space.
Any help will be greatly appreciated.