Page 1 of 1

IS NULL in Oracle

Posted: Tue 10 Feb 2009 15:14
by lauris
Hello,

Situation: I have this table FOO:

INSTANCE NOT NULL NUMBER(10)
NAME NOT NULL VARCHAR2(256)
DELETED DATE

and I'm trying to write the following query in LINQ to SQL:

"SELECT * FROM FOO WHERE deleted is null"

I tried:

"from c in context.FOOs where c.DELETED == null select c"

But this is "converted" to

"SELECT * FROM FOO WHERE deleted == null"

and NOT to

"SELECT * FROM dataset WHERE deleted is null"

How can I get "is null" instead of "== null" ?

Thanks,
Lauris

Posted: Wed 11 Feb 2009 12:44
by AndreyR
Thank you for the report, this error was already found. I will let you know as soon as it is fixed.