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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
jpl
Posts: 13
Joined: Fri 12 Sep 2008 14:47

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

Post by 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...

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 24 Sep 2008 16:41

The problem is fixed. New build will be available in several days.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by 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

Post Reply