Column Name with #
Posted: Fri 26 Nov 2010 20:46
I'm trying to execute a query to a table that have columns with '#' on name but it don't return any value.
Here is the describe of the table:
Here is the linq that I'm using:
I created a test table with columns without the char '#' and everything works fine.
Do you have some workaround for this?
Best regards,
Henrique
Here is the describe of the table:
Code: Select all
Column Name Null? Type
------------------------------ -------- ----------------
SESSIONID NOT NULL NUMBER
ENTRYID NOT NULL NUMBER
STATEMENT NOT NULL NUMBER
TIMESTAMP# NOT NULL DATE
USERID VARCHAR2(30)
USERHOST VARCHAR2(128)
TERMINAL VARCHAR2(255)
ACTION# NOT NULL NUMBER
Code: Select all
DateTime d1 = new DateTime(2010, 11, 1);
DateTime d2 = new DateTime(2008, 11, 2);
var ret = from log in ctxSiebel.AuditHistoricos
where (log.Action == 101 || log.Action == 102)
&& log.Timestamp >= d1
&& log.Timestamp = :p__linq__0)) AND ("Extent1"."TIMESTAMP#" < :p__linq__1)
Do you have some workaround for this?
Best regards,
Henrique