Nullable fields strange behaviour

Nullable fields strange behaviour

Postby listonic » Wed 14 Dec 2011 09:53

I found a strange behaviour :

I have a nullable bit field in MS SQL.

The value is null.
If i have a query :

(from i in Table
orderby i.Marketid
where i.nullablefield != true)

it does not return any records.
I have to do
(from i in Table
orderby i.Marketid
where i.nullablefield == false || i.nullablefield == null)

It seems like a bug for me.
listonic
 
Posts: 39
Joined: Mon 06 Dec 2010 15:47

Postby StanislavK » Thu 15 Dec 2011 16:17

Thank you for the report, we have reproduced the issue. We will analyze it and inform you about the results as soon as possible.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to LinqConnect (LINQ to SQL support)