dotConnect for Oracle v5.70 bug report
Posted: Fri 18 Jun 2010 15:59
Hi,
There is one table of my client's Oracle DB that contains a reserved keyword as the Column Name. When I using Devart LinqConnect Model to query some data and apply some filter condition with the "special" column will cause an Exception. That exception was occured due to some column not encoded as a double quote (") in the column name in the WHERE clause that Devart LinqConnect Model generated.
for example:
This LINQ query transform into the following SQL command like this:
But you should transform LINQ as the following:
I would like to suggest you to apply surrounding double quote on each column name to avoid this problem.
There is one table of my client's Oracle DB that contains a reserved keyword as the Column Name. When I using Devart LinqConnect Model to query some data and apply some filter condition with the "special" column will cause an Exception. That exception was occured due to some column not encoded as a double quote (") in the column name in the WHERE clause that Devart LinqConnect Model generated.
for example:
Code: Select all
var q = (from p in db.Table1 where p.COLUMN == "TEST" select p).ToList();
Code: Select all
SELECT * FROM TBS.Table1 WHERE TBS.COLUMN = 'TEST'
Code: Select all
SELECT * FROM TBS.Table1 WHERE TBS."COLUMN" = 'TEST'