I have primary keys in my database which are of NVARCHAR2 type. By default data is inserted into these columns as case sensitive which means insertion of both 'ABCD' and 'Abcd' are allowed.
Can I change the settings in Oracle so that the primary keys work case in-sensitively? I wanted Oracle to throw an error if someone is inserting 'Abcd' and if there is already a record with primary key 'ABCD'.
Note: I am using Entity Framework.
Search found 4 matches
- Fri 31 Jul 2009 13:48
- Forum: dotConnect for Oracle
- Topic: Case In-Sensitive primary key (NVARCHAR2 datatype) in Oracle
- Replies: 1
- Views: 2529
- Fri 10 Jul 2009 13:15
- Forum: dotConnect for Oracle
- Topic: Using same EDMX file for different schema
- Replies: 3
- Views: 2917
What will happen when we update schema again?
Thanks for your suggestion.
But, the problem is whenever I take an update of the EDMX from database then the EDMX will be regenerated and hence the schema information comes again. So, again I will not be able to switch between users.
Is there any permanent solution?
But, the problem is whenever I take an update of the EDMX from database then the EDMX will be regenerated and hence the schema information comes again. So, again I will not be able to switch between users.
Is there any permanent solution?
- Fri 10 Jul 2009 12:10
- Forum: dotConnect for Oracle
- Topic: Using same EDMX file for different schema
- Replies: 3
- Views: 2917
Using same EDMX file for different schema
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.
- Mon 06 Jul 2009 10:59
- Forum: dotConnect for Oracle
- Topic: Support for VS 2010 Beta1 in Dotconnect for Orcale v5.0.26.0
- Replies: 2
- Views: 2287
Support for VS 2010 Beta1 in Dotconnect for Orcale v5.0.26.0
Hi,
I am using Dotconnect for Orcale v5.0.26.0 Professional edition. Recently, i have downloaded VS2010 beta1 (.net Framework 4.0) and tried to run my previous running code (in VS2008). All files were converted but, EDMX file is giving run time error as: "Error 175: The specified store provider cannot be found in the configuration, or is not valid".
I tried copying all the entries of Devart.Data.Oracle from .net framework v2.0 machine.config file to v4.0 machine.config file. But, this resulted in Nothing. The same error still appears.
Please let me know if Dotconnect for Orcale v5.0.26.0 Professional edition is supported in VS2010 beta version?
I am using Dotconnect for Orcale v5.0.26.0 Professional edition. Recently, i have downloaded VS2010 beta1 (.net Framework 4.0) and tried to run my previous running code (in VS2008). All files were converted but, EDMX file is giving run time error as: "Error 175: The specified store provider cannot be found in the configuration, or is not valid".
I tried copying all the entries of Devart.Data.Oracle from .net framework v2.0 machine.config file to v4.0 machine.config file. But, this resulted in Nothing. The same error still appears.
Please let me know if Dotconnect for Orcale v5.0.26.0 Professional edition is supported in VS2010 beta version?