Querying EF model with "name", "id" or "date" columns fails

Querying EF model with "name", "id" or "date" columns fails

Postby jpl » Sat 20 Sep 2008 09:20

I don't know if it is still the case with the latest release because I changed the column names of my table to continue working, but if you have a table with either "date", "id" or "name" as a column name, the entity framework model will be properly generated but the queries formed by the provider will omit to quote the column names and will cause an sql exception. There are certainly many other reserved names that will cause the same exception when not quoted.

select name from user.table => select "name" from user.table

If it could be fixed if it's not fixed yet...
jpl
 
Posts: 13
Joined: Fri 12 Sep 2008 14:47

Postby Shalex » Wed 24 Sep 2008 16:41

The problem is fixed. New build will be available in several days.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 29 Sep 2008 13:37

The new build of OraDirect .NET version 4.75.43 is available!
Please visit http://www.devart.com/forums/viewtopic.php?t=12982
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle