How can i query for null values in entity framework?
- by AZ
I want to execute a query like this
var result = from entry in table
where entry.something == null
select entry;
and get an IS NULL generated.
Edited:
After the first two answers i feel the need to clarify that I'm using Entity Framework
and not Linq to SQL. The object.Equals() method does not seem to work in EF.
Edit no.2:
The above query works as intended. It correctly generates IS NULL. My production code however was
var value = null;
var result = from entry in table
where entry.something == value
select entry;
and the generated SQL was something = @p; @p = NULL. It seems that EF correctly translates the constant expression but if a variable is involved it treats it just like a normal comparison. Makes sense actually. I'll close this question
