IS NULL in Oracle

IS NULL in Oracle

Postby lauris » Tue 10 Feb 2009 15:14

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
lauris
 
Posts: 1
Joined: Tue 10 Feb 2009 14:42

Postby AndreyR » Wed 11 Feb 2009 12:44

Thank you for the report, this error was already found. I will let you know as soon as it is fixed.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle