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'