IS NULL in Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
lauris
Posts: 1
Joined: Tue 10 Feb 2009 14:42

IS NULL in Oracle

Post by 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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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.

Post Reply